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

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

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

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

There was a great deal of feedback to my previous post One Way To Insert Many Rows Very Fast From...

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

Enter the 2012 Exceptional DBA of the Year Awards

I was just at SQLRally in Dallas, and I was speaking to a DBA friend of mine over lunch. He...

Create a Filestream Filegroup for Filetables – SQL Server 2012

Once you’ve enabled filestream, the next step is to add a filegroup to your database to hold the filestream data....

PASS Data Architecture VC presents Mike Fal: SQL Server Table Partitioning

Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...