Sponsorised links
This year
SQL Anywhere
Breck Carter's blog about SQL Anywhere... yes, "SQL Anywhere" is an actual product, like MySQL, Oracle, SQL Server, ASE, only LOTS BETTER :)
Sponsorised links
2007
LINQPad
(via)Can't wait for C# 3.0 and LINQ? Well you don't have to! Dynamically query SQL databases today in LINQ: no more struggling with antiquated SQL. Download LINQPad and kiss goodbye to SQL Management Studio: LINQPad supports LINQ to objects, LINQ to SQL and LINQ to XML—in fact, everything in C# 3.0 and .NET Framework 3.5. LINQPad is also a terrific learning tool for experimenting with this exciting new technology.
Programming ADO.NET
SQL Server, MySQL, Postgresql ADO.NET programming
xSQL Tools Free for SQL Server Express
(via)If you're using the Express version, this suite of database comparison and synchronization tools is free too.
LiquiBase: Database Refactoring
by 1 otherLiquiBase is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.
dbpedia.org
by 8 others (via)dbpedia.org is a community effort to extract structured information from Wikipedia
and to make this information available on the Web. dbpedia allows you to ask
sophisticated queries against Wikipedia and to link other datasets on the Web
to Wikipedia data.
2006
Web SQL Utility
A simple ASP.NET application to run queries against your databases. Stores history and favourites.
Data Dictionary Creator
(via)Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.
Sql.NET - Dynamic SQL framework
Dynamic SQL framework eases dynamic SQL generation by providing a convinient Object Model for constructing database indpenedent SQL queries. Current version supports, complex queries, Paging and Cross Tabs (Pivot Tables)
Toad™ Data Modeler - Freeware database design tool
(via)With the FREEWARE version of Toad™ Data Modeler - database design tool, you can create complex entity-relationship diagrams (ERD) for more than twenty databases. You can visually draw new diagrams and generate SQL scripts based on the ER diagrams automatically.
Web SQL Utility
Simple ASP.NET application to run queries against your databases. Stores history, favourites.
SubSonic - The Zero Code DAL
Ruby On Rails is propelling a new wave of programming - one that drives "Convention Over Configuration". This simple, elegant approach is attracting many developers who find the intricacies and complexity of Java and .NET to be daunting.--- SubSonic is our attempt to bring this simplicity to the .NET platform.
System.Data.SQLite
by 2 othersSystem.Data.SQLite is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.
XDesigner Studio
XDesigner series Designer , include XDesignerLib , XReport, XDBDesigner, XHtmlDesigner... XDesignerLib is a kind of middle components to build professional Designer fastly .
Stored Procs vs Dynamic SQL
And the winer is ... Dynamic SQL
Tableau Software
Tableau is a visual analysis and reporting solution that allows people to explore and analyze databases and spreadsheets with simple drag and drop operations.
SQL Effects Clarity - a New Way to Diff!
by 1 other (via)Quickly and visually verify database consistency and identify SQL object inconsistencies
SQLite Foreign keys creator
by 1 other (via)Simule les contraintes d'intégrité avec les triggers sous SQLite
