Backup compression using IBM TDP for SQL Server

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in...

Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

Windows Server Core: Microsoft Server has so many features which is not required...

One Way To Insert Many Rows Very Fast From Your .NET Application

This is my attempt to explain something that I have wanted to figure out for a long time.  I have...

Session Files from SQL Saturday #107 Houston

Session Files from SQL Saturday #107 Houston
Houston Skyline

SQL Saturday Houston was a great event hosted by the Houston Area SQL...

Setting up transactional replication using T-SQL

Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....

SQL Rally 2012 Recap and Session Files

SQL Rally 2012 Recap and Session Files
Dallas Convention Center

SQL Rally 2012 was hosted by the North Texas SQL Server User...

SQL Rally Slide Deck and Photos

I’m working on a more comprehensive review of last week’s SQL Rally event, but I’d like to go ahead and...

SQL Rally Slide Deck and Photos

I’m working on a more comprehensive review of last week’s SQL Rally event, but I’d like to go ahead and...

SQLRally Dallas Slides

I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. ...

The Cloud is Nothing New

Cloud computing doesn’t seem to have any great definition. Like the physical structures is is named for, it is amorphous,...