Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug

Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...

Adelaide SQL Server User Group Slides and Scripts

You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...

Re-blog – November 18 – November 24

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer...

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

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