My professional development into the DBA role I started this year has been on full blast. Almost to the point I’d say I’m border line burnt out. While it’s all been some what repetitive, repetition I find is my most effective way to learn.
This week I’m finishing up 2 of 3 one week Microsoft SQL Server courses work has sent me on. Today I learnt something new in the form of the T-SQL MERGE statement. Check it out for yourself here, what it’s capable of is pretty awesome.
I also have a heap (the fact I thought of un-indexed tables when writing this must mean I’m in SQL learning overload) of SQL Server books to read at work. At the moment I’m reading Sybex SQL Server 2008 Administration, which is an excellent read and a book I also recommend. As well as database administration tasks, it also deals with database concepts, terminology, design and planning.
After all this, I’ll be glad to go back to work and put this all to practice. I’ve already gotten my feet a little wet, but in between studies I’ve had a think about ways to improve our backup strategy as well as data integrity and high availability.
That’s all for now, live long and prosper.