We've all been there; it's late in the day and you have been staring at your screen for hours on end looking for an answer to your problem. After much testing; going back and forth you stumble upon an article on a technical website, blog, or Microsoft site that has the answer you have been … Continue reading Give Credit Where Credit Is Due
Utility
Drop and Create Databases ~ SQLCMD Style
Sometimes there are instances when I need to drop 6 or 7 databases on my local instance. Currently, I run 3 instances locally, two are for OLTP duties and one is for reporting. One method for dropping the databases that I like is based on just a couple of SQL files and a .bat file. … Continue reading Drop and Create Databases ~ SQLCMD Style
