Related Articles
System Center – SQL Server 2008 R2 Performance Tuning
Posted on Author stefanroth
In this article I would like to share some SQL Server performance tuning tricks which will give an extra boost to your System Center infrastructure. I will focus on SQL Server 2008 R2 as this is the latest SQL Server edition. My attempt was to create a generic tuning guide for System Center but because […]
Azure Log Analytics – Testing JOINs Part 2
Posted on Author stefanroth
In part 1 we got a pretty good understanding how joins work and what the results are. To make this a complete series we will now work on the remaining join types. Full Outer The fullouter join is a join that shows in addition to the inner matches, there’s a row for every row on […]
SCOM 2012 Maintenance Mode Script – Computer maintenance mode depending on SCCM 2012 collection membership
Posted on Author stefanroth
Maintenance mode is always something you are facing during System Center setups. Let’s say you have a SCCM administrator who want’s to deploy it’s Windows updates on a certain day e.g. Tuesday @ 08.00 p.m. o’clock, and he also decides to reboot each server forcefully after successful deployment. Because we (SCOM administrators) have to find […]