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
183 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,800 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
127 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
529 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,877 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,243 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,105 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,523 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
602 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
691 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers