SQL Server Three Valued Logic and Ansi Nulls
SQL Server uses a three valued logic with True, False, and Unknown. And, normally, SQL Server Nulls are not comparable....
2013-08-21
1,311 reads
A placement firm’s “guaranteed” replacement
I have heard large placement firms say they are better than smaller firms because “They offer the client a guaranteed...
2013-08-20
625 reads
Trigger Status
Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger? I know...
2013-08-20
1,177 reads
Data Purity issue after upgrading SQL 2000 to later versions
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can...
2013-08-20
929 reads
Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
500 reads
SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
747 reads
SQL Saturday 250 – Pittsburgh – Advice for My Presentation on Monitoring and Baselines
I’ll be presenting at SQL Saturday 250 in Pittsburgh on Baselining and Monitoring. This is my first public presentation, and...
2013-08-20
778 reads
SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,506 reads
PASS Summit 2013 - You Ain't From Around Here Are Ya?
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,295 reads
SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method
In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...
2013-08-19
4,449 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