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
175 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
112 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
527 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,696 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,501 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
685 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers