The Dangers of Modifying the SQL Server Public Role

dangers of modifying the sql server public role

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Introduction … Read more

Role-based Access Control In SQL Server, and You

role-based access control

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Role-Based … Read more

How to Troubleshoot SQL Server With PowerShell.

PowerShell is an essential tool for SQL Server database administrators looking to streamline their workflow and automate repetitive tasks. When it comes to troubleshooting your SQL Server instances, PowerShell is an essential tool for the DBA toolbox. As a versatile scripting language and command-line shell, PowerShell enables seamless integration of commands, arguments, variables, and modules … Read more

How to Optimize SQL Server Performance by Separating Workloads

How to Optimize SQL Server Performance by Separating Workloads

I wrote this to share a series of scripts that help identify if workloads are appropriately separated on the SQL Server host. The main reason we look for this is to avoid I/O contention and waits, which is a challenge that can significantly impact performance. If you are unsure if your server is experiencing I/O … Read more

Audit Your Database Backup Chain!

how to audit sql server database backup chains

All database administrators know that safeguarding data is paramount and having a strong restore strategy is crucial. In this post, I would like to add another tool to your arsenal that I have found helpful in auditing server health and configurations as it pertains to backups and the backup chain. A backup chain is important … Read more

Is Your SQL Server Ready for a Compliance Audit?

Compliance audits ensure that organizations adhere to regulatory guidelines, industry standards, and internal policies. As SQL Server DBAs, you can be prepared for most audits if you already check all of the boxes outlined in this blog post. Each of these points could be its own blog posts, so take your time as you go … Read more

Essential Database Maintenance Tasks Every DBA Should Know

sql server maintenance tasks every dba sould know

Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. In this blog post, we will explore key tasks and areas of focus for SQL Server DBAs, accompanied by practical tips and insights gained from our experience. From backup and recovery to performance optimization and security, let’s … Read more