Aggregating With Correlated Sub-Queries #tsql2sday
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz...
2011-03-08
695 reads
Come on Out to OPASS
Tonight is the March OPASS meeting. You should come on out, it’s always a great time. Note our new location...
2011-03-08
814 reads
SQLSaturday#69 - Philadelphia Wrap-Up
Just wanted to take the opportunity to summarize my experience at SQLSaturday#69 in Philadelphia, this past Saturday. Another city, another amazing event! I haven't been...
2011-03-08
2,376 reads
T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!
Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday...
2011-03-08
908 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-08
2,210 reads
March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
652 reads
How to Raise Your Game by Doing Nothing
What if I told you that you could become a more effective Database Administrator by doing nothing?
That’s right, in this...
2011-03-08
487 reads
SQL Server Truncate Table Permissions
I saw a note recently where someone asked what permissions were needed for a user to execute TRUNCATE TABLE. In...
2011-03-07
3,440 reads
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-07
3,376 reads
Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending time with my family. Things aren’t going to be...
2011-03-07
12 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