How safe and secure is your data?
Your system and network admins may think everything is up to snuff with your database environment, but we know from performing many SQL Server health checks & security audits for businesses across a variety of industries that most database servers are poorly configured. In fact, many times, very small changes lead to significant improvements in performance and reliability. And since environments are constantly changing with newly added databases, new reports, changing permissions, etc. regular health checks and security audits are a must. Contact us today to get an outside party, expert review of your environment.
When was your last checkup?
SQL Server is easy for any IT professional to install, but if your database servers were configured without expert knowledge and industry experience, you should consider an Emergent SQL Server Health Check. Emergent database health checks include a top-to-bottom analysis of your SQL Server environment including:
- SQL Server Settings: max memory, trace flags, optimize for ad hoc workloads, etc.
- Database Settings: database file locations, growth settings, VLF fragmentation, etc.
- SAN: physical disk evaluation
- VMware/Hyper-V: vSCSI driver, server template, etc.
- Temp DB: number of files, file locations, growth settings, etc.
- Database Backup & Maintenance: index maintenance, integrity checks, recovery model, etc.
- Memory Pressure
- CPU Pressure
- Disk I/O Pressure
- Indexing: missing indexes, bad indexes, fragmentation
- Operation System: power management settings, what's installed?
- Other: memory dumps, log entries
- Security: (see below)
Contact us today to get the most of your SQL Server environment.
Considering building a new SQL Server instance or cluster? Contact us today to start your new database environment on the right foot--schedule a SQL Server Best Practices installation and configuration.
Who is "sa"?
It can be an eye-opening experience for IT department leadership when a security audit shows that everyone in the company has full access to their databases (the Active Directory Users group was a member of the sysadmin role in SQL Server). Take it from this real-world example that you cannot trust your own system administrators with limited SQL Server experience to secure your database environment. If you don't have a detailed report of who has access to what in your database environment, you need an Emergent SQL Server Security Audit.
IT professionals, consultants and power users often create huge security holes in your database environment because “it’s easier” or to get it working with a “plan to close the hole later.” Even many 3rd party vendors erroneously tell you they require your “sa password” for installation or worse yet for the system to function. Did you know that it is best practice to disable the sa account and that anyone in the sysadmin role has the same privileges? Our security audit includes over 70 security best practices checks on all of your SQL Server instances including the following areas:
- Configuration & Installation: distributed queries enabled, database mail security, Windows firewall, etc.
- User Security: SA login, users with old or weak passwords, orphan users, etc.
- Programming & Code Vulnerabilities: xp_cmdshell enabled, CLR enabled, etc.
- Permissions: Users in sysadmin, db_owner & db_securityadmin roles, user impersonation settings, access to extended procedures, etc.
Contact us today to hire Emergent’s SQL Server experts to perform regular health checks and security audits of your database infrastructure, maximizing performance of your environment and making sure your data is safe.