Value cannot be null

After issues with my laptop not being able to find critical files this morning I managed to boot to the last know good configuration. This seemed to have got me past all the errors I previously had, however, I noticed that things weren’t quite right. When attempting to open SQL Server Management Studio (SSMS) 2012 I received the error “Value […]

ORA-00333: redo log read error block XXXX count XXXX

ORA-00333: redo log read error block XXXX count XXXX I encountered this Oracle error when connecting to my database after my laptop lost power and subsequently had some severe Blue Screen issues. According to Oracle, ORA-00333 is caused by an IO error while reading the log described in the accompanying error. The resolution is to restore accessibility to the file, or get another […]

Excluding WMI system properties with Powershell

When using Windows Management Instrumentation (WMI)  in your Powershell script you will see a load of system properties returned. These are indicated by a preceding “__” (double underscore) as seen below when issuing get-wmiobject -class “Win32_Processor”:   An obvious attempt to prevent these system properties from being returned would be to use the -ExcludeProperty switch with “__*” specified. As shown […]

SQL Server Central Management Server (CMS) Intro

Introduction Central Management Server (CMS) was first introduced in SQL Server 2008, it enables simplified management of multiple MS SQL database servers and instances. My screenshots are taken from SQL Server 2012 but should be relevant in SQL 2008 and 2008 R2 as well. If you are managing more than a couple of SQL instances you’ll already be aware of […]