We’ve been running SQL Server 2000 x86 on Windows Server 2003 R2 x64 for some time. While there have been a few issues here and there, monitoring SQL related counters can be troublesome whether you are local or remote. If you are local to the server when you open up performance monitor you will receive [...]

http://midnightdba.itbookworm.com/midnightdba/blog/post/How-do-you-keep-track.aspx Staying on Track can be hard, Jen McCown outlines a few ideas of how to keep up with tasks. http://www.red-gate.com/specials/ebooks/protecting_sqlserver_data.htm?utm_source=simpletalk&utm_medium=email&utm_content=ProtectingDataN20090921&utm_campaign=SQLtoolbelt Another free ebook from redgate. John Magnabosco talks about securing SQL Server Data. http://weblogs.sqlteam.com/tarad/archive/2009/08/31/DefragmentingRebuilding-Indexes-in-SQL-server-2005-and-2008.aspx Tara Kizer gives a new script for backups. http://sqlblog.com/blogs/linchi_shea/archive/2009/09/21/the-transact-sql-prime-directive.aspx Linchi Shea gives us a vision, or at least some good [...]

Props to Brent Ozar for sending me this link for a comparison of Database tools. If nothing else it’s a good reference.

Once I passed the 70-431 I think it gave me the positive reinforcement that I was able to do this and I just need to keep at it no matter how difficult things got. Here I am, not a SQL DBA by title, but getting thrust into the position due to circumstances and desire to [...]

I hope to give you a little background on myself in the first few posts as well as catch you up to speed on where I am today and how I got here. While this may not seem technical a sense, I believe that’s important for those who are embarking on the journey from the [...]

It has been quite a long journey to come around to getting this blog up and going. I remember talking to Brad McGehee months ago about the community and ways that I could learn from the best and slowly become one of the best. I hope to have an interview from him at some point [...]