SQL Server Consolidation

In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the consolidation iceberg - and it might not actually save you as much as you thin. Thomas takes us deeper.… Read more

SQL Server Audit: Magic without a Wizard

In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or the most highly-regulated of industries. SQL Server 2008 Enterprise Edition includes all of the features whereas SQL Server 2008 Standard Edition only provides only a subset. What is most attractive about it is that it is easy to administer, as Thomas LaRock explains.… Read more

Using Operations Manager Reports to Validate Your Uptime

Operations Manager has a number of reports to help you monitor the uptime of your applications, but reporting can be difficult to learn until you understand all the different options, the different parameters possible, and the way the Operations Manager health model is structured. Firstly, you need a clear idea about the way that your organisation defines 'uptime'. then you can start your reports from any of the views in the Monitoring tab, and then add or remove objects to get the report you need. Thomas LaRock explains...… Read more

Operations Manager: A Big Tinker Set

To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set with all the pieces available to make your working life easier.… Read more