public marks

PUBLIC MARKS from ms_michel with tag sqlserver

2009

Hey Microsoft Coders! Free Stuff (Training, Books, Magazines) to Sharpen your skills!

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

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

C# Utility to automatically do the conversion from SQL Server DB to SQLite DB

2007

SQLDBDiff

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

SQL 2005 Service Manager

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

(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 Effects Clarity - a New Way to Diff!

by 1 other (via)
Quickly and visually verify database consistency and identify SQL object inconsistencies

2005

Universal Database Admin for ASP.NET and SQL Server - The Code Project - ASP.NET

A dynamic web application needs an admin section for CRUD action of the database, wouldn't it be nice if we can have a universal database administration, which can be plugged to any web application, Just give your sql connection string and it generates pages for Create, Read, Update and Delete -

DateTime

Date and time data from January 1, 1753 through December 31, 9999 :(

http://www.codeproject.com/aspnet/SQLRSViewer.asp

A report viewer ASPX page for SQL Reporting Services that uses exclusively its SOAP API.

ms_michel's TAGS related to tag sqlserver

.net +   ado.net +   c# +   database +   information-schema +   mvc +   mysql +   oledb +   oracle +   report +   sqlite +   utils +