Pain of the Week: Understanding Your Indexes
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
891 reads
Miss SQLBits 8? No problem, all videos are online
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all...
2011-06-28
875 reads
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
564 reads
Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
616 reads
Let’s Get Registered! Registered!
The PASS Summit is only a few short months away. But before that happens there is an important deadline fast...
2011-06-28
679 reads
HASHBYTES – A T-SQL Function
Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.....
2011-06-28
15,128 reads
Instead Of Trigger and OUTPUT clause headache
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead...
2011-06-28
1,832 reads
Which database is using all my CPU
We all know how easy it is to see how much CPU power is consumed by the SQL Server process,...
2011-06-28
1,670 reads
My Favourite SQL Server Myths and Realities
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...
2011-06-28
3,808 reads
Counting Licenses for VMs
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought...
2011-06-28
3,146 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
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