Quick Tips–SSMS Select a vertical block
I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool...
2014-05-29
1,660 reads
Blog Posts
The database principal owns a schema in the database, and cannot be dropped
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,547 reads
The End of the Mentoring Experiment
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,284 reads
We’re Giving Away SQLSaturday Orlando Vans!
We’re in full marketing mode here in Orlando, looking for ways to grow attendance for our next SQLSaturday coming up...
2014-05-29
1,424 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
8 reads
Avoiding a split brain in database mirroring
You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means...
2014-05-28 (first published: 2014-05-22)
6,163 reads
Building The SQLSaturday Orlando Marketing Plan-Part 14
Quick notes today:
Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space...
2014-05-28
438 reads
Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
694 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-05-28
375 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one...
2014-05-28
20 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
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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