I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

Here is a script that looks at the created index and the missing index details, making a overview of usage stats, columns, index type etc. use Index_analysis.sql for the analasys This script can use ...

AND P.CODAUXILIAR NOT LIKE '746%' AND P.CODAUXILIAR NOT LIKE '489%' AND P.CODAUXILIAR NOT LIKE '270%' AND P.CODAUXILIAR NOT LIKE '570%' AND P.CODAUXILIAR NOT LIKE ...