-
Some usefull extra tools/utilities/providers ...the Feature Pack for Sql Server 2008, for the october 2008 version: click here and Enjoy!
-
A Visual Studio.Net add-ins with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio. (BIDS) Features Analysis Services Aggregation Manager Calculation Helpers Column Usage Reports Delete Unused Aggregations Deploy Aggregation Designs Deploy MDX Script Dimension...
-
SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express . It contains a few upgrades to the IDE that I thought were missing from the Management Studio: Uppercase/Lowercase keywords. Run one script on multiple databases. Copy...
-
An update for SQL Server 2005 Best Practices Analyzer is available which comes with new rules as of January 2008. Read more
-
The first tool, Analysis Services Documenter, generates HTML documentation out of a Live Analysis Services database: you just point to your database, select a few options (level of detail, interactivity), hit the button and the HTML is generated. The documentation does not only contain the name and description...
-
SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored. All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it works. This tool has been...
-
Ever tried to update content over 64K in a ntext field in Query Analyzer? It won't work as pasting text into Query Analyzer is limited to 64K. So there you are then! As far as I know only the use of ADO might be of any help. But if you're after a quick and neat solution, have a look QALite . It might...
-
SqlAnswersQuery can generate quick reports in PDF, Word and HTML formats straight from SQL in seconds! http://www.sqlanswers.com/Software/SAQ/Default.aspx
-
Enisey" is data scripter add-in to Microsoft SQL Server Management Studio (SSMS). One expands the functionality of SSMS and allows to script data from any tables into a choosen ".sql" file in the view of INSERT statements. It is one .NET 2.0 assembly, registered as COM-object and registered as SSMS addin...
-
A set of VS.Net add-ins that extend and enhance the functionality of the SQL Server BI Development Studio. http://www.codeplex.com/bidshelper
-
SQLQueryStress is a free tool for SQL Server programmers. It is designed to assist with performance stress testing of T-SQL queries and routines. The tool automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your...
-
Search the SQL Server Books Online via Windows Live Search. http://search.live.com/macros/sql_server_user_education/booksonline
-
The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later. Download here.
-
An opensource tool which scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"]. These files can then be placed under proper source management control. http://sourceforge.net/projects/script...
-
Paul Randal has compiled a nice list of b logs maintained by various people from the SQL Server Product Team .