T-SQL Enhancements: OVER clause
With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of...
2011-08-16
1,457 reads
SQL MCM Training – Day 8
Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...
2011-08-16
752 reads
MCM Training – Day 6 & 7
My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...
2011-08-15
547 reads
When Do You Take a Full Backup?
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-15
777 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,398 reads
Using SSIS lookup transformation editor with millions of rows
If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...
2011-08-15
12,364 reads
I am a Big Bro
The first time I did any volunteering work for PASS was last year at the Summit. I enjoyed doing it....
2011-08-15
1,663 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send...
2011-08-15
20 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method...
2011-08-15
1,331 reads
Micromanaging
Micromanaging is one of those words that evokes an instant negative image. Certainly there are times when it happens, but...
2011-08-15
630 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