Muting the Immutable

• by Phil Factor

• SQLServerCentral.com

• Editorial

Phil Factor on dealing with "immutable" domain data during database development and deployment.

Vagrant and SQL Server 2017 on Linux

• by David Poole

• SQLServerCentral.com

• Virtualization, containers, and k8s

Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017

Simple SQL Change Automation Scripting: Connections, iProjects and Builds

• by Additional Articles

• Redgate

• SQL Change Automation

Phil Factor delves into some of SQL Change Automation's data objects, or artifacts, covering the DatabaseConnection, iProject and iBuildArtifact objects. He explains the useful information they contain and how to use them in a PowerShell-automated database delivery process.

Welcome to the DBA Training Plan.

• by Additional Articles

• Brent Ozar Unlimited Blog

• Free Training

8 years ago, Brent launched an email series with a 6-Month DBA Training Plan. he sent one email per week, bringing people up to speed on the most important topics that nobody taught ’em along the way. It’s hard to believe it’s been 8 years! This month, he's revisiting the emails, updating their content, and publishing ’em as blog posts too to make ’em easier to find. Buckle up: here come 24 straight blog posts to take you from zero to…well, at least a hero who’s smart enough to wear the underpants on the inside.

How Often Do You Give Your Server a Physical?

• by Pamela Mooney

• SQLServerCentral

• Administration

The start of a new series that looks at examining your servers and keeping track of their health.

Relationally Divided over EAV

• by Tony Davis

• SQLServerCentral.com

• Editorial

A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.

Making the switch to SQL Monitor

• by Additional Articles

• Redgate

• SQL Monitoring

Managed IT Services provider Claranet turned to Redgate after having issues with their old monitoring solution and haven’t looked back since. With SQL Monitor named most popular third-party monitoring tool in this years State of SQL Server Monitoring report, see how it helps Claranet deliver more with less.

SQL Server Logon Trigger Examples

• by Additional Articles

• MSSQLTips.com

• Triggers

In this tip we look at how to create SQL Server Logon Triggers and show different examples of how this can be used.

Demo Data for Everyone

• by Steve Jones

• SQLServerCentral

• Data Privacy and Protection
• software development
• Test Data

Steve thinks having a known set of data for your system is one way to improve your software development process and make salespeople happy.

Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication

• by Sebastian-Meine

• SQLServerCentral.com

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.