Summary – Repeated Login Failures in SQL Server At Straight Path, we regularly inherit SQL Server environments after someone else completes the initial install. Most of the time the server configuration just needs a tweak or two and everything is good to go. Other times, we encounter odd behavior that sends us down a research … Read more
Summary – Log File Filling up on the Availability Group Networking firewall changes made over the weekend resulted in the client’s three disaster recovery (DR) replicas to not be able to communicate with the three High Availability (HA) replicas in their SQL Server Always on Availability Group (AG). This resulted in log files growing out … Read more
Summary A client was running a Contained Availability Group in SQL Server 2022, but wasn’t using the AG Listener for their application connections. This negated most of the benefits the Contained AG was designed to provide. They also had some security misunderstandings and missteps, as this was built for them without any real knowledge transfer … Read more
Accelerated Database Recovery (ADR) was introduced in SQL Server 2019. Its main purpose is to allow for faster database recovery in the event of a crash or unexpected shutdown. Traditionally, the database engine handles crash recovery through a series of phases—analysis, redo, and undo—which can be inefficient and slow, especially when dealing with long-running transactions. … Read more
Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. Some folks will implement a SQL Server maintenance plan without fully digesting what they are doing, but we prefer you to do this with eyes wide open. In this post, we will explore key tasks and areas … Read more
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 Server host (this shares the existing license of SQL Server). This blog post covers how SSRS is installed on a standalone server and how to … Read more
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 day as there is a looming cyber threat industry hungry for easy high-profit data. We should also remember that not all threats are from the … Read more