Using PowerShell to Encode Files
In this tip we will look at the basics of file encoding, both for reading and writing using PowerShell.
Tim consults for FinTek Development and teaches the course Automating ETL on Udemy. He's worked with technology since high school, helping his school win its first TCEA award and continues to work in automation, data architecture, back-end development, and smart contract architecture. Tim enjoys testing new technologies early in the diffusion of innovation curve and was an early adopter of NoSQL and smart contract development. He has a blog at http://www.fintekdev.com/ and helps contribute to local technical and financial events in Texas.
Sequential Execution of SQL Server Stored Procedures
In this tip we look at ways to control the flow of SQL Server stored procedures to make sure things are processed in sequence using T-SQL and PowerShell.
Call SQL Server Stored Procedures with PowerShell Parameter Objects
In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure.
Getting Started with PowerShell File Properties and Methods
In this tip we look at how to use PowerShell scripts to work with files to get properties, copy, update and delete.
Execute SQL Server Stored Procedures from PowerShell
In this tip we will look at getting started using PowerShell with stored procedures.
Create File with Content Using PowerShell
In this tip we look at some PowerShell commands you can use to create file contents whether directly entered or queried from a SQL Server database.
Verify File Exists Using PowerShell
In this tip we look at a PowerShell script that can be used to compare actual files that exist against a list of files that should exist for a project to identify any missing files.
SQL Server T-SQL Alerts for Standard and Custom Errors
In this tip we look at some approaches and queries you can use to log error messages and then use these scripts to find and send custom notifications based on the errors.
Validate Dynamic SQL to Prevent SQL Injection in SQL Server
Learn some tips on how to validate that the values passed into a process that builds dynamic SQL are valid prior to running the dynamic code.
Find All SQL Server Triggers to Quickly Enable or Disable
In this tip we look at some queries that will help you find all of your database triggers along with code to disable and enable specific triggers prior to data loads.
Considering Derived Values In ETL Flows
Learn how to generate derived values for ETL steps efficiently as part of the transformation steps.
Options For Reporting Errors In Catch Statements Using PowerShell
In this tip we look at some ways you can add logic to your PowerShell scripts to catch errors in your scripts.
Develop and Debug PowerShell Scripts with MyInvocation
In this tip we look at how to use an object that PowerShell provides called MyInvocation. This can assist us with debugging PowerShell code as well as getting some useful information.
Review Minimum SQL Server Security Practices
In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.
Detecting Write-Protection Changes On Disks that Cause File Access Errors
In this tip we look at a way to detect if a folder is write protected. This can be an issue when trying to write out data from SQL Server to the file system or even accessing database files that might be in a write protected folder.
How to Query Arrays, Hash Tables and Strings with PowerShell
In this tip we'll look at working with common PowerShell objects for sets, such as arrays, hash tables, and in some cases strings.
SQL Server Bulk Insert For Full Files, Misformatted Data and Unusual Characters
In this tip we look at how to handle importing data into SQL Server when we have misformatted data and unusual characters in the data.
The Pros and Cons of Using T-SQL Soft Transactions
In this article we look at the pros and cons of using soft transactions for SQL Server data using T-SQL.
Getting the Count of Non-Null Values in a SQL Server Table with PowerShell
In this tip we look at how we can use PowerShell to analyze the frequency of NULL values in our dataset to see if the data will still be valid based on frequency.
Pre-validating Data in Delimited Files with PowerShell Prior to Importing to SQL Server
In this tip we look at some techniques you can use to pre-validate data in delimited text files using PowerShell prior to importing the data into SQL Server.
Parsing Strings From Delimiters In PowerShell
In this tip we look at how to use PowerShell to parse character data that has delimiters.
Solutions to Track Delayed SQL Server Transaction Latency
In this tip we look at ways to identify latency issues when loading data into SQL Server databases.
Zip and Copy SQL Server Backup Files with PowerShell
In this tip we look at how we can backup and zip up SQL Server backup files using PowerShell.
4 Factors When Choosing to Automate SQL Server Tasks
Learn about four factors when choosing to automate SQL Server tasks including time savings, security vulnerabilities, data validation and manual interventions.