Sponsorised links
This year
Hey Microsoft Coders! Free Stuff (Training, Books, Magazines) to Sharpen your skills!
by ms_michel
Tous un tas de trucs d'origine Microsoft pour se former à Visual Studio et Sql Server, dont un atelier de 3h sur ASP.NET MVC
Instead of triggers
by ms_michel
Un argument en faveur des procédures stockées plutôt que des triggers : le trigger s'exécute automatiquement => on oublie qu'il existe, ce qui n'est pas la cas de la procédure stockée puisqu'on l'appelle explicitement
Sponsorised links
2008
Convert SQL Server DB to SQLite DB
by ms_michel
C# Utility to automatically do the conversion from SQL Server DB to SQLite DB
ELASTRA - The Infinite Database
by springnet
ELASTRA is the world's first infinitely scalable solution for running standard relational databases in an on-demand computing cloud. ELASTRA's exclusive, high-performance S3DFS storage technologies enable a standard RDBMS to be deployed on Amazon's Elasti
2007
SQL 2005 Service Manager
by ms_michel
With the lack of an equivalent in SQL2005 for the SQL Server Service Manager that comes with SQL2000, I've decided to write one myself. It's behaviour should be familiar to you if you've used SQL2000
2006
Data Dictionary Creator
by ms_michel
(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.
Simon's Software Stuff: SQL Server performance tips
by springnet
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster
SQL Server Database Performance Tuning And Other Articles
by springnet
& 2 others
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run fast
SQL Effects Clarity - a New Way to Diff!
by ms_michel
& 1 other
(via)
Quickly and visually verify database consistency and identify SQL object inconsistencies
