Apr 05
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side SQL Server 2012.You can still install the 2008 R2 version of PowerPivot or you can try out the new 2012 RTM version. There are some nifty improvements that Devin Knight has chronicled (Blog | Twitter). …
Apr 02
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments. In Excel Services 2007 many unsupported features would cause the workbook to not load at all …
Apr 02
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are many methods for configuring high availability, one of which is database mirroring. Other options, such as clustering will be discussed separately. Database mirroring is a SQL Server technology used for providing database redundancy. It is …
Mar 23
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In fact, a good number of the commonly used functions from T-SQL are in SSIS as well. Here we will explore the different Trim functions found in SSIS. We will be using the test phrase ” …
Mar 23
In an SSIS package you have the option to choose from a wide range of source from Flat Files to writing queries using OLEDB sources such as SQL Server. Often times, such as writing queries against SQL Server, the metadata will come from the table and you won’t need to worry about truncation in the …
Mar 12
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279 Function Name: BottomCount Use Case: Brings back the lowest X number of values from a set MSDN Link: http://msdn.microsoft.com/en-us/library/ms144864.aspx Notes: Always …
Mar 12
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279 Function Name: TopCount Use Case: Brings back the highest X number of values from a set MSDN …
Mar 05
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over the past couple of years I have taken a look at a lot of Date dimension scripts and found quite a few good ones. Well recently I needed to add fiscal date to the dimension …
Mar 05
Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint BI. Get the details below along with the link to view the FREE event. Title: Introduction to SharePoint BI When: Tuesday March 6th, 2012 at 11AM Eastern Description: In this session Brad will provide you an overview …
Feb 09
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was accepted. If you are unaware, SQL Saturday is a free day of training that takes place on a Saturday. I’m sure that didn’t need any explanation, but you just never know. So if you happen …
Loading tweets...