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 […]
2020-07-01
1,001 reads
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 […]
2020-06-24
666 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
1,251 reads
In this level of the Stairway to Linux, learn how to use the TIG stack to monitor your SQL Server instance on Linux.
2020-05-27
679 reads
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,244 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,983 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
5,001 reads
In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.
2019-09-24
15,502 reads
In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.
2020-01-15 (first published: 2019-09-04)
2,916 reads
In this level of the Stairway to SQL Server on Linux, we learn how to set up and use SQL Agent.
2019-08-06
779 reads
By Will Assaf
Recently I had a client and their vendor trying to configure a firewall for...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
I have very limited knowledge with server management. I need to extract AD users...
Hi all, my company currently uses SQL server native tools to perform nightly backups. ...
How to find the last occurrence of '\' in the following string and get...
Ask SSC