Azure. Business Intelligence. SQL Server. Nerd Stuff.
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...
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...
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...
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....
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...
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...
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...
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...
