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
178 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,795 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
124 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
528 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,844 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,239 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,100 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,519 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
600 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
686 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers