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…
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…
On April 16th, Microsoft launched Windows Azure VM into production and now offers new pricing options and larger compute instances. There are now two super huge VM compute options (The A6 and A7) at 28GB and 56GB of RAM respectively! This makes it possible to run SharePoint 2013 in Azure (previously not practical during the…
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…
To export a users mailbox folder sizes to a text file use the following command: Get-Mailbox -Identity testmailbox | Get-MailboxFolderStatistics | Select Identity,FolderPath,FolderSize,ItemsInFolder | Sort-Object ItemsInFolder | fl | out-File C:\Temp\DMayer-Mbox.txt
I had a client who, while was working to better lock down and delegate Exchange administrative access, accidentally changed the write scope for the Organization Management Role. The change was not noticed until later, when it began affecting normal admin tasks. By then, nobody could remember what had been changed, which makes it difficult to…
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…
During a recent Exchange 2010 SP3 upgrade (direct from 2010 to SP3, no SP1 or SP2 incremental upgrade), the upgrade failed and all my Exchange services were set to Disabled. Long story short: during the upgrade, each role disables all the Exchange Services during the upgrade and cannot start them up again after the…
I recently installed Exchange 2010 on the E: drive of the server. The C: drive is the traditional OS drive, the client just likes all applications to be installed on the E: drive. No big deal, I’ve done this with Exchange 5.5, 2000, 2003, and 2007, I can do this. A day and half later,…
Last week I encountered an issue with what initially appeared to be a problem with DNS scavenging, but after hours of troubleshooting and research I was able to determine that it was actually a known issue with the Windows DNS client. It all began on Monday when I spun up two new Windows Server 2012…
Catapult uses cookies to enhance your experience, to display customized content in accordance with your browser settings, and to help us better understand how you use our website. By continuing to browse or closing this banner, you indicate your agreement. To learn more about the cookies we use and to set your own preferences, see our Privacy and Cookie Policy.