How SkyDrive Saved a Training Session

It’s true!  SkyDrive prevented me from having to cancel a recent training session and in this post, I’ll explain how. The hero of this story is Office Web Apps, which are available via SkyDrive.  Not sure what Office Web Apps are?  Get started here:  http://office.microsoft.com/en-us/web-apps-help/get-started-with-office-web-apps-HA101785172.aspx. The Scenario I’ve been working to build out a SharePoint…

Benchmarking UIDs as clustered primary keys

Using Unique Identifiers (UIDs) as primary keys, especially as surrogates in data warehousing comes with many benefits. There are also performance impacts which are well known to be detrimental – but how much so?  Does it matter?  I set out to find out the performance impact and design drawbacks to UIDs as primary keys. Benefits vs. Drawbacks Some…

Hyper-V Cluster w/V-SAN for SQL Server

A virtualized playground providng parallel SQL 2005, 2008 R2, and 2012 instances (side by side) hosted on a three-node failover cluster. The experimentation possible with this lab is incredible – including any variant of always-on availbility groups interacting with failover cluster instances (which is a pretty interesting topic). Architecture Parallel Windows 2008R2 and Windows 2012 Clusters…

OpsMgr 2012 SP1: Workaround – Fresh Install results in blank OperationsManagerDW Data and Log File Names (mdf and ldf)

I’m noticing this in every OpsMgr 2012 SP1 environment where there is a fresh new build and thought I’d give you all a heads up with a quick workaround. This may be related to why you cannot deploy the DW to a non-default SQL Data and Log file location noted here: https://www.catapultsystems.com/jcowan/archive/2013/03/07/opsmgr-2012-sp1-cannot-install-opsmgr-due-to-operationsmanagerdw-database-files-in-a-non-default-location-for-user-databases-error-code-0x80131500.aspx?utm_source=OpsMgr2012Pipe&utm_medium=Twitter In SQL Management…

Tips and Tricks: OpsMgr 2012 SP1- What Web Service URL, IP and Ports does the Management Pack Catalog web service call

A client was curious how to connect to the MP Catalog if the Server did not have Firewall ports opened for MP Catalog communication. Connectivity Summary: When performing an MP Import via the Operations Manager Console, the web services uses a certificate to Connect to https://www.microsoft.com/mpdownload/ManagementPackCatalogWebService.asmx The Network sees an anonymous POST to the URL…