I see the phrase ‘accidental administrator’ and even ‘accidental architect’ often in our industry. At some point in our career we get put in charge of things we don’t own at first much in the same way as when your neighbor goes on vacation and asks you to look after their cats.
This is very true for many database administrators out there. Nobody goes to school to be a DBA. We fall into the role by accident because (1) we think the job is cool or (2) we think we can do the job better than anyone else, or a combination of both.
But after a few weeks, once we’ve created a table, or altered a column, or reset a password we are then seen as someone that can design an entire database for a project. We sit in meetings, we take notes, and we go back to our desks to do as we’re told and we don’t often think about the ramifications of the design choices that we are implementing.
And that means this: Over 90% of the databases out there right now have been designed by an accidental administrator*, if they are being designed at all.
When the SQLBits call for speakers went out I immediately wrote an email to Karen López (blog | @datachick) and asked her if she would do another training day with me, this time focused on database design for accidental administrators. And thus the session ‘Advanced Accidental Database Design‘ was born.
Similar to last year, the day will include lecture style format as well as interactive discussions and exercises. We will break the attendees out into teams and have them perform lab exercises using Azure VMs with SQL Server installed. This isn’t your average “Here’s how to create a table, now go build a database” course. Our goal is to cover new features in SQL Server 2016 that are relevant to modern enterprise development practices. We’ll talk about some of the pain points designers feel as well as the costs, benefits, and risks associated with design choices.
Discussion topics will include:
• Advanced database design process
• Advanced Data Types (XML, JSON, Geospatial)
• Files/Filegroups/Partitioning/Archiving/Stretching
• Security/Encryption/Data masking/Audit
• Advanced Table design Topics (Temporal/Hekaton/Compression)
• Other Advanced Topics
Attendees will leave our session with an understanding of new features in SQL Server 2016, advanced database design process for modern enterprise development projects, and how to decide which design choice is the right decision choice for your needs.
If you have the opportunity to go to SQLBits and attend a training day we’d love to see you.
If you aren’t able to attend SQLBits but still want a taste of our session you are in luck, we’ve got you covered there, too. Next week (12th April, 2016) we will be doing a webinar for SolarWinds, Advanced Accidental Database Design, taking place at 9AM ET (13:00 UTC).
Join us for the webinar and get a taste of what it would be like to be stuck in a room with us for a full day!
*-I’ve no idea what the real number is, and neither do you.
Love the idea. I know I fell into the role, not even knowing what “sequel” this server was to, but that I’d be employed to work with it. 🙂 Of course, since those days back with 4.21, I read, listened, practiced, and learned so I didn’t stay in that early state and knew that there was a LOT that I didn’t know. Since then, there’s a lot more that I don’t know because the product has grown so much. I can only assume that this will be really great for those who happened into the role and can give them tips to do things right or at least avoid some of the horrible practices they would have otherwise. I won’t be at SQLBits and can only hope that the recording will be available in a year or two or that you’ll post about the experiences after it happens.
Thanks for the feedback Peter! That’s our general idea as well, that there is so much for an accidental DBA to know and we are going to look at physical and logical database design first. There is so much material for us that I’m thinking this needs to be a three day class.
Hi,
I missed the webinar, is it possible to watch now on youtube or elsewhere?
I don’t think it is posted yet, but I expect it to be listed here when it is ready: http://launch.solarwinds.com/EMEA-WEBINAR-RECORDINGS.html