Performance Tuning Using Free Tools, Part 2

You can do essential performance tuning on your SQL Server databases using a FREE toolkit!

The Command Palette in Azure Data Studio

Tool Limits

Today Steve asks about the tools you use for your job and if they help or hurt your productivity.

Your Favorite IDE

SSMS is, well, it's what we mostly have from Microsoft. It's been around a long time, but it is getting regularly released. There are new versions about every quarter, and there are bug fixes and minor enhancements. Azure Data Studio appears to be where Microsoft would like most of us to move, but I, and […]

The Separation of Tools

SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.

Other IDEs

Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us database options with Visual Studio, VS Code, and Azure Data Studio. It does seem as though Microsoft would prefer more of us move to ADS, but I'm not sure I'm […]

Microsoft SQL Server Utilities and Tools

Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities

Using the Lightweight Tools

This week Steve is interested in whether the newer lightweight environments, like VS Code and Azure Data Studio, are capturing your interest.

Using All Your Tools

Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.

Leaving SQLCMD