Today Steve notes that DevOps isn't going to eliminate Ops, even if developers support their own applications.

SQL Server Name Convention and T-SQL Programming Style

by Konstantin Taranov

SQLServerCentral

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

by Additional Articles

Redgate

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

SSRS is Still Around

by Additional Articles

SimpleTalk

The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news about the general availability of SQL Server 2019, I had not heard any recent news about SSRS, so I could only say that I didn’t know.

Data for Defense

by Steve Jones

SQLServerCentral

Security

The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.

Increase Query Speed with Covering Indexes

by steve@thesqlguy.com

SQLServerCentral

Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.