Monday, September 30, 2019

"Think Like a Certification Exam" at the PASS Career Dev marathon

Join me for my new webinar "Think Like a Certification Exam" at #PASSmarathon taking place on October 10!

One of my favorite non-technical presentations to give explains how and why exams are developed, who they're for, and the process behind item writing. This will help the potential exam taker, in any technology field including but not limited to Microsoft certification exams. Gain exam insights, the best prep strategies, an test-taking strategies from a veteran exam writer.

Register now for expert-led webinar content through #sqlpass: https://www.pass.org/marathon/2019/careerdev/Registration.aspx #PASSmarathon #CareerDevelopment

I'll be presenting at 6pmCT, and my wife is also giving a certainly more interesting presentation two hours before:

Saturday, September 14, 2019

Good to see you at Houston Tech Fest 2019!

It was awesome to see a great crowd at the triumphant return of Houston Tech Fest 2019. This year's event was hosted at the beautiful Microsoft Office in Houston. Thanks to everyone who joined my presentation on SQL Server Permissions and Security Principals 101 after the lengthy lunch break and learned all about SQL Server permissions, starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more.

You can download the slidedeck here: https://github.com/williamadba/Public-Presentations/blob/master/Houston%20Tech%20Fest%202019/SQL%20Security%20Principals%20and%20Permissions%20101.pptx

and reference the toolbox here: https://github.com/sparkhoundsql/sql-server-toolbox

Thanks again to the host employees at the Houston Microsoft Office for opening their doors on the 10th floor to a wide variety of area tech professionals. I met database administrators, sysadmins, Agile Scrum masters, recruiters (even someone looking for a LAMP developer), students, jobseekers, IT managers, and more.

Thursday, September 12, 2019

SQL Security Principals and Permissions 101 at September '19 BRSSUG

Great attendance and great meeting last night for the September '19 BRSSUG meeting, great to see lots of new faces at the meeting following our successful SQLSaturday event in August.

My "SQL Security Principals and Permissions 101" presentation is a ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more. This session is perfect for junior DBAs, developers and system admins of on-prem and Azure-based SQL platforms.

You can download the slidedeck here: https://github.com/williamadba/Public-Presentations/blob/master/BRSSUG/SQL%20Security%20Principals%20and%20Permissions%20101.pptx

and reference the toolbox here: https://github.com/sparkhoundsql/sql-server-toolbox

One note to add for other presenters: this presentation is broad enough to be long-lived. I originally developed this presentation in 2011, but many of the topics are just as relevant today as they were 8 years ago, even though I've added a large amount of Azure content, a section on SQL Injection, and have added/removed a slide or detail here and there for time. Continuously developing a 101-level,  topical presentation like this has been a great driver for my own ongoing education and technical reading. Between this and some other broad topic presentations like my Admin Best Practices with  DMV's presentation, I'm regularly making myself notes on new (or new-to-me) facts and tips to add over the years. I recommend this approach to new technical speakers!