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

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

ALTER INDEX permissions

Developers like to have some control over the development process. An example is index building.  Asking aDBA repeatedly for changes ...

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

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

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

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

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 Server Magazine's Top 10 Blogger....#3

So, it seems that I have been selected by the 2011 SQL Server Community Choice Awards, as among the Top 10...