Free SQL Server Training!
Join us for the November 17, 2015 meeting of the Pinellas SQL User Group. Our meetings are free and open to the public. The doors open at 6:00 pm and food arrives shortly after that allowing time to grab something to eat and networking with your peers. The meeting will start at 6:30 with announcements and open floor discussions followed by the speaker for the night.
Presentation: Real World SQL Server Administration with just a bit of sysadmin
Summary: We will review the fundamentals needed to define a configurable permission model currently in use at a large insurance company that allows database administrators to do routine work without having unfettered access to business data. I will show that many DBA tasks can be done without sysadmin access and explain what permissions are required for the most common tasks. Attendees will learn how to deploy a permission model that allows DBAs to do routine work and how to elevate permissions quickly to respond to emergencies. I will demonstrate several T-SQL and PowerShell scripts that secure the database server, undo the permission model in case of unforeseen circumstances, and discover which servers are non-compliant. Attendees will leave this session with the realization that DBAs don’t need to be sysadmin as often as typically believed, that most administration tasks can be done without elevated permissions, and with the means to deploy this model in their own environment
About Ron: Ronald Dameron is a Lead Database Administrator. He has over 20 years IT experience on a variety of platforms. His current interests are database security and automation. He holds an MCITP certification for SQL Server 2008 He is a veteran speaker at SQL Saturday Tampa, Orlando, South Florida and the Tampa SQL User group. He is most active on Twitter as @RonDBA and can also be found on Google+ and Blogger.
Food and drinks will be provided by
Our People Make IT Possible
People are at the heart of every successful business initiative. At TEKsystems, we understand people. Every year we deploy over 80,000 IT professionals at 6,000 client sites across North America, Europe and Asia. Our deep insights into human capital management enable us to help our clients achieve their business goals—while optimizing their IT workforce strategies.
When & Where
Pinellas SQL User Group
The Pinellas SQL User Group meeting are free and open to the public. The doors open at 6:00 pm and food arrives shortly after that allowing time to grab something to eat and networking with your peers. The meeting will start at 6:30 with announcements and open floor discussions followed by the speaker for the night.