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,317 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
626 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,190 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
934 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
505 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
750 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
780 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,515 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,299 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,452 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers