Comparing SQL Server constraints and DML triggers
Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Disabling Indexes
Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.
How to use ranking functions in SQL Server 2005
With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
SQL Server Audit in SQL Server 2008 – Part 2
Learn how to monitor database-level actions and write audit results to files.
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers