Latest stories

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. Looking back over the last few years of my career I’m pretty amazed at how far I’ve come. I could do a write up about some of the...

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 that attended. If you were unable to join or would like to see the recording you can find the link here. The Q&A can be found...

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 to join or would like to see the recording you can find the link here. The Q&A can be found below.   Q: Does disabling...

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 was doing required a lot of remote desktop switching between those three accounts, across three environments, plus the SQL...

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 was doing required a lot of remote desktop switching between those three accounts, across three environments, plus the SQL...

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 applications, you do not get to choose the name of this...

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, doing backups or creating tables through code. That being said there are times when a UI is helpful to just look up information. Just today I needed to...

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 fast each could be developed. If you attended I want to say thank you. It’s always appreciated when people...

SharePoint 2013 – Failed to install the product: D:globaloserver.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 SharePoint Server 2013 encountered an error during setup.[/error] Well thanks. That’s completely unhelpful. To the...

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 presenting. If you were unable to join the session here is a link to the recording that you can watch for...

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