Azure. Business Intelligence. SQL Server. Nerd Stuff.
by Bradley Schacht · Published November 11, 2014 · Last modified October 13, 2015
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....
Business Intelligence / Speaking
by Bradley Schacht · Published November 9, 2014 · Last modified October 14, 2015
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...
by Bradley Schacht · Published November 2, 2014 · Last modified October 14, 2015
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...
Business Intelligence / Speaking
by Bradley Schacht · Published October 15, 2014 · Last modified October 13, 2015
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...
Business Intelligence / Speaking
by Bradley Schacht · Published July 25, 2014 · Last modified October 13, 2015
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...
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...
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...
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...
Business Intelligence / Speaking
by Bradley Schacht · Published March 21, 2014 · Last modified October 14, 2015
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...
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...
