Tag Archives | General

Links for 092509

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 thoughts on how it should be.

http://www.brentozar.com/archive/2009/09/how-to-deliver-a-killer-tech-presentation/
Brent Ozar gives us presentation tips. Everyone should want to be the best.

http://sqlblog.com/blogs/kevin_kline/archive/2009/09/18/new-post-on-my-sqlmag-blog-free-dmv-monitoring-tools.aspx

Kevin Kline gives us some DMV tools.

Comments { 0 } Posted on September 25, 2009 in Links for the Week, SQL General, SQLServerPedia Syndication

Comparison of database tools

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

Comments { 1 } Posted on March 20, 2009 in Education, General, SQL General

Keeping the ball rolling

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 get it done I have to try and become really good at what I do. I decided to go with the 70-443 next so I purchased the 70-443 Self Paced Training Kit from Solid Quality Learning as well as the Sybex MCITP Administrator: Microsoft SQL Server 2005 Database Server Infrastructure Design Study Guide. I’ve since bought all 3 of the sybex in this series as I like them for referrence better than the Self Paced kit. I continued to spend hours every night pouring it into those books and practice. I also set a date and paid my testing fee to give myself a deadline, and I passed the test on my first try. The only test left was the 70-444 and I was relieved to hear that it may not be as hard as the 443. I purchased the Self Paced kit for this exam and went through the same process to finally become a MCITP Database Administrator. For me, it wasn’t about becoming a “Paper Tiger” as much as it was forcing myself to learn. I wanted to gain credibility and experience in a field that was new to me in a sense. I also understand that it’s not that hard for some people to pass these test without knowing the material. For me, there’s no way I could have passed it without an understanding because of how I function. It helped me to stay focused and I would encourage you to find what will keep you focused as you seek to be the best DBA or developer that you can be.

Since that time, I’ve tried to take advice from others about getting involved in the community. I’ve gone from reading blog posts and forum questions to writing blog posts and answering questions. Sometimes the best way to learn something is to try and find an answer for someone who can’t find it themselves. That covers most of the introductions for now and I hope you’ve gotten a little better idea of how I got to where I am at and how we can learn from each other and continue on our journey of becomming a master SQL DBA (or whatever you want to master in the SQL world).

Comments { 1 } Posted on February 13, 2009 in General

Getting over the Hump

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 beginner mindset. Everyone has been there at one time or another, and the more resources they have the better chance that something will click.

After sitting in the IT World for so long and becoming someone who knows a little about a lot, I decided it was a good time to become the guy who knows a lot about a little. Having a wide range of knowledge has its advantages, but if you really want to excel in your career it helps to have at least one primary focus. One thing that you are as good at/or better than anyone you know. If you are not there and you are working on it, then that’s the same thing. Personally, I felt that it was time to try and become a SQL DBA Master and that’s how I started the journey.

It was a blessing in disguise that I was asked to look over a problem that had been occurring with SQL Server 2000 at my new job. I had not done any work with performance tuning, and my experience with SQL Server involved creating the database and items lower than that. I really dove into the deep end with a passion, and found that this was something that I enjoyed doing. I learned some things the hard way, but that is how it goes sometimes. If you haven’t experienced a moment where you realized you “don’t know it all” then I welcome you to have a moment and come back in a few minutes. I had found the area that I wanted to pour myself into and try to become the best I could be.

I had been holding onto the 70-431 Self Paced Training Kit from Solid Quality Learning for several months trying to set goals only to see everything else get in the way. Never mind the fact that I had a young child and pregnant wife so my responsibilities were many. It was real easy to put the book aside and play with my little boy. As I stated in my earlier post, the ebook from Brad helped get me over the hump. It was time to put in the sacrifice to become an exceptional dba. For me, that meant putting a great deal of effort to learning from the 70-431 book and getting ready to take the MCTS : SQL Server 2005 Implementation and Maintenance exam. I also determined that it help me a great deal to go ahead and pay for the testing fee and set a date in the near future to take the test. If an emergency came, I could always move it back if I had to. What I found that is even when an emergency(a death in the family and a flight back from Florida the day of the exam) came, I was still so passionate about getting this under my belt that I went ahead and took the test and passed. Getting that first certification was a big deal for me since it gave me confidence and the energy to move forward. Throughout this whole time, I was dedicating 2-3 hours a night to studying and trying to learn. For someone with ADD and a terrible memory this was a huge step for me. In my opinion, this journey takes sacrifice. It takes learning how to manage priorities in a way that I could have never imagined myself being able to do. It means making a committment and being ready to stick to it. I hope that I can one day inspire someone the way that Brad’s ebook inspired me.

Comments { 0 } Posted on February 12, 2009 in General

The Journey Begins…

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 in the near future that will help other beginner DBA’s in their journey. I can’t replace the purpose that the great blogs and forums that we all frequent serve, but I hope to add a small niche in our huge community that will help someone get that extra little fuel they need to begin or keep going on the SQL Server DBA journey.

The timing of this post is to coincide with my first article published on sqlservercentral.com with the hopes that it will help me stay motivated and keep giving back in the same manner that I have received. That article should be published in the next week or two and I’ll link to it from here. I hope that it will get the ball rolling for everyone to talk about ways to improve our workflow.

I want to finish by passing on a resource that was invaluable to me and helped push me over the hump when I first began the journey or working primarily with SQL Server. I came accross Brad McGehee’s excellent ebook entitled “How to be an Exceptional DBA” that really motivated me and I look back over at regular intervals. I would recommend it as a great tool for anyone beginning their journey or looking to refine their role in the community. You can find a copy of the ebook here. The link takes you to the Red Gate Software page offering a free trial of Red Gate’s DBA tools but you can also download the ebook without the software. Go grab a copy now.

Comments { 0 } Posted on February 11, 2009 in General