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 admit that it has its place. Well I was onsite with a client today and found another use for PowerShell: checking the size of and free space on mount points on an HP appliance. This method will work with any machine, but this specifically happen to be on a server using mount poin...
Read More
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 I had to do this and I couldn't remember the exact syntax, so here it is. The next record is going to be the seed value plus 1, or in the case of this example I will use zero so the first record is 1. That will make my O.C.D. happy to see my table starting with a key value of 1! DBCC CHECKIDENT('<TableName...
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 this morning. If you were there I hope you got some good information out of it. If you didn't get good information out of it you probably weren't paying attention... just kidding!! :) My webinar today covered Excel Services in SharePoint 2010. I covered the basics of setting up the web application and then...
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 topic they covered in the book. I happened to write the chapter on setting up and deploying Excel services applications. So tomorrow get ready for awesomeness to overtake your computer screen for an hour while I explain Excel services to y...
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 community. Don’t forget that it is a free event, so that has to be a mark in the PROS column to get you to come!! There are going to be a lot of great speakers including several from good ol’ Pragmatic Works. We have several people making the trip down for the day; I’m not sure how many will b...
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 power to enable self-service BI in many organizations. There is a fine line between having users create PowerPivot reports and building an enterprise solution in something like SSAS. One of the things that blurs that line is sharing PowerPivot ...