I’ve mentored several newbie DBAs over the years, and decided to put lessons and exercises into a more formal, permanent format: Applied SQL.
You can find all of my Applied SQL articles using the Applied SQL category. Remember that this is growing all the time…I will keep on adding articles as I think of them.
Here is the order in which I assign viewings, readings, and homework to new DBAs:
- Beginning T-SQL course
- Applied SQL introduction
- Backup and Restore
- System tables:
- Find and replace using regular expressions in SSMS
- (many other basics)
- Server Side Traces
- DBA Jumpstart, a free ebook of advice for DBAs, by 20 industry professionals (me included)
One of the questions we get most often is how to get into databases / SQL Server. For your convenience, here are my current responses to some of the most common “how do I…” and “what do you recommend for…” questions.
For a very comprehensive guide to becoming a SQL Server DBA, check out our DBA Roadmap Seminar, available for sampling and purchase at DBARoadmap.com.
We actually address the “soft side” (non-technical aspects) of becoming a database professional in our new online seminar DBA Roadmap, which is out in April 2012. Clearly, I highly recommend getting the DBA Roadmap: first, because it’s everything I would tell you if you and I sat down together for 6 hours to talk it over; and second, because it puts a little cash in our coffers. (DBA Roadmap is the first monetized project we’ve done under the MidnightDBA banner.)
If the Roadmap is too rich for your blood for now, you could do worse than to take a look at the book “DBA Survivor” by Thomas LaRock (blog, Twitter). It covers a different set of info than our seminar – including some technical material – but it’s a decent start.
I always start people off with my favorite basics course: the recording of my introductory class for T-SQL (T-SQL is the SQL Server programming language).
Sean and I publish tons of free tutorials on our website, MidnightDBA.com…much of it is beginner and intermediate material. If you’re looking for a rough beginner path on our site, the do something like this:
Backups: anything marked simple, basics, or beginner.
- The Best Backup Class Evar series.
Your NUMBER ONE reference for SQL Server itself should be SQL Server Books Online. It should have installed on your computer along with SQL , and you can also access it online. A really great way to get yourself going is to work through a few of the provided Tutorials (like Getting Started with the Database Engine, SQL Server Management Studio, and Writing Transact-SQL Statements).
There is also a ton of good free content elsewhere on the web. Here are some of our favorite SQL resources:
- MidnightDBA.com (of course we get listed first!!)
- Petri IT Knowledgebase (SQL section)
I have a review of Inside MS SQL Server 2008: T-SQL Querying on ITBookworm.com. Also see T-SQL Fundamentals (truly excellent), and anything else that we rate highly (that looks appropriate).
Good admin books:
- Beginning SQL Server 2008 Administration
- Administrator’s Guide to SQL Server 2005 (probably a bit outdated by now, but the core concepts are solid)
Free online resources? Of course us first! Sean has an intro series called Ground Zero SSIS: Here is Part 1, Part 2, Part 3 (for your reference, this DBARant blog references his other series). I also have introductory articles on Petri:
- Introduction to the SQL Server Integration Services (SSIS) Development Environment
- Beginning SSIS: How to Create a Basic Data Load Package in SQL Server Integration Services
As far as beginning SSIS books, Sean and I recommend Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Servicesby Brian Knight et al. (Link goes to a placeholder review page with links on ITBookworm.com.)
And definitely check out Don Jones’ book Learn Windows PowerShell in a Month of Lunches! It’s outstanding.
Online: You can follow us on Twitter (and ask questions using the #sqlhelp hashtag), read through SQL University archives, attend a SQL Lunch, join SQLPASS and attend free sessions at the occasional 24 Hours of PASS online, join a virtual PASS chapter. If you’ve got $100 to spare and you’re really fired up about becoming a DBA, definitely check out our DBA Roadmap Seminar.
PASS Summit, SQL Rally (see SQLPASS.org, U.S.A.)
SQL Connections (U.S.A.)
Microsoft TechEd (worldwide)
SQL Bits (England)
Please feel free to write at any time with more questions. We usually know where to look for good resources.