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
Develop and Debug PowerShell Scripts with MyInvocation PowerShell2018-12-18
Review Minimum SQL Server Security Practices Security2018-12-07
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
Using Nested Switch Statements In PowerShell PowerShell2018-04-24
Regular Expressions with T-SQL Summary 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
Using Regular Expressions With T-SQL: From Beginner To Advanced TSQL2018-04-06
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert Import and Export2018-02-19
Tracking Execution Times for SSIS Packages Integration Services Performance2018-01-04
SQL Server Clustered Columnstore Index Examples for ETL Indexing2017-12-20
PowerShell and Hash Table Examples PowerShell2017-11-23
Best Practices for Validating Applications With Database Architecture Application Development2017-11-07
Debugging PowerShell Scripts PowerShell2017-10-11
Using SQL Server In-Memory Tables Within ETL Architecture In Memory OLTP2017-09-15
Using PowerShell to Check or Compare Values PowerShell2017-09-05
PowerShell Scripts for Obtaining File Metadata PowerShell2017-08-30
Monitor a Windows Service Interacting with SQL Server Monitoring2017-05-23
Key Value Pair Basics for SQL Server Data Application Development2017-05-09
Tracking SQL Server Replication Metadata Changes Replication2017-05-01
Solving Table Drop Error Related to SQL Server Replication’s sp_MStran_ddlrepl Replication2017-03-07
Add and Monitor Transparent Data Encryption to Azure SQL Databases Azure SQL Database2016-12-23
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
Disable SQL Server Triggers with PowerShell Triggers2016-09-05
Calculating Median Absolute Deviation with T-SQL Code in SQL Server TSQL2016-09-01
Solutions for Azure SQL Database Throttle Log Wait of HADR_THROTTLE_LOG_RATE_GOVERNOR Azure SQL Database2016-07-26
Troubleshoot TFS SQL Server Slowdowns Database Administration2016-07-11
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
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
PowerShell Parameters Part II – ValidateSet and ValidatePattern PowerShell2016-04-19
Validating PowerShell Parameters – Part I PowerShell2016-04-01
4 Convenient Ways To Run PowerShell Scripts PowerShell2016-03-03
Queries to Monitor SQL Server Replication Backlog Replication2016-02-24
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
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
Consider New Ideas for SQL Server Data Analysis PowerShell2015-04-02
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
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
Monitor SQL Server Database Size and Growth with PowerShell Database Administration2014-11-12
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 and T-SQL Regular Expression Examples for SQL Server PowerShell2014-09-24
Auto Rename SQL Server Tables and Their References with PowerShell TSQL2014-07-18
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 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
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