Tuesday, July 31, 2012

BI Admin Scripts: Process SSAS database

The following script can be copied and pasted into a .ps1 file for you to use in processing all Analysis Services databases on a particular SSAS instance or a specific database. This script was originally designed to process all scripts on a server rather than a single database, thus the somewhat inefficient manner of looping through all the databases to find the one to be processed. I may fix it in the future as well as add some more parameters to handle things like ignoring key errors rather than hard-coding them.

Wednesday, July 25, 2012

Agile BI and Why the BI Admin Needs to Care

The top priority of a BI Administrator is to keep the BI systems up and running and running well. This is the primary area of overlap with the traditional DBA role. Every DBA knows that the best way to optimize performance of a database-related system is to design it right in the first place.

The great thing about the Microsoft SQL Server platform is that, compared to other DBMS and BI platforms, it is really easy to manage. The benefit to this, if not Microsoft's explicit intention, is that the DBA/BI Admin has more time to work with developers to enable and encourage them to build the best solutions they can.

I recently forgot the importance of this Admin-Developer relationship and it is causing a bit of grief.

Friday, July 20, 2012

Attaching Databases to Local SQL Server Data Engine Instance

Don't you hate it when you can't figure out what permissions you need to set on a file or folder to get an application to work? It's especially annoying when all the security settings seem to be in place but nothing seems to work. The problem I am about to describe is documented on Microsoft Connect but has been closed, in my opinion, incorrectly.

Tuesday, July 17, 2012

Remote Desktop and the DBA

Sometime last week, Brent Ozar tweeted the comment below and I sort of took offense (not really):
DBAs who RDP into the SQL Server console, take one step forward. Closer. Closer to the monitor. I need to slap you.
I must admit that I use Remote Desktop sessions into my BI servers rather frequently but I think I have some pretty good reasons. Some might fall into the realm of excuses but I am open to debate on the subject.

Friday, July 13, 2012

Upgrading BIDS Projects to SQL Server Data Tools 2012

Upgrading your Visual Studio 2008/BIDS 2008 R2 projects and solutions​ to the new VS 2010/SSDT format isn't exactly fraught with peril but it isn't a walk in the park either. SSAS and SSRS projects convert seamlessly since those two products didn't change but upgrading those SSIS packages may take a little bit of work.

Tuesday, July 10, 2012

SQL 2012 Upgrade: Series Overview

Here is an overview of the rest of the series leading up to this post.

SQL 2012 Upgrade Part 8: The Upgrade

Wow, what a hectic couple of days. There isn't a lot to tell here as things went pretty much according to plan. We tuned the plan on a Friday by upgrading our Development and QA environments and took to Production on Saturday morning. If you're looking for some SQL Server drama then read on!

Friday, July 6, 2012

SQL 2012 Upgrade Part 7: Upgrade Plan


Alright! All the testing is done and we're ready to get this upgrade done! We had a rough upgrade plan to start with but we learned a lot during the testing process. As a result, the plan changed and became more detailed. Our weeks of testing and analysis paid off and left us in a vary comfortable place.

Wednesday, July 4, 2012

Coming Soon: Ask the BI Admin

Howdy folks!

I will be wrapping up the SQL Server 2012 Upgrade series sometime next week but I still have plenty of content to follow. I would like to add a feature to this site that is aimed a little bit more at the community.

Starting in August, I will answer questions from the community at least twice per month. My focus will be on questions posed in the comments here on the site or via Facebook or Twitter. I am realistic, however, and given that I only appear to have two regular visitors to the site (one of which might be me), I will also be lurking on the forums at SQL Server Central and googling/binging for SQL Server 2012 problems.

So, if you have a problem with some piece of the Microsoft BI platform, please let me know about it. As I said, I will work on posting at least two answers per month. If I get more questions and enough time to find a solution for them I will post more.

One more thing, though. Keep in mind that I might have to contact you directly to get more information about your problem. I will keep these communications as private as possible. I will also keep your identity as private as possible in the solution post if you so desire. There is no need to be embarrassed. I have had problems before that couldn't solve and have even had to call Microsoft Premier Support; in fact, if you have a major Production issue, I suggest you call them before you contact me. They are good bunch of people and they do a great job helping their customers.

Talk atcha soon!

Monday, July 2, 2012

SQL 2012 Upgrade Part 6: SSAS DB Processing Test


One thing we definitely had to be sure of when we upgraded to SQL Server 2012 was that all the Analysis Services databases could be processed successfully.  This process went pretty smoothly but not without a few hiccups. In the end, the issues we ran into were pretty easy to resolve.