Azure. Business Intelligence. SQL Server. Nerd Stuff.
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear. 🙂 COUNT(*) – Number of...
by Bradley Schacht · Published August 11, 2011 · Last modified October 13, 2015
Those who know me will know that this post is a little out of the ordinary… I am posting about PowerShell. I have done one previously about Backing up and restoring site collection in SharePoint, so believe me I will...
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a table and I want to be able to just pull up my blog and look it up. Yet again today...
by Bradley Schacht · Published August 9, 2011 · Last modified October 13, 2015
First of all if you came out to my webinar this morning let me say a huge thank you! I really appreciate everyone taking time out of their busy days to listen to me ramble on for about an hour...
by Bradley Schacht · Published August 8, 2011 · Last modified October 13, 2015
Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s. This month each of the authors of the SharePoint 2010 Business Intelligence 24-Hour Trainer available from Wrox are presenting a...
SQL Saturday in South Florida is quickly approaching in just 2 short weeks. As usual, if you are in the area please come out and support the wonderful people who are giving of their time to help out in the...
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get it? How to fix it? All these questions are now answered! PowerPivot is a wonderful tool with a lot of...
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the area get ready for awesome because I am coming to town! Ok, that may have been a little over the...
by Bradley Schacht · Published July 13, 2011 · Last modified October 13, 2015
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool that you can use but it is kinda clunky and can take a while to perform the backup. I used...
It has been a few weeks since I last posted. I know, I’m a slacker, thanks for pointing that out. I have a little bit of a pipeline that I am working on getting populated and just wanted to toss...
