Latest stories

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

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 management, server maintenance and backups are taken care of automatically. Point in time recovery is built...

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. I’ve been on easy engagements where I built SSRS reports for two weeks and I’ve been on difficult engagements...

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 and objections similar to those above. If you are someone who is architecting solutions that...

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 on Justice and Public Safety organizations. State and local agencies in 22 states (at the time...

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 questions from the webinar along the way. Q: Can I use a WHERE clause on a masked column? For instance, SELECT * FROM Table WHERE SSN...

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 the steps in the process and answer a few questions from the webinar along the way. We will separate this into 4 sections:...

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

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...

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. Since I work as a consultant I have to handle a lot of different software scenarios. Some customers use...

Pragmatic Works Los Angeles BI Boot Camp

Click to purchase a seat in the Pragmatic Works Los Angeles BI Boot Camp. Microsoft has a wide range of offerings in the business intelligence space and it can take a lot of work to figure out how they all fit together. The Pragmatic Works BI Boot Camp will walk you through a week of hands on activities that show exactly how each piece of the BI stack works. I will be teaching the class for all 5...

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. 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