Tool Nuggets
Here are the tools (free & commercial) found over the internet that will ease the burdens of the DBA life in one way or another.
More tools on my Delicious Bookmark – http://delicious.com/MarlonRibunal/tool
SQL Server Whitepapers:
http://www.sqlskills.com/whitepapers.asp
FREE SQL SERVER TOOLS: http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx
PROFILER FOR SQL SERVER EXPRESS 2005/2008 – http://sqlprofiler.googlepages.com/
-
SQL Server 2005 Best Practices Analyzer
Overview [from the website]
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer.
Download the Best Practice Analyzer Now!
You can find the Tutorial from Dave Pinal.
-
SQL Server Hosting Toolkit
The goal of the SQL Server Hosting Toolkit is to enable a great experience around SQL Server in shared hosting environments.
Learn more and get it { here }!
- Data Modeling Tool
DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.
It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.
DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.
A good Database Modeling Tool. Get it { here }!
- Toolkit For Oracle
TOra was originally written by Henrik Johnson, with enhancements and additions by the open source community, and is now solely developed as an Open Source project. Any references to trial licenses or purchasing licenses purely apply to windows binary builds w/ versions prior to 1.3.15. Newer builds than that are 100% GPL licensed and can be freely used for any purpose.
Learn and download { here } !
- OpenReports
OpenReports is a powerful, flexible, and easy to use web reporting solution that provides browser based, parameter driven, dynamic report generation and flexible report scheduling capabilities. Supports JasperReports, JFreeReport, JXLS, and Eclipse BIRT
Here’s the download { page }
- SQL To Java Code Generator
SQL2JAVA is a SIMPLE, PRAGMATIC and POWERFUL code GENERATOR. It maps any relational schema to a java API dedicated to access your database schema. It supports Oracle, SQLServer, PostgreSQL, MySQL, Sybase, HSQL, etc… 2 minutes to install/try.
- SQuirrel SQL Client
SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
- eXist
eXist is a native XML database featuring efficient, index-based XQuery processing, extensions for keyword search, XUpdate support, and tight integration with existing XML development tools.
- The OpenHMS Project
OpenHMS brands a collection of projects and many subprojects developed by Health Market Science. This is a robust collection of development libraries, APIs, and tools oriented around data manipulation and professional software development.
[searching…more to come!]