Automation is a Key Skill for the Modern DBA

• by Steve Jones

• SQLServerCentral

• Automation
• Database Administration
• Database Weekly
• DevOps and Continuous Delivery (CI/CD)

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.

SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos

• by iLearnSQL

• SQLServerCentral

• Administration

Learn how to correct an error that is overloading SCOM by fixing an SPN.

The Real Life Software Movie Plot

• by Steve Jones

• SQLServerCentral

• Security

A recent thwarted attack reads like a movie plot.

The Two Ways Containers Will Revolutionize Database DevOps

• by Additional Articles

• SimpleTalk

• DevOps and Continuous Delivery (CI/CD)

Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.

Do You Have Big Data?

• by Steve Jones

• SQLServerCentral

• Big Data

Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]

Stairway to SSAS Tabular Level 1: Why use Analysis Services

• by Thomas LeBlanc

• SQLServerCentral.com

In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

• by Additional Articles

• Redgate

• Performance Tuning

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.