So what should you do if you are an “accidental DBA”, who ends up dealing with SQL Server in some capacity on a regular basis without the benefit of any training or experience? What if you are what I like to call a “captive DBA”, because you must install, maintain, and support some other Microsoft product (such as Microsoft SharePoint, Microsoft System Center, Lync Server, Team Foundation Server, etc.) that uses SQL Server as a data store? Perhaps you have some third party applications or internal applications that use SQL Server as a data store? If you find yourself in this situation, you are not completely alone in your cubicle or office, with only your favorite search engine for help. There are plenty of good resources out there where you can get help and learn more about SQL Server. Even if you are not planning on becoming a dedicated SQL Server professional, there are a number of ways to get immediate help and to start learning enough to get your job done.
Luckily, there is a large and vibrant “SQL Server Community” that is more than willing to help each other out, both online and in person. There are many different ways to learn more about SQL Server, depending on what works for you. One of the first things you should do is get a free account on Twitter, and start using it. You should follow some SQL Server people, and start participating so you get to know people and they get to know you. You can use the #sqlhelp hash tag on Twitter to get expert help within minutes. You can post questions on the various SQL Server-related forums to get more detailed help that may take a little longer. As you use these resources, be polite, and try not to annoy people right off the bat. Saying please and thank you, and not arguing too much make a world of difference when it comes to getting help on Twitter and in the forums.
It is also a good idea to read a few blog posts related to SQL Server every day. You can use your favorite RSS reader to subscribe to a number of blogs and see what interests you. I think it is also valuable to buy a few books about SQL Server, and actually read them. There are also a number of different training resources, both online and in-person, that you can use to learn more about SQL Server. I have listed a few of these various resources below, to help get you started.
WeFollow – SQLServer (Good list of some of the better known SQL Server people on Twitter)
#sqlhelp Hash Tag on Twitter (Good advice from Brent Ozar on how to use the #sqlhelp hashtag on Twitter)
SQL Server Blogger Rankings (Thomas LaRock’s blogger rankings list)
Microsoft TechNet SQL Server Blog List (List of SQL Server-related blogs compiled by Microsoft)
SQLServerCentral Bloggers (Blogs that are syndicated to SQLServerCentral)
SQLBlog Bloggers (Blogs that are syndicated to SQLBlog)
SQL Server Books for DBAs (Thomas LaRock’s list of recommended SQL Server books)
Troubleshooting SQL Server – A Guide for the Accidental DBA (Excellent book on how to configure, monitor and troubleshoot SQL Server)
DBA Survivor: Become a Rock Star DBA (Great career guidance for new DBAs)
SQL Server Hardware (My book on how to select and configure hardware and how to install and configure SQL Server)
Professional SQL Server 2008 Internals and Troubleshooting (Classic book about how to diagnose and troubleshoot performance and other problems with SQL Server 2008)
Professional SQL Server 2012 Internals and Troubleshooting (Completely new version for SQL Server 2012)
SQLSaturday Events (Free training events that are held on Saturdays around the world)
SQLskills Free Online MCM Training Videos (Great learning resource even if you are not interested in the MCM certification)
Pluralsight SQL Server Courses (High quality, affordable online training)
SQLskills Immersion Events (Extremely deep technical training from SQLskills)