Azure. Business Intelligence. SQL Server. Nerd Stuff.
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 Encrypted functionality with Azure Key Vault. Always Encrypted, as with TDE,...
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 unique to SQL Server and hasn’t changed much since being introduced...
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to...
Each week Pragmatic Works hosts a free training session. The topics include SQL Server internals, Business Intelligence, cloud services and even big data. On Tuesday May 2nd, 2017 I will be presenting the free training session on SQL Server 2016...
This post will be updated with new information as we make announcements. Each year I help organize the SQL Saturday in Jacksonville, FL. We have an awesome group that helps organize and put the event on each year. There are a...
Azure / SQL Server / Syndication
by Bradley Schacht · Published September 13, 2016 · Last modified September 12, 2016
We previously looked at Archiving Azure SQL Database to a BACPAC and in today’s post we are going to address how to look at that data by restoring or importing it to a local SQL Server. As discussed in the...
Azure / SQL Server / Syndication
by Bradley Schacht · Published September 6, 2016 · Last modified July 26, 2019
UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server. Azure SQL Database is a managed database platform as a service (Paas) offering available from Microsoft in the Azure cloud. One of...
by Bradley Schacht · Published August 23, 2016 · Last modified August 22, 2016
Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things that’s not a long time but when you consider that all of those years have been in consulting it’s more...
“How do I know my data is secure?” “A lot of companies have been hacked lately, why would I want to move to the cloud?” “We have sensitive data that can’t be moved to the cloud.” If you are a decision...
Azure / Government Solutions / Syndication
by Bradley Schacht · Published August 12, 2016 · Last modified August 14, 2016
Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government clouds. An August 2016 article on the Azure blog, Not All Clouds Are Created Equal, addressed this topic in detail...
