Always Encrypted with Azure Key Vault
I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing certificates. Today’s post will explore using SQL Server’s Always...
2017-08-15
174 reads
Bradley Schacht
Transparent Data Encryption with Azure Key Vault
Microsoft introduced Transparent Data Encryption (TDE) to SQL Server with the 2008 release providing a simple, easy way to add an...
2017-08-08
1,774 reads
Transparent Data Encryption with Azure Key Vault
Microsoft introduced Transparent Data Encryption (TDE) to SQL Server with the 2008 release providing a simple, easy way to add an extra layer of protection to our data. TDE is not...
2017-08-08
108 reads
Webinar Followup: End to End Security with SQL Server 2016
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...
2017-05-09
526 reads
Importing a BACPAC to SQL Server
We previously looked at Archiving Azure SQL Database to a BACPAC and in today’s post we are going to address...
2016-09-22 (first published: 2016-09-13)
64,671 reads
Archiving Azure SQL Database to a BACPAC
UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server.
Azure SQL...
2016-09-09 (first published: 2016-09-06)
5,232 reads
How I Got Here: Microsoft
Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things...
2016-09-02 (first published: 2016-08-23)
2,094 reads
Can You Trust Your Cloud?
“How do I know my data is secure?”
“A lot of companies have been hacked lately, why would I want to...
2016-08-23 (first published: 2016-08-16)
2,500 reads
CJIS and the Microsoft Cloud
Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government...
2016-08-12
590 reads
Webinar Followup: New Security Features in SQL Server 2016
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...
2016-07-26
684 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers