Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

What Is the Hardest Feature to Learn About SQL Server?

By Andy Warren,

Today we have a guest editorial as Steve is away at SQL Bits XII.

I was thinking about this recently because someone asked me what was the hardest topic to teach or learn with regards to SQL Server. That’s interesting because a lot of the features are easy to use. Take replication for example. I can show someone how to set up transactional replication, explain the basics of how and why it works, and have them do a couple complete set up and tear down exercises in the space of little more than an hour.

As I think back to my days as a SQL trainer I watched students struggle with Service Broker. The combination of not being sure of the use case, the new vocabulary, and frequently XML messages led to something that wasn’t easy to learn. Most students “got” inner joins before they ever came to class, but when I taught students new to SQL most got it quickly - but some, smart though they were - just could not. I could not get them to create a mental model of joins that made sense. Students often struggled with HA vs DR and the somewhat confusing mix of solutions we could apply within SQL combined with those done outside of SQL.

Features are perhaps easier to learn than topics. Learning performance tuning could be the work of many years, if not a lifetime! Clearly there is a difference between someone who can set up replication and someone who can troubleshoot it, between someone who can write a complex query and someone that can apply all the tuning possibilities to it. We get paid to know features and topics, but clearly the ability to use the features is the starting point for being useful to a client or employer.

So I’m curious. Think back to when you started, or even the newest features of SQL 2012 or SQL 2014. Is there a feature you’ve struggled to learn? Or do you think it’s possible to learn any feature of SQL to the point of being able to do the basics within four hours or so?

Total article views: 409 | Views in the last 30 days: 2
Related Articles

The Professional Student

This week Steve Jones talks about the need for people working in technology to be professional stude...


Microsoft Student Career Portal

Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to r...


How do you learn the advanced stuff?

Today Steve Jones talks about learning those advanced features that you don't get the chance to use ...


SSC Editorial: What Is the Hardest Feature to Learn About SQL Server?

I wrote What Is the Hardest Feature to Learn About SQL Server? not really knowing what answer to exp...


Learning C

As we use computers more and more, and more people must develop algorithms or simple programs, Steve...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones