Where Do I Start – The Journey?

I've recently been approached by numerous people at work, on boards, forums, twitter, etc. regarding different ways to learn and improve one's skill set. The Forums I find myself on forums more so than normal perusing through questions, providing feedback where applicable and so on. Some of the ones I traffic often are: SQL Server …

Continue reading Where Do I Start – The Journey?

DBA Deployments

There are many aspects a DBA must handle on a daily, monthly, yearly basis. One that has been sticking out to me in recent weeks is deployment methodologies and the various ones that other people might have in place. For example: My current process utilizes TFS and RedGate tools. Below is a representation of what …

Continue reading DBA Deployments

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