August Meme Monday – Crap Code
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think...
2011-08-01
791 reads
Rolling your own index lookups
Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to...
2011-08-01
1,344 reads
August Question: How Do You Manage Your Transact-SQL Scripts?
Whether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been...
2011-08-01
828 reads
SQL Server “Denali”: Project Apollo
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,679 reads
Notes from SQLSaturday #81
I started by journey to Birmingham by leaving work at 1130 and getting to the airport in time to have...
2011-08-01
304 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
613 reads
Telecommuting - Hype or Happening? - Making the Case to your Higher-ups
We've seen the argument before, that working from home, actually increases productivity. This is one of the major cases in...
2011-08-01
2,552 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,844 reads
Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,452 reads
The Good, the Bad and the Ugly SQL Cursor types
T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...
2011-07-30
1,949 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