Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would...
2011-07-06
729 reads
Denali’s Skeletons in the closet, Part I
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
466 reads
Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,507 reads
July Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,048 reads
How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
834 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,661 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,387 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,006 reads
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
921 reads
PASS SQL Rally 2011 Evaluations
In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals...
2011-07-05
938 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