SQLSaturday Houston!

Thanks for joining me for a full room and a boatload of quick-delivered SQL 2017 information in the second timeslot today at SQLSaturday Houston 2018! Lots of great questions, especially about adoption of SQL Server 2017.

Quick recap of this answer question: outside of a third-party vendor's support, there is no good reason to upgrade to SQL 2014 or SQL 2016 instead of SQL Server 2017. As of this week, 2017 has been patched eight times. In fact, because of the new options available to deal with rare issues with the Cardinality Estimator changes in SQL Server 2014, it's easier to upgrade to SQL Server 2017.  Unfortunately, software vendors don't always respond to new SQL Servers to "certify" and "support" their software on new versions of SQL Server, or, they use support for new versions of SQL Server hostage along with new versions of their own software. This isn't cool, and to be clear, there isn't any technical reason to go with SQL 2014 or SQL 2016 as opposed to SQL 2017.

It's awesome to see so many great (and new!) sponsors at these events, helping keep alive the spirit of free community tech training. Be sure to thank sponsors and volunteers for making a day like this happen, trust me, it's appreciated!

Download of my slidedeck is available here and has been uploaded to the SQLSaturday Houston 2018 schedule site.

Thanks to light-up lanyards, the attendees could track me in the dark

SQLSat Houston This Weekend!

The wife and I are making the road trip this weekend to SQLSat Houston and we're both speaking!

This SQLSaturday Houston is going to be great - looking forward to seeing the #SQLFamily, many for the first time since Hurricane Harvey. I've been helping clients get back on their feet ever since and I hope to hear lots more stories of successful recovery.

I'll be giving my presentation on What's New In SQL Server 2017 and handing out a couple complimentary copies of the Microsoft SQL Server 2017 Administration Inside Out book that inspired the presentation.

Complete schedule: http://www.sqlsaturday.com/766/Sessions/Schedule.aspx

SQL Server Permissions and Security Principals on UserGroup.tv

You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a site dedicated to capturing presentations just like this, run by Shawn Weisfeld, Sr Technical Evangelist from Microsoft. Thanks Shawn!

Thanks again to the organizers of the very successful SQLSaturday Houston event and to my first-in-the-morning presentation audience! 

Click here for the video.

Great to see you at SQLSaturday Houston 2017

Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers. I presented in the first timeslot of a stacked schedule, and met and made a lot of friends.

My talk on SQL Server Permissions and Security Principals had a great crowd in the morning, about half of whom had never attended a SQLSaturday event before. I was thrilled to be their (hopefully good) energetic first impression!

You can download my slide deck and sample scripts here at the SQLSaturday Houston schedule page.

Please reach out if you have any questions, contact info in the slidedeck. Thanks to UserGroups.tv, you can click here for the video of the presentation.

See you all at SQLSaturday Baton Rouge on July 29!

Early birds catch the worms. Learning in the 8:30am session. #SQLSatHouston pic.twitter.com/IwKb7Jsi57

— Robert Anderson (@RAndersonTexas) June 17, 2017

SQLSaturday Houston 2017 - I'll be there, will you?

Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!

Will be happy to see the #SQLFamily on Friday night and Saturday! So many faces I only get to see once a year, too many!

I'll be presenting in the very first time slot on Saturday morning. Who says 830AM is too early for SQL Server Permissions and Security Principals? Then I'll be helping represent both Sparkhound and PASS at the event. Maybe I'll even get to do this again.

I'm bummed that I'll be presenting in the same timeslot as good friend and fellow Baton Rougean Thomas Leblanc and also good friend and my predecessor as PASS Regional Mentor (and now Microsoft employee) Ryan Adams. What a loaded lineup the rest of the day too!

See you there!

SQL Server Permissions and Security Principals at Houston SQL Saturday 2015

Thanks to everyone who attended my presentation on SQL Server Permissions and Security Principals this morning at Houston SQL Saturday 2015!

What an awesome event! Please join me in sending a note of thanks and congratulations to Nancy Hidy-Wilson and the rest of the Houston Area SQL Saturday User Group for organizing this awesome event.

My session was be 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, contained databases, application roles and more.

Download my slides and sample scripts here:
http://1drv.ms/1FSdJvh

 

See You Next Weekend at SQL Saturday Houston!

Looking forward to speaking next weekend at SQL Saturday Houston 2015 on June 13!

If you haven't already registered for this great event, here's the link: https://www.sqlsaturday.com/408/registernow.aspx

This event will be held at San Jacinto College in Houston, and admittance to this event is free but there is a $10 lunch fee.

I'll be presenting on SQL Server Permissions and Security Principals at 9:45AM in room 1.115. My session, which I have done at other SQL Saturdays in the past, will be 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, contained databases, application roles and more. This class is perfect for DBA's, developers and system admins.