-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

Bring Your Own Key to Azure SQL Database TDE New UI

In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your own key was through PowerShell and T-SQL. Thankfully, that has changed. A recent update added a UI for managing your… Read more

0 comments, 1,540 reads

Posted in Bradley Schacht on 5 June 2018

Azure PowerShell – List Virtual Machine Sizes

For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of the exact value that should be there. In the Azure Portal it’s easy, you pick from a drop down menu where… Read more

1 comments, 1,419 reads

Posted in Bradley Schacht on 29 May 2018

Azure PowerShell – List Data Center Locations

Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do training with a customer. Part of that meant creating 6 data science VMs. So we updated the software on a VM… Read more

1 comments, 1,385 reads

Posted in Bradley Schacht on 22 May 2018

Webinar Followup: Overview of Azure Data Factory V2

About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed it. In this follow-up I answer all the important questions that were posted to the Q&A pannel, like those related to… Read more

0 comments, 199 reads

Posted in Bradley Schacht on 16 May 2018

State of the Cloud Database: April 2018

It’s an exciting time to be a database professional. The technology is advancing quickly, large datasets are easier to handle than ever before, and the cloud is opening up new functionality and use cases that we couldn’t tackle before.

My fellow database professionals, I tell you today that the state…

Read more

0 comments, 2,425 reads

Posted in Bradley Schacht on 25 April 2018

Bring Your Own Key to Azure SQL Database TDE

I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure SQL Database there has long been an option to enable TDE with just the click of a button. A lot of… Read more

2 comments, 1,645 reads

Posted in Bradley Schacht on 19 April 2018

New Azure SQL Database Pricing Model


Azure SQL Database has some great built-in features that are included in the price like automatic backups, high availability, auditing and threat detection, transparent data encryption. No matter how excited people are when I talk to them about Azure SQL DB there is one topic that causes confusion. Every. Single.… Read more

1 comments, 907 reads

Posted in Bradley Schacht on 12 April 2018

Fixing You’ll need a new app to open this ms-word

It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most part it is a great solution with few issues. We can subscribe to documents and libraries and get updates when items are modified or added then go view those documents… Read more

8 comments, 559 reads

Posted in Bradley Schacht on 18 August 2017

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 Encrypted functionality with Azure Key Vault. Always Encrypted, as with TDE, can use Windows certificates or what an external storage location… Read more

0 comments, 1,494 reads

Posted in Bradley Schacht on 15 August 2017

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 unique to SQL Server and hasn’t changed much since being introduced into the product. With Azure becoming more and… Read more

9 comments, 865 reads

Posted in Bradley Schacht on 8 August 2017

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 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 and link to a… Read more

0 comments, 399 reads

Posted in Bradley Schacht on 9 May 2017

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 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… Read more

8 comments, 13,411 reads

Posted in Bradley Schacht on 13 September 2016

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 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… Read more

0 comments, 1,363 reads

Posted in Bradley Schacht on 6 September 2016

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 that’s not a long time but when you consider that all of those years have been in consulting it’s more experience than many people will get in an entire career. Read more

0 comments, 1,952 reads

Posted in Bradley Schacht on 23 August 2016

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 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… Read more

1 comments, 2,181 reads

Posted in Bradley Schacht on 16 August 2016

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 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… Read more

1 comments, 422 reads

Posted in Bradley Schacht on 12 August 2016

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 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 and answer a few… Read more

0 comments, 544 reads

Posted in Bradley Schacht on 26 July 2016

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

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… Read more

0 comments, 1,140 reads

Posted in Bradley Schacht on 19 November 2015

Hyper-V The trust relationship between this workstation and the primary domain failed

Note this fix only works on Windows Server 2012/Windows 8 or later. A different method is required on Windows Server 2008R2 or earlier which involves the use of the NETDOM command.

For several years now I have been using Hyper-V for building out a virtual development environment on my laptop.… Read more

2 comments, 3,482 reads

Posted in Bradley Schacht on 27 October 2015

Upcoming Presentation – Space Coast SQL/.Net User Group

If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me!

I’ll be speaking at the newly merged Space Coast SQL/.Net User Group on Power Query. This topic is easy for anyone in SQL, business intelligence, .Net or even… Read more

0 comments, 977 reads

Posted in Bradley Schacht on 2 September 2015

Older posts