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,605 reads
Blog Posts
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,252 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has finally (after releasing the CTP version way back in April) released the final, gold build of SQL Server...
2011-07-12
2,646 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
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,380 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,391 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,466 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,003 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
575 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
624 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers