Stairway Series

Stairway to U-SQL icon

Stairway to U-SQL Level 22: Creating a Custom Extractor

  • Stairway Step

Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]


1,001 reads

Stairway to TDE icon

Stairway level 3 : Configure Extensible Key Management Using Azure Key Vault

  • Stairway Step

In Level 1 of this Stairway series, we discussed how to configure TDE in a user database using a Database Master Key (DMK) and a certificate. Level 2 showed the steps to restore the backup of this database on another instance.  In this level, we will explain how to configure TDE in SQL Server with […]

5 (3)


666 reads

Stairway to TDE icon

Stairway Level 2 : Restore a Backup of a TDE Database to Another Server

  • Stairway Step

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 […]

5 (2)


1,244 reads

Stairway to TDE icon

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

  • Stairway Step

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 […]

5 (3)


1,983 reads


On Dynamic Ports, Named Instances, and Firewalls


Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020


I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)


Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs


Help needed in getting all AD users and groups

By Mysterio

I have very limited knowledge with server management. I need to extract AD users...

What do you like for third party database backup/restore for SQL server & Azure

By melissa.hamilton

Hi all, my company currently uses SQL server native tools to perform nightly backups. ...

Find the last occurrence of \ character and get the left of string.

By sathwik.em91

How to find the last occurrence of '\' in the following  string  and get...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers