Blog Posts

Career: Talk To References

• by Steve Jones

• The Voice of the DBA

As we try to get through these strange times in the world, I am starting to see a bit more career movement in 2021 than I saw for much...

2021-05-14

1 reads

Daily Coping 14 May 2021

• by Steve Jones

• The Voice of the DBA

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2021-05-14

2 reads

Query Store on Azure SQL Database

• by Grant Fritchey

• The Scary DBA

Under the covers, Azure SQL Database is just good old fashioned SQL Server and this includes Query Store on Azure. While many things can be different when working with...

2021-05-14 (first published: 2021-05-03)

131 reads

Static Code Analysis Feedback for Operations with SQL Monitor

• by Steve Jones

• The Voice of the DBA

One of the challenges with managing a production database is that the code that gets deployed sometimes causes lots of problems. Often a production DBA or sysadmin gets called...

2021-05-14 (first published: 2021-05-03)

117 reads

#PowershellBasics: Comments and comment based help

• by Kenneth Fisher

• SQLStudies

I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the same reasons and then some. So first of all...

2021-05-13

5 reads

Daily Coping 13 May 2021

• by Steve Jones

• The Voice of the DBA

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2021-05-13

1 reads

WIT Mental Health and Wellness Videos Posted

• by Steve Jones

• The Voice of the DBA

I was honored to speak at the WIT Mental Health and Wellness day last week and found myself caught up in the other presentations the rest of the day....

2021-05-13

3 reads

Daily Coping 12 May 2021

• by Steve Jones

• The Voice of the DBA

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2021-05-12

4 reads

Modern Data Warehouse explained

• by James-Serra

• James Serra's Blog

I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...

2021-05-12 (first published: 2021-04-27)

657 reads

Query to find Nonclustered Index clashing with Clustered Index

• by Brahmanand Shukla

• SQL Server Carpenter

It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...

2021-05-12 (first published: 2021-04-28)

505 reads