Skip to main content

TSQL2sday #008 – Gettin’ Schooled

TSQL2sDay This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here. This month’s topic is titled ‘Gettin’ Schooled’ and for those participating in the blog party this month we will be looking at how we learn and how we teach.

This fits in quite nicely with my post from last Thursday where I wrote a short note on the SQLBITs conference being held in the UK this Autumn.

How do I learn?

I have been working with SQL Server since 2002, for most of that time as a DBA. This post will focus on the learning that I have undertaken since becoming a DBA. I know we all went school, some of us went to university, some of us may have even taken higher degrees in the form of Masters or PhD's etc. There has actually been quite a lot of debate and quite a lot written about whether you need college/university degree to be a DBA and I don’t want to go down that route and discuss that topic here, instead I want to look at the type of learning I think most DBAs and developers will have gone through at some point to train themselves to do their jobs.

Technical Training

When I first started out working with SQL Server I was very lucky.  My employers at the time had a reasonable training budget and they were prepared to send me on several official MCT courses. All SQL Server based and all based around the MCDBA. I forget about the actual course titles but there was a course on administering SQL Server. As a ‘newbie’ to the DBA profession and relatively new to SQL Server those courses did actually provide a good grounding for me because I was able to apply what I learned on the course in a practical environment, supporting production SQL Servers. I did also take the exams/certs associated with the courses and I have achieved both the MCDBA (SQL Server 2000) and the MCITP for SQL Server 2005. Certification is another discussion altogether! The training was good for me because I was able to combine  the theoretical  lessons and labs of the course with practical hands on experience. This meant I learned and gained experience in the technology and later I was able to pass the exams. I think  that practical real life work experience was vital though for any DBA.


The best learning experience for me personally was in doing the job of a DBA. I was lucky, I got good training, more importantly I got two great mentors in my first full time DBA job. These guys taught me a lot and they helped me greatly early in my career. They gave me plenty of responsibility but at the same time were always available to help me out when I needed it and because of the help and responsibility  those guys gave  I was able gain great experience.

As the years have gone by and I have changed jobs and setup my own contracting company I have found that as technology changes and new features and products have come out the best way to learn these new technologies is to use them and figure them out for yourself. I’m lucky I have a MSDN subscription which allows me to use the Microsoft products and technologies as they come out. I have a very powerful desktop where I can run a several virtual machines at once so I have very own test domain setup  where I can try different  technologies and experiment with different setups.


I have read many SQL Server books over the years and books are still a great way for a DBA to learn. These are three of my current favourite titles:

SQL Server MVP Deep Dives

Professional SQL Server 2008 Internals and Troubleshooting

Microsoft SQL Server 2008 Internals (Pro - Developer)


I read a lot of blogs from people in the  SQL Server community, I find this a great way to learn and keep to update, from the documented experiences and knowledge of other people doing a similar job to myself. My top 10 SQL Bloggers (Taken from my Google reader reading trends) are

1.Paul Randal
2.Kimberly L Tripp
3.Steve Jones
4.Brent Ozar
5.Brad Mcgehee
6.Buck Woody
7.Jack Corbet
8.Adam Mechanic
9.Thomas LaRock
10.Denny Cherry

There are many more great bloggers out there and I read most of them but I could fill the page with a list of the good blogs that I read, apologise if I haven’t listed you, but feel free to leave a link to your blog in the comments if you think it is something that we all should be reading.

User Groups and Conferences

I like conferences they are a great way to learn and good way to network. There are many conferences and user groups out there, I wrote a post last week about the SQL BITS conference you can find that post here. I also recently attended a SQL Server Master Class held by Paul Randal and Kimberly L Tripp you can read my review of that great event here. There are a number of virtual user groups you can attend. I like the events put on by pass especially if travelling distances is difficult for you, you can attend these events from the comfort of your own desk and they are a great way to learn.


I have been writing about SQL Server since 2007. I have been writing this blog since late last year. I found writing on my website a little more time consuming and tricky than writing on the blog so I tend to write more on my blog these days but the website is still available. I started writing to improve my knowledge and enforce my understanding of SQL server. If I’m required to learn something new I like to write some blog posts about it. It reinforces my knowledge, If I get anything wrong people are very helpful and point out my mistakes or maybe ask questions which again allows you to grow and expand your knowledge. If you write on a blog or website it will be there for future reference and you might just help somebody else along the way.


Popular posts from this blog

SQL Server 2012 and Virtual Service Accounts

This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the default account for the SQL services has changed from that used in previous versions. With SQL 2005 and 2008 the default account for SQL service and SQL Agent service was “NT Authority\System”. This is one the built in accounts on a Windows machine, managed by the machine and selectable from a dedicated dropdown list

The Network Service account was introduced in Windows 2003 as an alternative to using the LocalSystem account, which has full local system privileges on the local machine, a major security concern.
The Network Service has limited local privileges easing these security concerns but when many services on a machine use the Network Service account it becomes harder to track which service is actually accessing resources and performing actions, because all the services are using the one Network Service account.
Also, this account, by default, has sysadmin per…

Always Encrypted

By David Postlethwaite

Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database. Here you can encrypt columns in a table with a master key and a certificate so that they will appear as encrypted strings to those who don’t have the required certificate installed on their pc.
Once the certificate is installed on the computer then the unencrypted data can then be seen as normal.

The data passes from database to your application as the encrypted value, only the application with the correct certificate can unencrypt the data so it is secure across the wire. This will go some way to resolving the concern of people worried about putting their sensitive data on a shared server in the cloud such as Microsoft Azure and accessing the data across the Internet.

At the time of writing Always Encrypted is only supported with ADO.NET 4.6, JDBC 6.0 and ODBC 13.1 but expect other driver to become available.

The calling application (including SSMS) must also hav…

New in SQL Server 2017: Graph Databases

David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you can watch below, David provides an excellent introduction into SQL Server 2017 Graph Databases. In his presentation he looks at Tennis results at tournaments for  his favourite player "The Fed"  Rodger Federer.

David  shows how to set up graph database and work with them in SQL Server 2017.

Graph Database is not new. Other vendors have had graph database capabilities for some time so Microsoft are quite late to the market. In David presentation it appears that Microsoft have done a reasonable job of implementing some of the graph database features but he does point some of the limitations of the Microsoft product too and suggests that it is not ready for production yet but Microsoft seem serious about this feature.

Please watch the video and feel free to leave a comment or feedback - David is delivering a version of this talk on Graph databases in SQL Saturday Ka…