SQLUG.BE Resource Page : Tools

BIDS Helper Updated

Frederik — Tue, 03 Jun 2008 15:52:00 GMT

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

Integration Services

General

Enable/Disable features

SSMS Tools Pack

Frederik — Tue, 03 Jun 2008 15:51:00 GMT

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:

SQL Server 2005 Best Practices Analyzer Update

Steve — Thu, 31 Jan 2008 21:54:00 GMT

An update for SQL Server 2005 Best Practices Analyzer is available which comes with new rules as of January 2008.
Read more

Analysis Services tools for generating documentation and checking best practises

Frederik — Sun, 02 Sep 2007 19:18:00 GMT

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 of all your dimensions, attributes, hierarchies, levels, cubes, measure groups, meausres, translations,..., it also contains other information such as creation data, last process date, ...

The second tool, Analysis Services Best Practise Analyser, checks your live cubes and dimensions against some best practises. Currently, it checks against 3 best practises: create aggregations for each partition, use attribute relationships, and use the non-empty behavior property on calculated members. Extra checks are in the pipeline and will be added soon.

Currently, these tools are freely available from http://www.u2u.be/res/SQL05_BI.aspx#Tools

SQL Internals Viewer

Frederik — Wed, 25 Jul 2007 21:22:00 GMT

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 designed to make database internals more accessible.

The Quick Start section gives a guide on how to use SQL Internals Viewer.

The Resources section lists articles and books with information on SQL Server internals.

http://www.sqlinternalsviewer.com/

Updating BLOBs

Steve — Tue, 17 Jul 2007 22:26:00 GMT

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 just be what you're looking for.

SQLAnswersQuery

Frederik — Fri, 22 Jun 2007 08:20:00 GMT

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 - add-in to SQL Server Management Studio

Frederik — Wed, 09 May 2007 13:23:00 GMT

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. The sources contain also setup project for building the full-fledged setup file. Because the project is a plugin, the full built distributive is shipped instead of demo-project. It is prepared for the use. Just install it and you can see a new context menu item "Script Data" inside SSMS on each table.

http://www.codeproject.com/useritems/enisey.asp

BIDS Helper

Frederik — Mon, 07 May 2007 15:47:00 GMT

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

Frederik — Thu, 05 Apr 2007 12:22:00 GMT

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 server.
http://www.datamanipulation.net/SQLQueryStress/

Online Search for BOL

Frederik — Mon, 02 Apr 2007 14:42:00 GMT

Search the SQL Server Books Online via Windows Live Search. http://search.live.com/macros/sql_server_user_education/booksonline

SQL Server 2005 Performance Dashboard Reports

Frederik — Wed, 21 Mar 2007 11:14:00 GMT

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.

Script SQL Database DDL

Frederik — Thu, 08 Mar 2007 14:13:00 GMT

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-sql-db/

Blogs from the SQL Product Team

Frederik — Wed, 21 Feb 2007 19:28:00 GMT

Paul Randal has compiled a nice list of blogs maintained by various people from the SQL Server Product Team.

Script Repository: SQL Server

Frederik — Tue, 20 Feb 2007 20:02:00 GMT

A nice set of SQL Server related scripts for both SQL Server 2000 and 2005.

http://www.microsoft.com/technet/scriptcenter/scripts/sql