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…
Adding SQL Server Access When You’re Locked Out
As consultants we are sometimes asked the following question: “We have an old version of SQL that we can’t turn off and no one has access to it. Is there…
Maximizing SQL Server ROI in M&A
The Hidden Goldmine: SQL Server Due Diligence in Acquisitions Whenever I’m chatting with folks in the investment world, especially those eyeing product or “… as a service” companies that use…
Essential Database Maintenance Tasks Every DBA Should 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…
Make SQL Server Database Restores Easy With sp_DatabaseRestore
If you’ve read the Straight Path blog for any period of time, you’ve probably noticed more than a few posts about database backups. You may have also noticed we’re big…
How to Setup a Standalone SSRS Server As Part of an Availability Group
SQL Server Reporting Services (SSRS) is a useful tool that can be installed on a standalone server (a license is required), or it can be installed on an existing SQL…
The Curious Case of THREADPOOL Waits
Featured image photo by alexey turenkov on Unsplash A client reached out for help with a performance problem that had been going on for over a day. The application was…
How UNsafe Is Your SQL Server? – Vulnerability Assessment and Access Audit
SQL Server is a repository of critical data, attracting potential threats from malicious individuals seeking financial gains. As a SQL Server DBA, it is essential to assess the security vulnerabilities…
How to Enable Transparent Data Encryption for Databases in Your Availability Group
Transparent data encryption is the built-in method for at-rest data encryption in SQL Server. Taking steps towards security has always been important, but it is becoming even more important every…
How to Provision a Low-Cost SQL 2022 Testing Lab
This month we will be covering some features in SQL 2022. Specifically, I will create a new SQL 2022 Development instance and connect it to Azure Arc. Azure Arc is…
2 thoughts on “SQL Server Blog”