Blog & Company Updates

SQL Security Set Up Best Practices

Security is crucial and at the forefront of everyone’s minds in business, especially if you’re a DBA. Of course, everyone should be mindful of security but for the DBA, it’s your job. The DBA is typically thought of as the gatekeeper of business data and we all know that the amount of data is growing in leaps and bounds.

In a recent webinar by consultant and DBA Michael Wall, he shows you how to protect your backups and secure your data with the proper setup of SQL Server. DBAs need to be aware of their whole enterprise so they can make the business appropriate decision. They need to consider the business practices and needs and balance them against good solid security practices.

The webinar covers topics and best practices around:

  • Setting up SQL Server using local service accounts which take a lot of the guesswork out of usernames and passwords.
  • File systems and the Principle of Least Privilege – which means giving the user/application/service only the rights needed for them to get the job done.
  • A walk-through of the SQL Server install.
  • Password policies and the difference between logins and users.
  • Roles – Basic roles, server roles, database roles and custom roles and how to make roles work for you and the business.

So, if you want to learn how to protect your backup and secure your data, this webinar is for you. You can watch the complete webinar below.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Author

  • 3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

3CloudSQL Security Set Up Best Practices