Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.
2020-09-04 (first published: 2018-12-06)
8,330 reads
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2020-06-24
976 reads
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
2020-05-20
1,500 reads
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
2020-04-29
2,403 reads
This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.
2018-07-16
9,699 reads
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
2018-05-22
14,659 reads
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
6,278 reads
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
I have a lookup table that implements a system-generated Id for DRI purposes. The...
A client would like to be able to recognize similar free-texts in a text...
I want to develop my skills in database design and modeling. I found...
Ask SSC