Monthly Archives: February 2013

Change default Collation in SQL Server 2005

I recently had some trouble selecting the proper Collation/Sort order when setting up a new SQL 2005 installation. There was a small number of Collations/Sort Orders but not the one I needed. The official webpage for that didn’t give much … Continue reading

Posted in SQL Server | Leave a comment

Query WSUS server

On a regular basis we patch our Windows Servers and it would be nice to get a realtime view of just how patched our servers are – which servers are not yet patched and how many patches are about to … Continue reading

Posted in SQL Script, Tips, WSUS | Leave a comment

Attaching database that wasn’t detached

I recently had an interesting issue where a Virtual SQL Server was deleted from VMWare, just like that with no nice shutdown and certainly no last backup & detach database commands. We were fortunate to locate and mount the data … Continue reading

Posted in DBA, SQL Server, VMWare | Leave a comment