Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know...
2011-08-18
925 reads
Applied SQL: sys.sql_modules
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-18
1,388 reads
Dancing with Denali - CTP3, Product Guide, and More....
Have you ever danced with Denali in the Pale Moonlight? (Ok, I changed that famous quote from the original Batman...
2011-08-18
2,173 reads
How to report a SQL Server performance problem
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining .Many reasons could be causing this sudden...
2011-08-18
731 reads
SQLMCM Training – Day 10
Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...
2011-08-18
619 reads
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,047 reads
PASSMN Presentation – The Creepy DBA
Last night I spoke at the PASSMN August user group meeting. The topic was The Creepy DBA and how you...
2011-08-17
671 reads
Microsoft SharePoint Online
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
933 reads
Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,381 reads
Afterthoughts: SQL Saturday #79 South Florida 2011
This past Saturday August 13th I presented two sessions at SQL Saturday #79 hosted by the South Florida SQL Server...
2011-08-17
1,229 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