A new neat feature in SQL Server 2012 is THROW

In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...

After August, I'm Done Traveling for the Year

I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the...

Building a SQL Server Inventory – Part 1

Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...

Building a SQL Server Inventory – Part 2

Last time I went through my script to gather server information for my inventory. Today I’m going to go through...

Cross Database Views and Schema Binding

One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms.  Sure...

DBCC CHECKDB

Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...

Denali – Day 31: Discontinue and Breaking/Behavior change features

Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that...

How to Give your .NET application HA

By David Postlethwaite
I was at a meeting the other week when someone mentioned that you could specify two SQL Servers...

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)

One of...

Never, Ever Use Clustered Indexes

This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...