I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete....
2020-01-28
2,041 reads
Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...
2020-01-31 (first published: 2020-01-24)
815 reads
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-12-09 (first published: 2019-11-25)
636 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-27 (first published: 2019-11-19)
1,155 reads
It’s that time of the year again. No, not fall, although I do love the weather change that’s around the corner. It’s time for me to rebuild my Azure...
2019-11-14 (first published: 2019-11-06)
591 reads
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all...
2019-09-04
173 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-09-02 (first published: 2019-08-22)
278 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-08-13 (first published: 2019-07-30)
1,456 reads
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...
2019-07-23
84 reads
In a recent post about creating Azure VMs using PowerShell, I noted a common issue that I run into where the name of the OS disk does not conform...
2019-08-08 (first published: 2019-07-16)
5,267 reads
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, One of the user databases was in Not synchronizing / In recovery mode....
No doubt this has already been answered and probably detailed many ways so I...
Hi In one of our servers the t-logs of one of the database which...
Ask SSC