In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and ...

This sqlserver_mgmt module builds on top of the puppetlabs/sqlserver module to provide the infrastructure as code needed to iterate over configuration in Hiera so you can easily manage resources on ...

This part covers the SQL Server installation and configuration for a SCCM 2012 R2 environment. SQL server will be installed on a dedicated server. (If SQL server is installed on the same server as the ...

This extension is currently in beta (pre-v1.0), and may see breaking changes until the first stable release (v1.0). This Gemini CLI extension provides a set of tools to interact with Cloud SQL for SQL ...

For fixing Windows errors, we recommend Fortect: Fortect will identify and deploy the correct fix for your Windows errors. Follow the 3 easy steps to get rid of Windows errors: Windows Firewall’s ...

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how ...

There are a variety of commercial security tools 1 available to audit Microsoft (MS) SQL Server databases. However, there can be instances when their application is not practical, including: For ...

You may encounter the SQL Server Error 18456 if the server could not authenticate the connection and this can be caused by the non-availability of the administrator ...