Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,136 reads
Automating Web App Deployments with SSIS
This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar...
2011-07-12
621 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,651 reads
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,627 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,394 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,256 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,384 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
956 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
580 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers