SQL Saturday - Top 5 Suggestions from the Attendees
After spending much of the last two days reading through over 200 SQL Saturday Event Evaluations I have come up...
2009-08-04
846 reads
Patrick LeBlanc
SQL Saturday #17 – Baton Rouge
At 5:00 AM on August 1, 2009 I was awaken by a ringing cell phone. It was Mark, the official...
2009-08-03
484 reads
Deadlock Notifications in SQL Server 2005
Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.
2007-10-10
15,331 reads
Tables with Identity Columns
Run this script on the Database where you are trying to identify Tables with Identity columns.SQL SERVER 2000 SP3a
2005-11-15 (first published: 2005-10-24)
159 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers