public marks

PUBLIC MARKS with tag sqlserver

2010

2009

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

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

SQLDBDiff

by ms_michel
Outil visuel pour comparer la structure (et les données en version Shareware) des bases de données SQL Server.

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

Active users

krachot
last mark : 02/06/2010 15:33

ms_michel
last mark : 30/07/2009 11:10

jey
last mark : 02/05/2009 10:59

springnet
last mark : 06/03/2008 17:30

baby002
last mark : 22/10/2006 21:49

fakechris
last mark : 14/10/2006 00:50

hoabui
last mark : 24/09/2006 16:37

zedix
last mark : 10/02/2006 08:14