Using Nested Switch Statements In PowerShell
In this tip we take a look at how we can use IF and SWITCH statements within our PowerShell code to process text data.
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.
Preventing Invalid Data Early In An ETL Flow
In this tip we will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.
Using Regular Expressions With T-SQL: From Beginner To Advanced
In this section we take a look at the items in this tutorial that will be covered for using regular expressions with T-SQL.
Introduction to Alphabetic Regular Expressions for T-SQL
In this section we look at simple examples of how to build a regular expression to use with T-SQL data.
Precise Alphabetic Filtering With Regular Expressions for T-SQL
In this tutorial we look at more complex expressions to find specific text patters using regex with T-SQL.
Case Sensitivity and Regular Expressions for T-SQL
In this section of the tutorial we look at how we can use regex to find case sensitive data.
Introduction to Numeric Regular Expressions for T-SQL
In this tutorial we look at how to write regex to find numbers using T-SQL.
Precise Numerical Filtering With Regular Expressions for T-SQL
In this section we look at number patterns that can be found using regex.
Using Regular Expressions to Find Special Characters with T-SQL
In this tutorial we look at how we can find special characters using regex with T-SQL.
Excluding Characters With Regular Expressions with T-SQL
In this section we look at how to exclude data using the NOT symbol for regex.
Regular Expressions Business Case Examples with T-SQL
In this section of the tutorial we look at specific business cases like patterns for email, url, credit card, ssn, dates and more.
Regular Expressions with T-SQL Summary
This summarizes the regular expressions tutorial for SQL Server.
T-SQL Techniques For Mapping Ceteris Paribus Variables
In this tip we look at how to use T-SQL techniques to map Ceteris Paribus variables.
Improve SQL Server Logging to Reduce Space and Troubleshooting Time
In this tip we look at a few techniques you can use to help when using logging information you create for troubleshooting and fixing issues.
Finding Spreads in Data Ranges Using T-SQL
In this tip we look at how to use different T-SQL functions to identify spreads in ranges of data.
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
In this tip we look at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.
Building Smarter Scripts for SQL Server Data Updates
Check out this tip to learn how to design smarter scripts when doing maintenance updates against your database tables.
Executing Code Every Nth Percent of the Time with T-SQL
In this tip, we'll look at one way to structure different probabilities happening in situations where we may want outcomes every Nth percent of a time.
Retaining File Information for ETL Security Analysis
In this tip we look at how to ensure our ETL files are not being tampered with prior to importing data.
Tracking Execution Times for SSIS Packages
Read this tip to learn how to capture SSIS execution times for packages.
Execute and Track T-SQL Script Executions with PowerShell
Check out this tip to learn how to use PowerShell to deploy database changes.
Retaining ETL Data from Files, APIs and Data Feeds
In this tip we look at a few ways source data can be retained.
SQL Server Clustered Columnstore Index Examples for ETL
Learn about when to consider using SQL Server Clustered Columnstore Index for ETL processes and when other alternatives may yield better performance.
T-SQL: Capture Related Data and Return By Aggregates
In this tip we cover a T-SQL process to collect right and wrong answers to questions to help use these data points for better decision making.