In this blog post, we give a short summary of last week’s webinar about SQL Server security management.
Keeping SQL Server security tight is challenging, and the more SQL servers you have, the harder it gets––yes, we get it, BUT it doesn’t mean having to mull over problems you’re trying to solve.
Shield Corporate Data with SQLDocKit
Webinar hosts Frane Borozan and Silvio Rahle explain how you can simplify SQL Server security and be left with more time for other DBA tasks. Additionally, this webinar session covers how-to’s, such as how to manage SQL Server permissions and configure SQL Server settings according to the latest best practices with the SQLDocKit.
SQLDocKit is an SQL Server administration tool that helps you manage the entire SQL Server environment as well as create a comprehensive SQL Server inventory.
Table of Contents:
Introduction to SQL Server Security Management
In the introduction part, Silvio discusses how to create SQL inventory with valuable information about your SQL Servers, SQL Server BI Services, databases, host servers, and more.
Before you get started with security, SQLDocKit can detect all SQL Server instances you have installed in your environment (including Azure SQL Servers). Afterwards, it can audit SQL Server settings. SQLDocKit can auto-discover all your SQL Server instances in your environment and across multiple domains. The tool can gather all SQL Server inventory and store it in the form of a snapshot that you can later use to compare and track configuration changes.
SQLDocKit offers various options to help DBAs perform security management actions, such as:
- Auto-discover all SQL Server instances
- Compare changes
- Generate SQL Server inventory
- Create new SQL Server logins
- Grant or remove user permissions
- Delete outdated principles
For a detailed guide on how to perform all of the above-mentioned actions in the SQLDocKit interface, skip straight to the demo hosted by Frane Borozan, SQLDocKit product owner.
Manage SQL Server Permissions
Each server has multiple users with multiple logons, and they all have different roles on different servers. SQLDocKit can help you make SQL Server permission management less of a hassle.
For example: You need to grant a sysadmin role to someone on a particular server or multiple servers—but only for a few days. After that, the given permissions must be revoked. In this case, start SQLDocKit, and specify the exact time when specific grant and revoke actions are to be executed. This means that SQLDocKit will create a role and then later remove it automatically. How do you do this? Via SQLDocKit’s Scheduled Actions Wizard.
All these actions can be done simultaneously across multiple SQL Servers from a single interface, of course.
Here’s the real kicker:
All reports and documentation you create with SQLDocKit can be exported to a PDF or Excel file.
SQLDocKit’s New SQL Server Security Best Practices
Our users have been most interested in the SQL Server Best Practices feature, and that’s why, in our latest release, we’ve added more than 20 new SQL Server best practices, which now adds up to 40!
Okay . . . So what kind of new BPs are we talking about?
SQLDocKit allows you to validate certain SQL Server configurations by community best practices.
This means you can use SQLDocKit to:
- Fine-tune the SQL Servers so that multiple databases can work coordinately
- Reach optimal SQL Server performance
- Prevent common database issues
- Ensure server permissions aren’t granted a public role
- Make sure your users aren’t using generic, easy-to-hack passwords
The greatest part?
SQLDocKit enables you to check and enforce all these best practices automatically.
Refer to the SQL Server Best Practices Library to check out what each BP is about. Also, we all know that SQL Servers and SharePoint servers should be configured to play nice together. What settings should you adjust? Here’s a useful article with jam-packed insights on how to tune an SQL Server for SharePoint.
Start SQLDocKit with a free 30-day trial
Download SQLDocKit try it for 30 days to see if you experience a load off your shoulders when it comes to SQL Server administration.
- How to Compare SQL Servers in your environment with SQLDocKit (webinar)
- How to generate SQL Server documentation? (blog post)
- Enhance your admin superpowers with SQLDocKit 7 (blog post)
- A New Approach to Compiling an SQL Server Inventory with SQLDocKit (blog post)
- 10 Best Practices for Hardening SQL Server Security (blog post)