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

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

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

SQL Saturday #167 – Columbus GA

The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...

SSIS Project Connection Managers

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

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...

Denali – Day 30: Deprecated Features

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but...

Learning Tree: SQL Server DBA Skills Upgrade

I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...