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

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

Data Warehouse vs Data Mart

I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart....

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF

As there has been so many DMV/DMF already introduced in earlier version of Sql server,...

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