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...
2011-11-24
2,238 reads
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,...
2011-11-23
1,095 reads
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...
2011-11-23
7,991 reads
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...
2011-11-23
669 reads
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...
2011-11-23
601 reads
DBCC WritePage
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,850 reads
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...
2011-11-23
7 reads
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...
2011-11-23
788 reads
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...
2011-11-23
1,383 reads
ALTER INDEX permissions
Developers like to have some control over the development process. An example is index building. Asking aDBA repeatedly for changes ...
2011-11-23
1,073 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers