In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.

Getting Your DBA Teams Scripts into Git

by Steve Jones

SQLServerCentral

In this article, you will learn how a team can start to better manage the scripts they use for their daily work.

The Cost of Rework

by Steve Jones

SQLServerCentral

software development

Steve notes that we're always better doing things better the first time. That takes some effort.

Concepts and Issues in Test Data Generation

by Additional Articles

SimpleTalk

Test Data

Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude

Shout Your Successes

by Grant Fritchey

SQLServerCentral

Uncategorized

I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]

Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)

by Stewart Campbell

SQLServerCentral

Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating

What Metrics Do You Collect?

by Steve Jones

SQLServerCentral

Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.