Free database tools for sql server

Our free products line enables you to perform server administration, database development, user and security management, data viewing and editing and other common tasks using a single powerful free database program with an easy-to-use graphical interface. EMS SQL Manager Freeware allows you to work with servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database, create and execute SQL queries with a powerful SQL editor, handle multiple selected objects at a time and much more.

We provide a wide range of free database software to access and manage the most popular database systems. The site SQLManager. Suite for MS Visual Studio. NET that will allow you to save data in the most popular data formats. High performance tool for DB2 database administration and development.

It also improves coordination among a team of people because they are using a standard set of tools. It's much easier to communicate thoughts and ideas when everybody has the same information in the same form. Again, that's MUCH easier to do when the all the tools have a consistent look and feel. It's even more revealing to execute simple T-SQL statements against your database s and see how they change the result sets of various tools.

If you prefer a GUI for these operations then a set of commercial tools would be a better choice for you. It's my way to "pay it forward" to the SQL Server community.

I have learned from the published work of others over the years and now I would like to return the favor for newer SQL Server database professionals. SQLFacts is the name of the suite, but it's also the name of a tool.

The SQLFacts tool returns almost 50 result sets by itself. The result sets provide vast information about a single database. Some of the result sets are detailed lists of what exists. Some of the result sets contain a lot of analysis. There's a tiny utility application to export all the result sets to HTML pages, with a table of contents page, to serve as documentation for the database. The Browse tool and the References tool dig deep into specific tables and routines stored procedures, functions, views.

You can choose between maximum speed and using LIKE wildcards. You can optionally exclude code comments. The result set is the actual matching lines with line numbers. The MetricsHistory tool is a complete monitoring system.

It monitors many performance counters, wait stats, file stats, and settings. The tool keeps a history to analyze patterns and trends. It includes alerting for abnormal conditions. The MetricsNow tool is an on-demand form of the MetricsHistory tool. The Databases tool provides information about your databases, including size and usage details.

The information is provided at different levels database, filegroup, and file. The Sessions tool provides information about what's currently running, including CPU usage, RAM usage, tempdb usage, and transaction log usage.

The QueryHistory tool provides information about resource usage for ad hoc SQL statements and stored procedures. The IndexHistory tool provides information about indexes, including definitions, usage statistics, and potential redundancy. The IndexActivity tool provides information about indexes, including low-level performance statistics to analyze access patterns and potential issues. The IndexNeedsPlus tool provides information about which stored procedures contributed to the "missing" index suggestions, which is not otherwise available in versions prior to SQL Server Log in or register to rate.

Join the discussion and add your comment. Access tutorials, help documentation, hundreds of preloaded scripts, and thousands of downloadable scripts. Join our email list and receive the latest case studies, event updates, product news, and much more. Download Now.