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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Jeffrey Yao

Jeffrey Yao

Jeffrey Yao is a senior SQL Server consultant with 15 years of database administration, his current interests are on database administration automation and visualization. He enjoys reading the concise and smart sql tips and loves R&D work in DBA Engineering topics. His blog is at: http://www.sqlservercentral.com/blogs/jeffrey_yao/.

2017 Awards

2016 Awards

2015 Awards

2014 Awards

Backup

Exploring SQL Server Table Backup Methods (4/21/2017)

Comparison Data and Objects

Finding SQL Server Table and Data Differences using PowerShell (11/15/2016)
SQL Server Database Schema Synchronization via SQLPackage.exe and PowerShell (4/4/2017)

Constraints

Script to Delete Data from SQL Server Tables with Foreign Key Constraints (10/15/2015)

Database Administration

Automatically Build a SQL Server Script Database Library from Your Script Files (11/24/2015)
Copy a SQL Server database with just the objects and no data (2/1/2017)
Generate INSERT scripts from SQL Server queries and stored procedure output (5/13/2016)
Introduction to C# Scripting for SQL Server DBAs (11/18/2016)

Database Mail

Generate HTML Formatted Emails from SQL Server (9/23/2015)

Dates

SQL Server Date Time Calculation Examples (2/13/2015)

Error Logs

Cycle SQL Server Error Logs based on size using PowerShell (5/13/2014)

High Availability

Find SQL Server Downtime Window After Reboot (6/25/2014)

Import and Export

Adding more functionality to SQL Server BCP with PowerShell (6/29/2016)
Copy data to another SQL Server instance without a Linked Server (3/1/2017)
Dynamically Generate SQL Server BCP Format Files (9/30/2016)
Excel File Data Validation for SQL Server Imports (9/3/2015)

Locking and Blocking

Detect and Automatically Kill Low Priority Blocking Sessions in SQL Server (7/16/2014)

Performance Tuning

Automatically Generate Performance Counter Graphs with SQL Server 2016 and R (4/12/2017)

PowerShell

Professional Development Career

The 6 Rules to be a Happy SQL Server DBA (6/12/2017)

Professional Development Interview Questions DBA

PowerShell Interview Questions for SQL Server DBAs (6/8/2016)
Senior SQL Server DBA non-technical interview questions (6/10/2015)

Professional Development Interview Questions Developer

T-SQL Interview Questions for Senior Developers (11/2/2016)

Professional Development Interviewing

Technical Interview Questions for a Senior SQL Server DBA (1/18/2017)

Professional Development Skills Development

How to Grow Your SQL Server DBA Career (5/7/2015)

Replication

Auto Fix SQL Server Transactional Replication Error 20598 for DELETEs (10/23/2014)
Auto Fix SQL Server Transactional Replication Error 20598 for UPDATEs (9/30/2014)
Monitoring SQL Server Transactional Replication Latency via PowerShell and RMO (5/27/2015)

Security

Cloning a SQL Server Login with all permissions using PowerShell (11/22/2016)
Script to drop SQL Server login and all owned objects using PowerShell (8/13/2014)
SQL Server Functions to Mask Confidential Data using CLR or PowerShell (12/12/2016)

SQL Server 2016

Easily Import CSV Files with R in SQL Server 2016 (2/16/2017)
SQL Server 2016 Regular Expressions with the R Language (3/29/2017)
Visual SQL Server Performance Data Comparison with R (5/19/2017)

SQL Server Agent

SQL Server Agent Job Advanced Management (8/24/2016)

SQL Server Configurations

Inventory SQL Server Services Version and Edition (3/11/2015)

SQL Server Management Studio

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS) (7/1/2014)

T-SQL

Advanced Use of the SQL Server ORDER BY Clause (3/15/2017)
Delete Files with SQL Server 2016 R Logic in T-SQL Code (2/8/2017)
Implement a Comment Based Help Framework via CLR Stored Procedure (3/21/2017)

Testing

Generate Random Strings with High Performance with a SQL CLR function (4/17/2015)

More SQL Server Solutions