I’m on the train coming back from Sydney SQL Server User Group April 2009 meeting — SQL Server 2008 Security Deep Dive by Peter Ward. The event is held at the same venue where I organize Sydney Oracle Meetups (actually, it’s another way around — I learned about this place by attending the previous SSUG meeting) and it’s the top quality venue especially for the money they charge.
The presentation in two parts was exactly what an Oracle DBA like me would need to have a peek into the security territory of SQL Server. I was afraid it would be really “deep dive” and assumed lots of SQL Server knowledge but I was actually fine. I think it would be cool to have a full day real deep dive and looking at what Peter was talking about, I’m convinced that he could keep going further and further into details should we give him more time.
I learned that SQL Server security model is somewhat complex and it’s still not clear for me what is what in all these server logins, database users, schemas and etc. are doing and what are relationships between them but, again, there is just an Oracle DBA inside me. As David Lean, the voice of Microsoft there, explained — it’s historical. Indeed, SQL Server must be old enough now to have some history! ;-)
What’s cool is that I won the license for the SQL Admin Toolset from SQL Tools along with maintenance contract for a year — thanks to Tony Finnemore of Idera. Interesting, that it’s the first time I win the draw in my life. I guess it’s the last one as well, since the luck usually doesn’t come too close to me. Well, either Paul Moen or Andre Araujo in our Sydney office will be happy SQL Server DBA’s using this new tool for a year now.
The evening finished in the pub nearby where I had a pleasure to sip beer with fellow SQL Server DBA’s and they seem to accept a “spy” happily. ;-)
If you live in Sydney and interested in SQL Server technology but not part of the SQL Server User Group — you are doing something wrong. You can register for free and enjoy free pizza once a month as well learn what’s new and exciting is going on in SQL Server land from such experts like Peter Ward. See you around!