Public marks with tag sqlserver Public marks with tag sqlserver http://blogmarks.net/marks/tag/sqlserver Hey Microsoft Coders! Free Stuff (Training, Books, Magazines) to Sharpen your skills! http://blogs.msdn.com/angelab/archive/2009/07/29/hey-microsoft-coders-free-stuff-training-books-magazines-to-sharpen-your-skills.aspx 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 2009-07-30T11:10:31Z ms_michel .net, mvc, sqlserver

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

Copy | React (0)
]]> Instead of triggers http://blogs.msdn.com/cellfish/archive/2009/07/08/instead-of-triggers.aspx 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 2009-07-09T07:15:00Z ms_michel database, sqlserver

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

Copy | React (0)
]]> Ubitsoft - Ubitsoft SQL Enlight http://www.ubitsoft.com/products/sqlenlight/sqlenlight.php 2009-05-02T10:59:58Z jey T-SQL, database, CodeQuality, sourcecodeanalysis, transact-sql, sqlserver

Ubitsoft - Ubitsoft SQL Enlight

by jey

Copy | React (0)
]]> Convert SQL Server DB to SQLite DB http://www.codeproject.com/KB/database/convsqlservertosqlite.aspx C# Utility to automatically do the conversion from SQL Server DB to SQLite DB 2008-06-16T08:28:43Z ms_michel sqlite, sqlserver

Convert SQL Server DB to SQLite DB

by ms_michel

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

Copy | React (0)
]]> ELASTRA - The Infinite Database http://www.elastra.com/ 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 2008-03-06T17:30:56Z springnet sqlserver, mysql, future, filesystem, drupal, database, amazon, springnet blogmarks, *****, springnet, webdev

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

Copy | React (0)
]]> A Library For Executing SQL Scripts With GO Separators and Template Parameters http://haacked.com/archive/2007/11/04/a-library-for-executing-sql-scripts-with-go-separators-and.aspx 2007-11-05T09:30:41Z ms_michel sqlserver, .net

A Library For Executing SQL Scripts With GO Separators and Template Parameters

by ms_michel

Copy | React (0)
]]> SQLDBDiff http://www.sqldbtools.com/ Outil visuel pour comparer la structure (et les données en version Shareware) des bases de données SQL Server. 2007-06-08T08:41:20Z ms_michel sqlserver

SQLDBDiff

by ms_michel

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

Copy | React (0)
]]> TableDiff.exe - a cool SQL Server 2005 tool http://weblogs.sqlteam.com/mladenp/archive/2007/03/03/60125.aspx 2007-03-06T09:08:32Z ms_michel sqlserver

TableDiff.exe - a cool SQL Server 2005 tool

by ms_michel

Copy | React (0)
]]> SQL 2005 Service Manager http://www.sqldbatips.com/showarticle.asp?ID=46 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 2007-03-05T16:26:15Z ms_michel sqlserver

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

Copy | React (0)
]]> Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx 2007-01-16T07:32:12Z ms_michel sqlserver

Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition

by ms_michel

Copy | React (0)
]]> Data Dictionary Creator http://www.codeplex.com/datadictionary 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. 2006-11-15T09:04:31Z ms_michel database, sqlserver

Data Dictionary Creator

by ms_michel

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.

Copy | React (0)
]]> Facts About the Fill Factor (modify index fill factor) http://www.devx.com/getHelpOn/Article/10016/0/page/3 2006-10-22T21:49:52Z baby002 sql-server, sqlserver, fillfactor, fill-factor, index

Facts About the Fill Factor (modify index fill factor)

by baby002

Copy | React (0)
]]> Understanding SQL Server Full-Text Indexing http://www.developer.com/db/article.php/3446891 2006-10-22T05:52:40Z baby002 full-text-indexing, full-text, index, indexing, sqlserver, sql-server

Understanding SQL Server Full-Text Indexing

by baby002

Copy | React (0)
]]> SS64.com Command line reference for Windows, Bash, Oracle, and SQL Server http://www.ss64.com/ 2006-10-14T00:50:31Z fakechris linux, windows, sqlserver, oracle

SS64.com Command line reference for Windows, Bash, Oracle, and SQL Server

by fakechris & 6 other(s)

Copy | React (0)
]]> The Pipelines -- Information Portal for Oracle, DB2, SQL Server. http://www.quest-pipelines.com/ 2006-09-24T16:37:35Z hoabui oracle, db2, sqlserver, database

The Pipelines -- Information Portal for Oracle, DB2, SQL Server.

by hoabui

Copy | React (0)
]]> SQL Server Code,Tips and Tricks, Performance Tuning http://sqlservercode.blogspot.com/ 2006-08-31T04:30:18Z fakechris database, sqlserver, microsoft

SQL Server Code,Tips and Tricks, Performance Tuning

by fakechris

Copy | React (0)
]]> Upgrading MSDE to SQL Server 2005 Express http://blogs.msdn.com/ericnel/archive/2006/07/18/669437.aspx 2006-07-18T12:30:15Z ms_michel sqlserver

Upgrading MSDE to SQL Server 2005 Express

by ms_michel

Copy | React (0)
]]> Simon's Software Stuff: SQL Server performance tips http://www.harriyott.com/2006/01/sql-server-performance-tips.aspx 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 2006-07-12T12:20:51Z springnet sqlserver, performance, sql, springnetdelicious

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

Copy | React (0)
]]> SQL Server Database Performance Tuning And Other Articles http://www.sql-server-performance.com/ 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 2006-07-12T12:20:31Z springnet sqlserver, sql, springnetdelicious

SQL Server Database Performance Tuning And Other Articles

by springnet & 2 other(s)

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

Copy | React (0)
]]> Some of my favorite INFORMATION_SCHEMA utility queries http://weblogs.asp.net/jgalloway/archive/2006/07/07/455797.aspx 2006-07-07T07:38:27Z ms_michel information-schema, sqlserver

Some of my favorite INFORMATION_SCHEMA utility queries

by ms_michel

Copy | React (0)
]]> SQL Effects Clarity - a New Way to Diff! http://www.sqleffects.com/ Quickly and visually verify database consistency and identify SQL object inconsistencies 2006-05-04T12:43:19Z ms_michel database, sqlserver

SQL Effects Clarity - a New Way to Diff!

by ms_michel & 1 other(s)

Quickly and visually verify database consistency and identify SQL object inconsistencies

Copy | React (0)
]]> ToadSoft.com http://www.toadsoft.com/ 2006-03-02T02:08:52Z hoabui sqlserver, db2, oracle, mysql, tool, software, database

ToadSoft.com

by hoabui

Copy | React (0)
]]> How to fix SQL Network Interfaces, error: 26 http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx 2006-02-10T08:14:20Z zedix sqlserver

How to fix SQL Network Interfaces, error: 26

by zedix

Copy | React (0)
]]> SQL Function Reference: SQL Server vs. Oracle http://www.webucator.com/resources/sql/reference.html 2006-02-01T12:48:18Z ms_michel oracle, sqlserver

SQL Function Reference: SQL Server vs. Oracle

by ms_michel & 1 other(s)

Copy | React (0)
]]> SQL Function Reference: SQL Server vs. Oracle http://www.webucator.com/resources/sql/reference.html 2006-02-01T12:32:34Z oberkom oracle, sqlserver, funciones

SQL Function Reference: SQL Server vs. Oracle

by oberkom & 1 other(s)

Copy | React (0)
]]>