Today Steve talks about choosing a VCS and which one he recommends.

SQL Server 2017 Installation Error with KB2919355

by iLearnSQL

SQLServerCentral

Installation

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]

Fully Left-Shifted Deployments with Version Control and Automatic Cloning

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.

Storage 101: The Future of Storage

by Additional Articles

SimpleTalk

Database Administration

Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.

Automation is a Key Skill for the Modern DBA

by Steve Jones

SQLServerCentral

This month's T-SQL Tuesday had lots of posts that look at automation from the DBA perspective, rather than the software developer.

Remote Work Benefits

by Steve Jones

SQLServerCentral

Work environment

Today Steve wonders if companies ought to support remote work better with other benefits.

Delete Duplicate Rows with No Primary Key on a SQL Server Table

by Additional Articles

MSSQLTips.com

T-SQL

Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?

When SQL Server Performance Goes Bad: Implicit Conversions

by Additional Articles

Redgate

Vendors/3rd-party Products

When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.