How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,618 reads
SQL Server Denali CTP3: Policy Based Management
Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”....
2011-07-12
1,392 reads
SQLDIY: Index Usage Statistics
There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...
2011-07-12
2,470 reads
SQL Server “Denali”: CTP3 now available!
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,253 reads
SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,383 reads
SQL Server 2011 (Denali) CTP3 Released!
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
953 reads
Subtle Errors When Using Dates-Part 2
It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...
2011-07-12
577 reads
SQLSaturday #80 - Wheeling, West Virginia!
Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia! Wheeling, known as the friendly city,...
2011-07-12
1,004 reads
Which database is using all my CPU #2
A few weeks back we wrote about a query to tell you which database is using up most CPU time....
2011-07-12
1,487 reads
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
625 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