Today I tripped over an annoying issue when attempting to install a Microsoft SQL Server 2008 R2 instance. About 30% of the way through the installation an error was thrown up:
Could not find the Database Engine startup handle
Not the world’s most informative error message, but something to search for on Google nonetheless. Unfortunately . . . → Read More: Could not find the Database Engine startup handle
Recently I uninstalled an instance of Analysis Services from a server running SQL Server 2008 R2. It was a development server hosting Reporting Services, a couple of instances of SQL Server, and a couple of named instances of Analysis Services.
The uninstall was uneventful, no error messages or issues were reported by the SQL installation . . . → Read More: A connection cannot be made to redirector
Microsoft SQL Server 2008 has a limited capability to provide a visible alert if you are connected to a production server.
It does this by changing the colour of the notification bar in the SQL Server Management Console, which can be a life saver if you have numerous SQL Server . . . → Read More: Colour coded SQL Server 2008 sessions