Tag Archives: administration

If You Need To Fix Database Filename Extensions

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however, and you might wish to “fix” the filenames to conform to the proper extension. How can you do this? Well, … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Does the SQL Server Database Filename Matter?

Do you know the basics of how to create a database? Hopefully you do and can do so without the GUI. However do you know the extensions are for database files? As of SQL Server 2012, these are the extensions: … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Regression Testing before CUs and Service Packs

Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this … Continue reading

Posted in Blog | Tagged , , | Comments Off on Regression Testing before CUs and Service Packs

A Patch Disaster

Can you imagine sending the wrong patch to the wrong machines? That’s what happened with an Australian bank. Am OS patch was sent to many more machines than it should have. The patch was designed for desktops, but managed to get … Continue reading

Posted in Editorial | Tagged , | Comments Off on A Patch Disaster