In Level 1 of this Stairway, we discussed how to configure TDE in a user database using a Database Master Key and Certificate. In this level, we explain the steps for backing up and securing this certificate, as well as how to restore the database on another server instance. Backup the Certificate and Private Key […]
2020-05-20
1,066 reads
Introduction Transparent Data Encryption (TDE) is one of the key security features available in SQL Server from SQL Server 2008 onwards. Using this feature, the ‘data at rest’ in the physical files for the database, are protected from unauthorized access if the files are copied, or the physical media is stolen. TDE is available with […]
2020-04-29
1,751 reads
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.
2018-12-06
5,829 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
6,836 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
10,134 reads
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
4,840 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Devin-Knight
This month we will likely have two releases of the Power BI Desktop. In...
By Jen McCown
We like code better than mouse clicks for three basic reasons: T-SQL lets you...
Comments posted to this topic are about the item The Basics of Using a...
Comments posted to this topic are about the item Inlining Scalar UDFs
Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning...
Ask SSC