SSIS Project Connection Managers

With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...

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

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

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

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

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)

When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...

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

No More SQLRally In the US

I was disappointed to see the mention in the Connector today that there would be no SQLRally  2013 in the...

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

Syncing your calendars

I have a desktop computer, a laptop, and a iPhone.  I frequently add meetings to my Outlook calender on my...