Related Articles
SCOM – SQL Server Event ID 28005, AEM Wizard Runs Forever, Reporting Services Not Working
Posted on Author stefanroth
I like to automate things, creating batches and scripts. Well at least I like to create them myself and then I know what they do. In a small project I needed to install SCOM 2012 SP1 to show Agentless Exception Monitoring. Because larger environment need a managed way to install IT systems identically they often […]
PowerShell – Create “Clean” Custom Objects From DataTable Object
Posted on Author stefanroth
I recently had a need to create “clean” PowerShell custom objects out of a DataTable object. What does that mean? Well, let me explain. When you try to get data out of SQL Server using PowerShell there are many ways to do it. Either you use Invoke-SQLCmd, SQL Server PowerShell (SQLPS), SQL Server Management Objects […]
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 […]