Determining what T-SQL query or SQL Server client application is the source of log file growth is an often asked question. “Old” SQL DBAs would sometimes refer you to KB 317375 which unfortunately is no longer hosted as a Microsoft KB Article, but sadly infinitely loops on one new Docs […]
All SQL Server DBAS are familiar with sp_configure to change the instance global settings. However when you need to modify temporarily those settings from within your code, such as storing sp_configure settings in a stored procedure, the process can become awkward You need to store the configuration setting you change […]
Today’s post is about answering a simple question I had to document a SQL Server instance. Is your database part of an Availability group? Or is it purely local to your instance? Microsoft has of course put some Dynamic Management Views (DMV) into SQL Server to list the databases in […]
