Tim Smith

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.
Title Category Date
Loop through Flat Files in SSIS Integration Services Development2025-04-15
Using PowerShell to Encode Files PowerShell2019-05-21
Sequential Execution of SQL Server Stored Procedures Stored Procedures2019-05-02
Call SQL Server Stored Procedures with PowerShell Parameter Objects PowerShell2019-04-22
Getting Started with PowerShell File Properties and Methods PowerShell2019-04-02
Execute SQL Server Stored Procedures from PowerShell PowerShell2019-03-18
Create File with Content Using PowerShell PowerShell2019-03-05
Verify File Exists Using PowerShell PowerShell2019-02-19
SQL Server T-SQL Alerts for Standard and Custom Errors Monitoring2019-02-08
Validate Dynamic SQL to Prevent SQL Injection in SQL Server SQL Injection2019-01-28
Find All SQL Server Triggers to Quickly Enable or Disable Triggers2019-01-10
Considering Derived Values In ETL Flows Import and Export2018-12-31
Options For Reporting Errors In Catch Statements Using PowerShell PowerShell2018-12-27
Develop and Debug PowerShell Scripts with MyInvocation PowerShell2018-12-18
Review Minimum SQL Server Security Practices Security2018-12-07
Detecting Write-Protection Changes On Disks that Cause File Access Errors Database Administration2018-09-18
How to Query Arrays, Hash Tables and Strings with PowerShell PowerShell2018-08-13
SQL Server Bulk Insert For Full Files, Misformatted Data and Unusual Characters Import and Export2018-08-01
The Pros and Cons of Using T-SQL Soft Transactions Database Design2018-07-18
Getting the Count of Non-Null Values in a SQL Server Table with PowerShell PowerShell2018-07-03
Pre-validating Data in Delimited Files with PowerShell Prior to Importing to SQL Server PowerShell2018-06-26
Parsing Strings From Delimiters In PowerShell PowerShell2018-06-21
Solutions to Track Delayed SQL Server Transaction Latency Import and Export2018-06-05
Zip and Copy SQL Server Backup Files with PowerShell Backup2018-05-21
4 Factors When Choosing to Automate SQL Server Tasks Database Administration2018-05-09
Using Nested Switch Statements In PowerShell PowerShell2018-04-24
Preventing Invalid Data Early In An ETL Flow Import and Export2018-04-10
Using Regular Expressions With T-SQL: From Beginner To Advanced TSQL2018-04-06
Introduction to Alphabetic Regular Expressions for T-SQL TSQL2018-04-06
Precise Alphabetic Filtering With Regular Expressions for T-SQL TSQL2018-04-06
Case Sensitivity and Regular Expressions for T-SQL TSQL2018-04-06
Introduction to Numeric Regular Expressions for T-SQL TSQL2018-04-06
Precise Numerical Filtering With Regular Expressions for T-SQL TSQL2018-04-06
Using Regular Expressions to Find Special Characters with T-SQL TSQL2018-04-06
Excluding Characters With Regular Expressions with T-SQL TSQL2018-04-06
Regular Expressions Business Case Examples with T-SQL TSQL2018-04-06
Regular Expressions with T-SQL Summary TSQL2018-04-06
T-SQL Techniques For Mapping Ceteris Paribus Variables TSQL2018-03-26
Improve SQL Server Logging to Reduce Space and Troubleshooting Time Monitoring2018-03-07
Finding Spreads in Data Ranges Using T-SQL TSQL2018-02-27
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert Import and Export2018-02-19
Building Smarter Scripts for SQL Server Data Updates Database Administration2018-02-01
Executing Code Every Nth Percent of the Time with T-SQL TSQL2018-01-22
Retaining File Information for ETL Security Analysis Security2018-01-10
Tracking Execution Times for SSIS Packages Integration Services Performance2018-01-04
Execute and Track T-SQL Script Executions with PowerShell Database Administration2017-12-29
Retaining ETL Data from Files, APIs and Data Feeds Import and Export2017-12-26
SQL Server Clustered Columnstore Index Examples for ETL Indexing2017-12-20
T-SQL: Capture Related Data and Return By Aggregates Functions System2017-12-07
PowerShell and Hash Table Examples PowerShell2017-11-23
Best Practices for Validating Applications With Database Architecture Application Development2017-11-07
Using T-SQL for Finding Narrowing Ranges of Data TSQL2017-10-18
Debugging PowerShell Scripts PowerShell2017-10-11
Using SQL Server In-Memory Tables Within ETL Architecture In Memory OLTP2017-09-15
What technologies are available in SQL Server to support ETL? Import and Export2017-09-12
Using PowerShell to Check or Compare Values PowerShell2017-09-05
PowerShell Scripts for Obtaining File Metadata PowerShell2017-08-30
3 Solutions For Auditing Long SQL Server Extracts or Loads Import and Export2017-06-27
Techniques to Cleanse Bad Data in SQL Server Import and Export2017-06-23
Monitor a Windows Service Interacting with SQL Server Monitoring2017-05-23
SQL Server Native Options For Reporting Live Data Application Development2017-05-15
Key Value Pair Basics for SQL Server Data Application Development2017-05-09
Tracking SQL Server Replication Metadata Changes Replication2017-05-01
Reflect on SQL Server Security Considerations After Recent Breaches Security2017-04-03
PowerShell and Object-Level Math Functions PowerShell2017-03-28
Using Azure For Testing POCs and Designs With Lessons Learned Azure2017-03-16
Solving Table Drop Error Related to SQL Server Replication’s sp_MStran_ddlrepl Replication2017-03-07
Two T-SQL Alternatives For Tracking Changes TSQL2017-02-23
Techniques to handle timing issues and inconsistent data for SQL Server data loads Import and Export2017-02-14
Add and Monitor Transparent Data Encryption to Azure SQL Databases Azure SQL Database2016-12-23
Setting Up Geo-Replication in SQL Azure Azure2016-12-12
Handling Special Dates For SQL Server Metrics Dates2016-12-01
Addressing SQL Server Replication Violation of Primary Key Errors Replication2016-10-28
Solutions for AzureSQL LOG_RATE_GOVERNOR Waits Azure2016-10-21
SQL Server T-SQL Stored Procedure Design to Handle Varying Default Values Stored Procedures2016-10-12
Use PowerShell to Determine the number DML operations in SQL Server Scripts PowerShell2016-09-15
Disable SQL Server Triggers with PowerShell Triggers2016-09-05
Calculating Median Absolute Deviation with T-SQL Code in SQL Server TSQL2016-09-01
Best Practices For Building Alerts for Using APIs with SQL Server API2016-08-19
Three Useful Features In Azure-SQL For Growing Environments Azure2016-08-01
Solutions for Azure SQL Database Throttle Log Wait of HADR_THROTTLE_LOG_RATE_GOVERNOR Azure SQL Database2016-07-26
Simple T-SQL Code Comparison With PowerShell TSQL2016-07-15
Troubleshoot TFS SQL Server Slowdowns Database Administration2016-07-11
Simulating SQL Server Disaster Recovery Drills Disaster Recovery2016-07-01
Update SQL Server Agent Job owner and Database owner with PowerShell PowerShell2016-06-20
Track SQL Replication Subscriber Schema Changes Disrupting Data Flow Replication2016-06-08
Automate Removal of Saved SQL Server Objects During Deployments DBA Best Practices2016-05-30
Summarize Metrics with SQL Server T-SQL Code TSQL2016-05-24
SQL Server Database Integrity Check Best Practices Database Console Commands DBCCs2016-05-11
Queries For Debugging Bi-Directional SQL Server Merge Replication Replication2016-05-02
T-SQL and PowerShell Documentation With Gists DBA Best Practices2016-04-26
PowerShell Parameters Part II – ValidateSet and ValidatePattern PowerShell2016-04-19
Aggregate Functions to Validate Data for SQL Server Replication and ETL Processes Replication2016-04-13
Validating PowerShell Parameters – Part I PowerShell2016-04-01
Limit Time Ranges In PowerShell for Calculations PowerShell2016-03-15
Automate Out of Date SQL Server Statistics with PowerShell Maintenance2016-03-09
4 Convenient Ways To Run PowerShell Scripts PowerShell2016-03-03
Queries to Monitor SQL Server Replication Backlog Replication2016-02-24
Automate file cleanup on SQL Server drives using PowerShell Hardware2016-02-16
Queries To Debug SQL Server Replication Issues Replication2016-02-02
Using PowerShell To Record SQL Server Virtual Log File (VLF) Growth PowerShell2016-01-27
Using PowerShell for SQL Server Replication Tracking Replication2016-01-19
Handling error converting data type varchar to numeric in SQL Server Data Types2015-09-03
PowerShell and ADO.NET Connection String Settings for SQL Server PowerShell2015-08-28
Troubleshoot SQL Azure Bacpac Import Failures Azure2015-07-31
Using SMO With PowerShell To Obtain SQL Server Job Information SQL Server Agent2015-07-21
SQL Server Archive and Data Retention Considerations Database Administration2015-07-14
Automate Azure File Uploads and File Deletes With PowerShell Azure2015-06-22
Caution – Azure SQL Version 12 Restore Times Take Longer Azure Backup and Restore2015-06-16
Reading Text Files With PowerShell For Configurations Part I PowerShell2015-06-10
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell Azure2015-06-04
Automate Retrieving SQL Azure Bacpacs With PowerShell Azure Backup and Restore2015-05-20
Troubleshooting Common SQL Server Bulk Insert Errors Import and Export2015-05-13
How To Calculate Behavioral Streaks in SQL Server Data Functions User Defined UDF2015-05-04
Time Testing SQL Azure Point In Time Database Restores Restore2015-04-20
Interview Questions for Hiring PowerShell Database Developers Developer Interview Questions2015-04-09
Consider New Ideas for SQL Server Data Analysis PowerShell2015-04-02
Verify SQL Server Backups Existence in the File System with PowerShell Backup2015-03-17
Using PowerShell With Configuration Tables in SQL Server PowerShell2015-03-10
Executing scripts on multiple servers by SQL Server version and edition using PowerShell PowerShell2015-03-04
Extracting API Data Using PowerShell and Loading into SQL Server API2015-02-03
Automate Trace Imports With PowerShell Profiler and Trace2015-01-12
SQL Server Table and Index Compression Information With PowerShell Compression2015-01-05
Automate Tracking SQL Server Backup Times with PowerShell Backup2014-12-18
Video of 6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers PowerShell2014-12-12
SQL Server Data Import System to Alert For Missed Imports Import and Export2014-12-09
6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers PowerShell2014-12-01
Find SQL Server Agent Jobs That Exist on One Instance and Not on Another Instance SQL Server Agent2014-11-24
SQL Server Video on Database Growth Database Administration2014-11-17
Monitor SQL Server Database Size and Growth with PowerShell Database Administration2014-11-12
Reporting Techniques With SQL Server Text Mining (Part II) TSQL2014-11-05
SQL Server Database Development Career Questions Career Planning2014-10-24
Video on Text Mining SQL Server Data Using PowerShell PowerShell2014-10-20
PowerShell and Text Mining Word Counts, Positions and Libraries TSQL2014-10-16
Finding SQL Server Objects that don’t conform to Standards using PowerShell Database Administration2014-10-07
PowerShell Regular Expression (RegEx) Video Examples for SQL Server PowerShell2014-09-29
PowerShell and T-SQL Regular Expression Examples for SQL Server PowerShell2014-09-24
Protect Confidential SQL Server Data Q and A Security2014-09-17
Prevent Confidential Data at the Application Layer from getting into SQL Server Auditing and Compliance2014-09-12
SQL Server video to find objects that reference invalid objects Stored Procedures2014-09-09
SQL Server Video to Extract All Excel Worksheets into individual CSV files PowerShell2014-08-06
SQL Server Video to Pre-Validate Data with PowerShell Before Importing Import and Export2014-07-29
SQL Server Video to Remove Outliers from Data Sets Import and Export2014-07-23
Auto Rename SQL Server Tables and Their References with PowerShell TSQL2014-07-18
SQL Server Video Validate File Properties Prior to Importing Data PowerShell2014-07-07
Finding Unused SQL Server Stored Procedures With PowerShell Stored Procedures2014-06-30
Finding SQL Server objects that reference invalid objects Stored Procedures2014-06-23
SQL Server Video Automating Flat File Imports using PowerShell PowerShell2014-06-18
SQL Server Video to Rename and Move a File using PowerShell PowerShell2014-06-12
Pre-Validating Data with PowerShell Before Importing to SQL Server Import and Export2014-06-02
SQL Server Stored Procedure to remove outliers from data sets Import and Export2014-05-19
Extract and convert all Excel worksheets to CSV files with PowerShell PowerShell2014-05-12
Validate File Properties with PowerShell Prior to Import into SQL Server Import and Export2014-05-06
Automating Flat File SQL Server Imports With PowerShell Import and Export2014-04-30
Rename and Move a File with PowerShell in a SQL Server Agent Job PowerShell2014-04-21