Click here to monitor SSC
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).

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

2 comments, 885 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, 566 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,600 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

0 comments, 1,496 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, 111 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, 248 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, 697 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

0 comments, 742 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, 717 reads

Posted in Bradley Schacht on 2 September 2015

How To Use the Unpivot Transform in SSIS

Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which isn’t bad… Read more

1 comments, 7,271 reads

Posted in Bradley Schacht on 11 November 2014

Monitoring BI Performance: Scripts and Slides

I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing 3 additional posts that go into a little more detail and contain screenshots of how to monitor each BI tool with some step by step instructions. Be on… Read more

0 comments, 921 reads

Posted in Bradley Schacht on 10 November 2014

How I Got Here: 5 Years At Pragmatic Works

I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the other day that I was a store manager for Blockbuster while going to school and living in a small apartment with a buddy who had just moved back from Orlando.… Read more

2 comments, 1,290 reads

Posted in Bradley Schacht on 2 November 2014

Webinar Q&A: SSRS Subscriptions and Data Alerts

Updated 10-16-2014 at 11:20 AM Eastern

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone… Read more

3 comments, 1,063 reads

Posted in Bradley Schacht on 15 October 2014

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable… Read more

1 comments, 1,059 reads

Posted in Bradley Schacht on 25 July 2014

Find Users Logged Into Remote Computer

Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently I was working on a project doing some SharePoint work using 3 accounts: Admin/Install, Farm and Service. The work I… Read more

3 comments, 9,756 reads

Posted in Bradley Schacht on 23 July 2014

Rename SharePoint Central Administration Database

SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that has been created. The Central Administration site is no different and has its own content database that is created when running the SharePoint configuration wizard. Unfortunately, unlike when creating service… Read more

0 comments, 1,008 reads

Posted in Bradley Schacht on 21 July 2014

Find SQL Database Owner with T-SQL

One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week is the lack of a UI to do things. I’m not one of those people who has to have a UI to perform operations. I have no problem creating databases,… Read more

0 comments, 3,279 reads

Posted in Bradley Schacht on 29 April 2014

Webinar Q&A: Getting Started With Analysis Services

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services. We covered some of the differences between the two project types at a high level then built one of each to give everyone an idea of how difficult and how… Read more

0 comments, 1,161 reads

Posted in Bradley Schacht on 21 March 2014

SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)

I often do my SharePoint setups on virtual machines since I need to build them up and tear them down frequently. Hyper-V is a beauty when it comes to demo environments. A few weeks ago I was doing an install and got an error that was absolutely no help.

[error]Microsoft… Read more

1 comments, 1,805 reads

Posted in Bradley Schacht on 4 March 2014

Webinar Q&A: New BI Features in SharePoint 2013

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before… Read more

0 comments, 1,213 reads

Posted in Bradley Schacht on 28 February 2014

Older posts