Destroying a Windows Cluster

I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...

SQL Server 2012 licensing details

AdvertisementsMicrosoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.
 

1.      What is new in SQL...

MS DTC and sys.dm_tran_active_transactions

A  sql reindex command was being blocked by two active transactions in MS DTC.   Use
sys.dm_tran_active_transactions to report more detail on...

Speaking at Spring 2012 SQL Server Connections in Las Vegas

I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...

Running a TPC-C workload on SQL Server

I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...

The Mute the Phone Office Prank

The client I work with as a lot of conference rooms, all with the standard Polycom conference phone that works...

DBA in Space: Behind the Scenes—Question 5

Part 1 of Question 5—The question.Part 2 of Question 5—The follow up to the question.This is a continuation of my...

DBCC WritePage

DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...

SQL Deep Dives 2 on the Kindle

Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes.  I decided I really...

SQL Deep Dives 2 on the Kindle

Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted...