CategoryAzure

August 8, 2017

Transparent Data Encryption with Azure Key Vault

By Bradley Schacht
10 Min read
12 comments
08August

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 into the product. With Azure becoming more and more popular I get requests from customers fairly frequently asking to talk about storing the...

September 13, 2016

Importing a BACPAC to SQL Server

By Bradley Schacht
3 Min read
11 comments
13September

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 previous post this discussion arose in a conversation with a customer who needed to keep monthly archives of their data for a 10 year time period to comply with industry regulations and...

September 6, 2016

Archiving Azure SQL Database to a BACPAC

By Bradley Schacht
4 Min read
4 comments
06September

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 the advantages to Azure SQL Database is all the file management, server maintenance and backups are taken care of automatically. Point in time recovery is built...

August 16, 2016

Can You Trust Your Cloud?

By Bradley Schacht
7 Min read
2 comments
16August

“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 maker in a company you have probably raised questions and objections similar to those above. If you are someone who is architecting solutions that...

August 12, 2016

CJIS and the Microsoft Cloud

By Bradley Schacht
2 Min read
2 comments
12August

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 discussing the impact of a CJIS compliant cloud on Justice and Public Safety organizations. State and local agencies in 22 states (at the time...

November 19, 2015

Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell

By Bradley Schacht
14 Min read
Add comment
19November

Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to Azure. You can click here to watch the recording of the webinar if you  missed it. In this follow up I wanted to post the scripts I used, walk through the steps in the process and answer a few questions from the webinar along the way. We will separate this into 4 sections:...

November 10, 2015

Upcoming Presentation – Migrating your SQL Servers VMs to Azure with PowerShell

By Bradley Schacht
2 Min read
Add comment
10November

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 November 17th, 2015 I will be presenting the free training session on Azure Virtual Machines. Devin Knight (Twitter | Blog) and I presented on this topic recently and it received a great response. Whether you are already using Azure...

Bradley Schacht

Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Jacksonville, FL. Bradley is a former consultant, trainer, and has authored 5 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me