T-SQL Enhancement: EXECUTE WITH RESULT SETS
All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse...
2011-07-05
802 reads
SQL Server on steroids with RAM disk
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,596 reads
Select from a table with no rows returned.
G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...
2011-07-04
5,014 reads
Wild West Day
One of the things I’m missing today is Wild West Day at Red Gate. It’s not just because I don’t...
2011-07-04
1,598 reads
How to re-create database quickly
I was running some database unit tests and needed to drop completely everyhing in my database. There are really many...
2011-07-04
684 reads
2011 SQL Server MVP Award
Thanks Microsoft for awarding me the MVP for SQL Server for the third year in a row. It’s a great...
2011-07-04
610 reads
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
741 reads
Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
679 reads
Non-Convergence of Replicated Data
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
868 reads
Bloopers
An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and...
2011-07-01
1,368 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