Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.

Dark Reads During a Migration

by Steve Jones

SQLServerCentral.com

Editorial

An interesting technique for deploying changes.

We Need Data Privacy Consistency

by Steve Jones

SQLServerCentral.com

Editorial

Steve talks about the disparate regulations we face for data privacy and protection.

Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

by Additional Articles

MSSQLTips.com

In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.

How Do You Setup Your Instances?

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve wonders if you have a process for setting up your new instances.

Single-Column-Key Missing Index Recommendations are Usually Wrong.

by Additional Articles

Brent Ozar Blog

index count

When Clippy suggests an index with only one key, look closer.

TRY_PARSE

by Matthew McGiffen

SQLServerCentral.com

T-SQL

Introducing the PARSE function, brought to us in SQL Server 2012.

How to Linux for SQL Server DBAs — Part 1

by Additional Articles

SimpleTalk

Linux SQL Server

As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.