giveaway

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Tim Smith

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.

2017 Awards

2016 Awards

2015 Awards

2014 Awards

Application Development

Key Value Pair Basics for SQL Server Data (5/9/2017)
SQL Server Native Options For Reporting Live Data (5/15/2017)

Auditing and Compliance

Prevent Confidential Data at the Application Layer from getting into SQL Server (9/12/2014)

Azure

Add and Monitor Transparent Data Encryption to AzureSQL Databases (12/23/2016)
Automate Azure File Uploads and File Deletes With PowerShell (6/22/2015)
Automate Retrieving SQL Azure Bacpacs With PowerShell (5/20/2015)
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell (6/4/2015)
Caution - Azure SQL Version 12 Restore Times Take Longer (6/16/2015)
Setting Up Geo-Replication in SQL Azure (12/12/2016)
Solutions for Azure SQL Database Throttle Log Wait of HADR_THROTTLE_LOG_RATE_GOVERNOR (7/26/2016)
Solutions for AzureSQL LOG_RATE_GOVERNOR Waits (10/21/2016)
Three Useful Features In Azure-SQL For Growing Environments (8/1/2016)
Troubleshoot SQL Azure Bacpac Import Failures (7/31/2015)
Using Azure For Testing POCs and Designs With Lessons Learned (3/16/2017)

Backup

Automate Tracking SQL Server Backup Times with PowerShell (12/18/2014)
Verify SQL Server Backups Existence in the File System with PowerShell (3/17/2015)

Compression

SQL Server Table and Index Compression Information With PowerShell (1/5/2015)

Data Types

Handling error converting data type varchar to numeric in SQL Server (9/3/2015)

Database Administration

Finding SQL Server Objects that don't conform to Standards using PowerShell (10/7/2014)
Monitor SQL Server Database Size, Growth and Expected Growth with PowerShell (11/12/2014)
SQL Server Archive and Data Retention Considerations (7/14/2015)
SQL Server Video on Database Growth (11/17/2014)
Troubleshoot TFS SQL Server Slowdowns (7/11/2016)

Database Consistency Checks DBCCs

SQL Server Database Integrity Check Best Practices (5/11/2016)

Dates

Handling Special Dates For SQL Server Metrics (12/1/2016)

DBA Best Practices

Automate Removal of Saved SQL Server Objects During Deployments (5/30/2016)
T-SQL and PowerShell Documentation With Gists (4/26/2016)

Disaster Recovery

Simulating SQL Server Disaster Recovery Drills (7/1/2016)

Functions - User Defined UDF

How To Calculate Behavioral Streaks in SQL Server Data (5/4/2015)

Hardware

Automate file cleanup on SQL Server drives using PowerShell (2/16/2016)

Import and Export

Automating Flat File SQL Server Imports With PowerShell (4/30/2014)
Best Practices For Building Alerts for Using APIs with SQL Server (8/19/2016)
Pre-Validating Data with PowerShell Before Importing to SQL Server (6/2/2014)
SQL Server Data Import System to Alert For Missed Imports (12/9/2014)
SQL Server Stored Procedure to remove outliers from data sets (5/19/2014)
SQL Server Video to Pre-Validate Data with PowerShell Before Importing (7/29/2014)
SQL Server Video to Remove Outliers from Data Sets (7/23/2014)
Techniques to Cleanse Bad Data in SQL Server (6/23/2017)
Techniques to handle timing issues and inconsistent data for SQL Server data loads (2/14/2017)
Troubleshooting Common SQL Server Bulk Insert Errors (5/13/2015)
Validate File Properties with PowerShell Prior to Import into SQL Server (5/6/2014)

Integration Services Development

Loop through Flat Files in SQL Server Integration Services (3/4/2013)

Maintenance

Automate Out of Date SQL Server Statistics with PowerShell (3/9/2016)

Monitoring

Monitor a Windows Service Interacting with SQL Server (5/23/2017)

PowerShell

