Microsoft’s Best Practices Analyzer (BPA) for SQL is a real time-saver for IT admins and even DBAs. The tool scans your system, reporting back all configuration settings, complete with very ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL.

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

My toolbox typically includes the tools that Microsoft ships to manage SQL Server, like SQL Server Management Studio and Azure Data Studio, Windows Performance Monitor (perfmon) and a selection of ...

In-Depth Tooling Around in Your Database These products can help make your occasional forays into the world of databases much easier to take. By Peter Varhol August 1, 2008 Sometimes you don't need a ...

2 Real-time Analysis SQL Server monitoring tools often provide real-time analysis capabilities. This feature allows you to observe immediate effects on system performance as the tool operates.

Remote Server Administration Tools (RSAT) for Windows 7 has been made available for download from the Microsoft Download Center in 32-bit (215.1MB) and 64-bit (222.1MB) flavors.

Certainly you can do all those things in the SQL Server administration tools, writing your own SQL at the command line. Unless you're a SQL expert, though, that process can be lengthy and error-prone.