Remove All Foreign Keys
To clear test data from a database we could use truncate commands but sometimes we need to get rid of...
2011-10-11
40,814 reads
PASS Summit 2011 Day -2 (Monday), part 2
Today was a good day. I posted about the first part of today earlier, and we left off there with...
2011-10-11
519 reads
Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have...
2011-10-11
1,256 reads
Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,863 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,308 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,105 reads
Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,306 reads
PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
515 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,351 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
910 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