SQL Server, BizTalk Server, le 64 bits et au-delà !...

Browse by Tags

All Tags » 1.1) Scripts SQL Server 2005 (RSS)

Storing Images and BLOB files in SQL Server...

This is a serie of 4 interesting articles discussing better ways to handle BLOB with SQL Server. Part 1 http://www.databasejournal.com/features/mssql/article.php/3719221 where definitions Read More...

Posted Monday, April 14, 2008 2:36 PM by patricg | 0 Comments

Filed under: _ English / Anglais, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, Architecture, Administration

Retours sur la session DAT211 - Interopérabilité avec oracle - aux TechDays 2008 @ Paris

En cliquant, vous accédez directement à l'enregistrement. Pour les scripts c'est en attachement de ce message. Read More...

Posted Wednesday, March 26, 2008 12:13 PM by patricg | 0 Comments

Filed under: Evènements / Events, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008, 1.3) Scripts SQL Server 2008, Webcats / edemos

Attachment(s): Scripts.zip

Retours sur La session DAT209 - Outils d'administration avancés pour SQL Server - aux TechDAYS 2008 @ Paris

En cliquant, vous accédez directement à l'enregistrement. Pour les scripts c'est en attachement de ce message. Read More...

Posted Wednesday, March 26, 2008 12:12 PM by patricg | 0 Comments

Filed under: Evènements / Events, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008, 1.3) Scripts SQL Server 2008, Webcats / edemos, Administration

Attachment(s): Scripts & URL.zip

Livres de référence sur SQL Server...

Voilà une question que l'on me pose souvent. Quels livres recommander sur SQL Server ? Il y a en beaucoup (Une recherche "sql server" donne 692 livres en anglais et 142 en français sur Amazon.fr ! ) Alors le choix est difficile et Read More...

Posted Wednesday, March 19, 2008 11:07 AM by patricg | 0 Comments

Filed under: _ English / Anglais, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, Sexy, Administration, Décisionnel

SQL Server 2D-MATRIX...

Pour les TechDays Pascal Belaud (que l'on ne présente plus :-) a développé un type de données .Net pour SQL Server 2005 : " The SQL Server 2-D Matrix ". Ce type permet de gérer des tableaux dynamiques tels que celui-ci Read More...

Posted Tuesday, February 19, 2008 10:01 AM by patricg | 0 Comments

Filed under: _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005

Comment charger un fichier .csv dans SQL Server ?

Vous trouverez ici un article très bien fait sur le sujet : http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html Avec qq subtilités liés au passage en localisation française Read More...

Posted Tuesday, January 29, 2008 5:32 PM by patricg | 0 Comments

Filed under: _ English / Anglais, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008, Administration

SQL Server and Powershell...

Two excellent articles giving samples on how to use SQL Server with PowerShell : Using PowerShell and SQL Server Together Create Agent Jobs to run PowerShell Scripts Here a part of it : #build_exibitors_view.ps1 #This script will recreate the 'exhibitors' Read More...

Posted Tuesday, January 29, 2008 11:02 AM by patricg | 0 Comments

Filed under: _ English / Anglais, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008, Administration

Precision Performance FOR MICROSOFT SQL SERVER...

http://blogs.msdn.com/psssql/archive/2007/12/18/rml-utilities-for-microsoft-sql-server-released.aspx The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities Read More...

Posted Friday, January 11, 2008 2:43 PM by patricg | 1 Comments

Filed under: _ English / Anglais, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, Administration

SQL SERVER TIPS n°5 : TempDB Best practices

In this tip we will talk about some of the best practises for configuring TempDB database and its placement: The size and physical placement of the tempdb database can affect the performance of a system. For example, if the size that is defined for tempdb Read More...

Posted Thursday, October 18, 2007 7:24 PM by patricg | 0 Comments

Filed under: _ English / Anglais, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005

Explication VISUELLE des Jointures SQL...

Si vous êtes un peu perdu entre les INNER, OUTER ou FULL Join, voici un message qui essaye de résumer visuellement l'ensemble : La suite ici : http://www.codinghorror.com/blog/archives/000976.html Attention a prendre toutefois avec précaution car l'exemple Read More...

Posted Tuesday, October 16, 2007 9:50 AM by patricg | 0 Comments

Filed under: _ English / Anglais, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008

SQL SERVER TIPS n°4 : Remote Execution using EXECUTE command

In previous versions of SQL Server (Prior to SQL Server 2005) you could execute EXECUTE command only on the local server. With SQL Server 2005 EXECUTE command now has AT parameter which can be used for executing the statement on a remote linked server. Read More...

Posted Tuesday, October 16, 2007 9:36 AM by patricg | 0 Comments

Filed under: _ English / Anglais, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008

SQL SERVER TIPS n°3 : How can I view I/O statistics on the physical database files in a database?

The system function fn_virtualfilestats , available in both SQL Server 2000 and SQL Server 2005, or sys.dm_io_virtual_file_stats (in SQL 2005 only) allows you to do exactly what you’re looking for. The function returns statistical information gathered Read More...

Posted Friday, October 05, 2007 4:08 PM by patricg | 0 Comments

Filed under: _ English / Anglais, _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005

Les nouveaux sEminaires Technet sont arrivEEs !

Vous voulez acquérir de nouvelles compétences sur les technologies Microsoft ? Connaître les nouvelles versions des outils ? Comme chaque année, Microsoft TechNet vous propose des séminaires gratuits à travers la France. Read More...

Posted Thursday, September 27, 2007 10:20 AM by patricg | 0 Comments

Filed under: Evènements / Events, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, 1.2) SQL Server 2008, Office 2007, Décisionnel

Un gadget Vista bien sympathique !

Pour arréter et redémarrer facilement vos services SQL Server sous Vista ! C'est ici : Merci Fabrice. Read More...

Posted Thursday, July 05, 2007 6:35 PM by patricg | 0 Comments

Filed under: _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005, Administration

SQL Server : Comment conserver des données lors d’une transaction annulée (ROLLBACK)

Vous trouverez un très bon article sur le sujet ici : http://blogs.codes-sources.com/christian/archive/2006/11/30/sql-server-comment-conserver-des-donn-es-lors-d-une-transaction-annul-e-rollback.aspx Read More...

Posted Friday, December 01, 2006 1:11 PM by patricg | 0 Comments

Filed under: _ Francais / French, 1) SQL Server 2005, 1.1) Scripts SQL Server 2005

SQL Server, BizTalk Server, le 64 bits et au-delà !...

Search

Tags

News

Archives

Biztalk

Blogs around the world...

L'Equipe IT Pro FR

Les sites Microsoft sur SQL Server 2000...

Les sites Microsoft sur SQL Server 2005...

Others English Sites on SQL Server

Others interesting sites

SQL Server 2000

SQL Server Blogs

Windows Compute Cluster