Author: Bradley Schacht

0

Unsupported Features in Excel Services SharePoint 2010

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...

Mirroring Support for SharePoint 2010 Databases 0

Mirroring Support for SharePoint 2010 Databases

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...

1

Trim Functions in SSIS

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...

0

MDX Functions: BottomCount

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...

0

MDX Functions: TopCount

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:...

0

Speaking At SQL Saturday #110 in Tampa

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...

12

The Windows Search Engine Is Currently Disabled

If you have ever gotten this error message you may have been left scratching your head wondering why…kinda like me. The Windows Search Engine is currently disabled. Outlook will not be able to provide fast search results using the Instant...