There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up what we are talking about here. Check it out below. Method 1: Through SharePoint 2010 Central Administration: Open SharePoint 2010 Central Administration Click on the link for System Settings Click the link for Manage Servers in This Farm Look at the Configuration Database Version field Method 2: A detailed list through SharePoint 2010 Central Administration: Open SharePoint...
Read More
With SQL Server 2012 right around the corner and Release Candidate 0 already out there I'm sure you will all want to see the cool new stuff that SharePoint has to offer. There are a number of changes coming to SharePoint with the SQL 2012 release including the much anticipated PowerView . A number of enhancements have been made to the installation process as well as the consolidation of Reporting Services for SharePoint integration; which is now all handled through Central Administration rather ...
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint stuff, very technical… I know) and get the following error: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. I have found there are two places you may get this error: The first is kind of a “duh” moment if you will: not running the Management Shell as an administrator will produce this error every time if UAC is turned on...
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check this blog ( Backup and Restore SharePoint 2010 Site Collection With PowerShell ) where I explain the process. Unfortunately this is not always a foolproof process as I have recently found out. Most errors are pretty self explanatory such as the site collection already exists, in which case change use the -Force command to overwrite it. I recently came across the following error: Restore-S...
If you are like me then you like to reinstall Windows on your laptop every few months to keep things fresh and running smoothly. That or your even more like me and you download some beta version of software and install it on your laptop rather than a VM and screw something up to an unrepairable state. Either way Windows is being reinstalled. I have a laptop without an optical drive in it. The vast majority of the time I don’t mind as I pretty much use ISO files exclusively. This is a probl...
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple devices, namely the iPad, for use in their organizations. In the last quarterly earnings call from Apple they revealed that more than 80% of fortune 100 companies and more than 60% of fortune 500 companies are now using iOS devices in their organizations. Regardless of the amount of implementation behind those numbers we are going to have to plan our reporting around the use of p...
If you have used SSIS to move data from something like Access or more commonly Excel, it is a good possibility you have seen this error at some point: Error: The ‘Microsoft.Ace.OLEDB.12.0 ‘ provider is not registered on the local machine. The reason this error shows up is because the proper components are not present that are required to move data from Office files (I’m looking at you Access and Excel). If you do development on a laptop or desktop then there is a very good chan...
PowerPivot report returns the following error from Excel Services: The data connection uses Windows Authentication and user credentials could not be delegated. The following connection failed to refresh: PowerPivot Data When viewing a PowerPivot workbook in SharePoint 2010 the report is visualized using Excel Services since ultimately the report is inside an Excel workbook. The root cause of this error is that Excel Services is unable to get a valid Windows account from whoever is running the re...
If you have ever closed a query window by accident only to wish you could get back your work an instant later you may be in luck. If you ran the query in question there is hope for you. The query below will return queries that have been run for you including the time and query text. I haven’t figured up a way to get the user that executed the query just yet. So if you have that tidbit to add to this so you can filter a little easier please let us know. You can narrow the list by adding a w...
Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday. It has been a lot of fun, so thank you to everyone who has come out and hopefully learned something from one of the sessions I have done. So, I mentioned a couple things I was going to do, one of which is post a quick recap and sample package from the Expressions and Variables session. So here that is. The other will come next week when I post some same situations and data sets...
Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables and Expressions. The webinar was recorded, so if you want to reference it again or if you were unable to attend and wanted to see it you can view the recording from this link here the clicking view on the right side on the Pragmatic Works website (Here is the direct link to the view button). I will be answering questions today if I was unable to get to your question in th...
Looks like it is that time again... for me to present a FREE webinar for good ol' Pragmatic Works today at 11AM eastern standard time. The topic today will be SSIS variables and expressions. I previously did a webinar on a similar topic that also included configurations. If you were in that webinar then you are well aware that we really only got to go into detail on configurations and not the other two topics. So today is completely dedicated to variables and expressions. Feel free to bring your...
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 records in the table regardless of NULL values and duplicates COUNT(1) – Number of records in the table regardless of NULL values and duplicates ** IMPORTANT NOTE: The 1 does NOT refer to an ordinal location of a column. This will not count the records in the first col...
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...
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 ...
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 top but all parts of that thought are in fact true. I am coming to town for the event and it will be awesome. To start with if you are a SQL Server professional in any way you should come out for the day. That includes all the DBAs, .Net developers that work with SQL and of course the BI developers out...
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible to over configure a package, so be sure that you only do what you need to in order to make life easier. Sometimes too much configuration can equal confusion. So the big questions, what is a configuration, when should I use it and how do I use it. Let’s tackle that first one then roll right into the other two. What is a configuration? In simplest terms a configurati...
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 once and was not impressed. PowerShell provides a quick and easy way to do site collection backups. My favorite part is that you can do the entire backup with one, uno, un, 1 (that’s all I know for the number one so… yeah) line of code. Just a little something to be careful of, you need to use th...
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 out some of the topics that I have in consideration for upcoming content. If you happen to have something you would like to see on here please feel free to email me or leave a comment. The more feedback I get on what people want to see the better your experience will be coming to this site... and yes tha...
There will inevitably come a day when you want to take a look at the metadata of the tables inside a database. This can be accomplished one of many ways, the quickest and easiest is to expand the columns node inside the Object Explorer in SQL Server Management Studio (SSMS). What if you want to look at your entire database though? Running a query against INFORMATION_SCHEMA.COLUMNS is a great way to do this. This will get you much more in depth information about your tables with minimal work. I c...
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works ( website ) that I did on Tuesday. If you missed it the topic was Dynamic SSIS: Configurations, Expressions and Variables. I got a lot of good feedback from people who attended saying it was helpful. It’s always nice to know that someone got something out of a session. I know I said I was going to be posting some samples and that sort of thing along with the link to the recording but I haven’t quite gotten t...