How can you properly set up permissions and security?

by Aug 13, 2020

Being in the computer industry is one of the most challenging things anyone can get into. When upgrading one’s knowledge to keep the data secure, there are many hurdles to cross. In this industry, where we look for quick, fast responses from development to deployment to sales, everyone is expected to deliver without compromising any of the business parameters. As we chase around the strict deadlines for delivery, the team tries to take shortcuts. That, for most cases, involves cutting corners and compromising on designing for secure systems. That is a concern for many organizations. Database administrators love to build a secure system to deploy applications delivered from the Application team.

Read the 12-page whitepaper “Nuts and Bolts of Permissions and Security by Pinal Dave to learn about the basics of security. It covers some of the fundamental building blocks that were added with SQL Server since the 2005 version that is worth noting till today in SQL Server 2019. It presents principals, logins and users, password policy troubleshooting, and the special user sysadmin.

Click here to download the PDF file.

The presenter, Pinal Dave, is a SQL Server performance tuning expert and an independent consultant. He has authored twelve SQL Server database books, and 33 Pluralsight courses. Pinal has written over 5100 articles on the database technology on his blog at a Along with more than 17 years of hands-on experience, he holds a Master’s of Science degree and some database certifications.