Configuring the System Center 2012 SP1 VMM SQL Analysis Services Integration with Operations Manager 2012 SP1

I was in the process of configuring the OpsMgr / VMM integration and needed to turn on the SQL Analysis Services component for the integration. The Setup for the Operations Manager Integration is pretty simple, the challenge is getting SQL Analysis Services working properly. One of the designs typically used for an Operations Manager installations…

Dynamically Updating Spreadsheet from Web Data

An auto-updating SQL Server Release History spanning the entire product line. Exposed to Microsoft’s new Data Explorer I was impressed by the power of Microsoft’s new tool!  Using a WSIWIG data manipulation tool one can create filtered, shaped, pivoted, purged, and preened data sets within Excel – and have them auto-update when data connections are…

Design Packages & Article Pages

​For anyone that has begun messing with Design Manager and Branding SharePoint 2013, you may have tried to leverage the export design package functionality.    This is a great concept! It appears to have a bug.  When you import a site collection SharePoint appears to remove several columns form the Page and Article Page content…

How to correct the incorrect file names for the System Center 2012 SP1 Operations Manager OperationsManagerDW when installing on Windows 2012 with SQL 2012 SP1 also on Windows 2012

After the installation of Operations Manager 2012 SP1 on a SQL 2012 SP1 Database Server, with both the Database Server and the Operations Manager Server running on Windows 2012; the Operations Manager Data Warehouse DB files are now getting named DATA.mdf and DATA.ldf. Cameron Fuller and JC Cowen has a similar experience where they found…

SQL fragmentation explained

As the data in Microsoft SQL Server tables changes their indexes change. Over time these indexes become fragmented. This fragmentation will adversely affect performance. This post provides information to help you understand the detailed mechanics behind fragmentation. It will also help you understand the methods and approaches for performing defragmentation so you can improve your…

CRM 2011 – Removing Shared Views

I recently encountered a situation in which one of our CRM users wanted to clean up some old CRM Views which were created using Advanced Find and shared with him by someone who is no longer with the company.   This presented an interesting dilemma, because the person who shared the views did not give…