The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The Myth of Over-Normalization
Too often, denormalization is suggested as the first thing to consider when tackling query performance problems. It is said to be a necessary compromise to be made when a rigorous logical design hits an inadequate database system. As the saying goes, “Normalize ‘til it hurts, then denormalize ‘til it works”. In reality, Denormalization always leads eventually to tears.
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
SQL Server Security: Pros and Cons of Application Roles
Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.
How to configure and Use Database Backup Compression in SQL Server 2008
SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
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