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,...

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....

#TribalSQL: A new book by new voices in SQL Server

Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...

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...

PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output

This post explains how to monitor a given service on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets...

Guide to SQL Server Table Indexes – (Part 4)

Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...

Great Idea: Tribal SQL

Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...

Planning for Recovery

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