Manage your SQL Server databases with SQL DMVs

Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....

Planning for Recovery

A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...

SQL 2014 SSMS is Killing my C:

I could hear SQL saying to my C: Drive "Why You Little...." Hello Dear Reader! 

The Blog about SQL Saturday 232 coming...

SQL Server – How to Add More Than One Column as a Primary Key

Sometimes you might want to add more than one column as primary key. For example, if you have three columns...

SQL Server Data Tools (SSDT) – August 2013 update

SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0,...

Understanding SQL Query Optimization – (Part 1)

Most of the activity of the database server is related to queries. Because of this, query optimization is often a...

Understanding SQL Server Full-text Indexing – (Part 1)

SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....

Understanding SQL Server Full-text Indexing – (Part 2)

Checkout the final part of this two part article series here, in which I discussed how to create full-text index...

Understanding SSIS Package Configurations

Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages....

Why Government Required Backdoors Are a Bad Idea

I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...