Monthly Archives: May 2013

Getting Information from a Database using Dynamic SQL

I ran across someone that was building a restore script to automated their restores. This person wanted their script to work with any instance, and that means they’d need to find the path for the database files, if the database … Continue reading

Posted in Blog | Tagged , | 3 Comments

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality. I wrote recently about Windows 8 and what I consider to be poor design in the update system. Today I want to look at another aspect … Continue reading

Posted in Blog | Tagged , | Comments Off on Software Design and Schizophrenic Windows 8 Part 2

The Control Poll

I was reading about version control systems (VCS) recently, brushing up on some skills, and saw this quote in a thread: “There is no excuse for not using version control, even for a small project developed by single developer. Setting up local … Continue reading

Posted in Editorial | Tagged | Comments Off on The Control Poll

Honeywords in SQL Server

As we become more and more security conscious, it becomes more important not only to configure systems for better security, but also to add more monitoring and auditing to detect when problems occur. We know that at some point someone … Continue reading

Posted in Editorial | Tagged , | Comments Off on Honeywords in SQL Server