4 Convenient Ways To Run PowerShell Scripts (3/3/2016)
6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers (12/1/2014)
Consider New Ideas for SQL Server Data Analysis (4/2/2015)
Executing scripts on multiple servers by SQL Server version and edition using PowerShell (3/4/2015)
Extract and convert all Excel worksheets into CSV files using PowerShell (5/12/2014)
Extracting API Data Using PowerShell and Loading into SQL Server (2/3/2015)
Limit Time Ranges In PowerShell for Calculations (3/15/2016)
PowerShell and ADO.NET Connection String Settings for SQL Server (8/28/2015)
PowerShell and Object-Level Math Functions (3/28/2017)
PowerShell and T-SQL Regular Expression Examples for SQL Server (9/24/2014)
PowerShell Parameters Part II - ValidateSet and ValidatePattern (4/19/2016)
PowerShell Regular Expression (RegEx) Video Examples for SQL Server (9/29/2014)
Reading Text Files With PowerShell For Configurations Part I (6/10/2015)
Rename and Move a File with PowerShell in a SQL Server Agent Job (4/21/2014)
SQL Server Video Automating Flat File Imports using PowerShell (6/18/2014)
SQL Server Video to Extract All Excel Worksheets into individual CSV files (8/6/2014)
SQL Server Video to Rename and Move a File using PowerShell (6/12/2014)
SQL Server Video Validate File Properties Prior to Importing Data (7/7/2014)
Update SQL Server Agent Job owner and Database owner with PowerShell (6/20/2016)
Use PowerShell to Determine the number DML operations in SQL Server Scripts (9/15/2016)
Using PowerShell To Record SQL Server Virtual Log File (VLF) Growth (1/27/2016)
Using PowerShell With Configuration Tables in SQL Server (3/10/2015)
Validating PowerShell Parameters - Part I (4/1/2016)
Video of 6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers (12/12/2014)
Video on Text Mining SQL Server Data Using PowerShell (10/20/2014)

Professional Development Career Planning

SQL Server Database Development Career Questions (10/24/2014)

Professional Development Interview Questions Developer

Interview Questions for Hiring PowerShell Database Developers (4/9/2015)

Profiler and Trace

Automate Trace Imports With PowerShell (1/12/2015)

Replication

Addressing SQL Server Replication Violation of Primary Key Errors (10/28/2016)
Aggregate Functions to Validate Data for SQL Server Replication and ETL Processes (4/13/2016)
Queries For Debugging Bi-Directional SQL Server Merge Replication (5/2/2016)
Queries To Debug SQL Server Replication Issues (2/2/2016)
Queries to Monitor SQL Server Replication Backlog (2/24/2016)
Solving Table Drop Error Related to SQL Server Replication's sp_MStran_ddlrepl (3/7/2017)
Tracking SQL Server Replication Metadata Changes (5/1/2017)
Tracking SQL Server Replication Subscriber Schema Changes Disrupting Data Flow (6/8/2016)
Using PowerShell for SQL Server Replication Tracking (1/19/2016)

Restore

Time Testing SQL Azure Point In Time Database Restores (4/20/2015)

Security

Protect Confidential SQL Server Data Q and A (9/17/2014)
Reflect on SQL Server Security Considerations After Recent Breaches (4/3/2017)

SQL Server Agent

Find SQL Server Agent Jobs That Exist on One Instance and Not on Another Instance (11/24/2014)
Using SMO With PowerShell To Obtain SQL Server Job Information (7/21/2015)

Stored Procedures

Finding SQL Server objects that reference invalid objects (6/23/2014)
Finding Unused SQL Server Stored Procedures With PowerShell (6/30/2014)
SQL Server T-SQL Stored Procedure Design to Handle Varying Default Values (10/12/2016)
SQL Server video to find objects that reference invalid objects (9/9/2014)

T-SQL

Auto Rename SQL Server Tables and Their References with PowerShell (7/18/2014)
Calculating Median Absolute Deviation with T-SQL Code in SQL Server (9/1/2016)
PowerShell and Text Mining Part I: Word Counts, Positions and Libraries (10/16/2014)
Reporting Techniques With SQL Server Text Mining (Part II) (11/5/2014)
Simple T-SQL Code Comparison With PowerShell (7/15/2016)
Summarize Metrics with SQL Server T-SQL Code (5/24/2016)
Two T-SQL Alternatives For Tracking Changes (2/23/2017)

Triggers

Disable SQL Server Triggers with PowerShell (9/5/2016)

More SQL Server Solutions