Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
1,364 reads
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
22,385 reads
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-02-25 (first published: 2009-10-07)
45,776 reads
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,260 reads
2009-05-19
12,266 reads
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...
Hello, Kindly guide me with the following code in T-SQL. I need to only...
Comments posted to this topic are about the item New Stuff Can Be Scary
Ask SSC