Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,862 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,305 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,101 reads
Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,305 reads
PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
512 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,346 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
904 reads
MADPASS Follow-Up
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a...
2011-10-10
530 reads
SQL Saturday 98 Follow-Up
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
582 reads
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
892 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