Au revoir…

Voilà un message que l’on pense ne jamais écrire mais tout a une fin ! Il se trouve qu’après avoir activement participé aux lancements de SQL Server 2005, SQL Server 2008 et SQL Server 2008 R2 et avoir alimenté ce blog (et d’autres) depuis près de 5 ans, je vais quitter Microsoft dans les prochains…

2

T-SQL : Intersect, Except, Union, All and Any

A good article on some SQL basics : I was reviewing the Microsoft training courses for SQL2008 for a set of application developers who wanted to learn more about SQL Server. In doing so I came across some commands that I either had not heard of or had not used before. INTERSECT EXCEPT ALL ANY…

0

Une série de tutoriels en français sur l’optimisation SQL Server

C’est sur : http://sqlserver.developpez.com/    Tutoriel : Indexer… oui mais quoi ? Exemple avec SQL Server, par Frédéric Brouard Tutoriel : Optimisation des bases de données MS SQL Server : l’exploitation, par Frédéric Brouard Tutoriel : Optimisation des bases de données MS SQL Server : les requêtes, par Frédéric Brouard Tutoriel : Optimisation des bases…

0

Tout savoir sur SQL Server 2005 ExprEss edition !

You can read the 46 articles from Marcin Policht ! Part 46 – Basic Server Reporting Functionality in SQL Server 2005 Express Edition Part 45 – Initial Configuration of Reporting Services on SQL Server 2005 Express Edition Part 44 – Installing Reporting Services on SQL Server 2005 Express Edition Service Broker Poison Message Handling Part…

0

Peer-to-Peer Replication in SQL Server 2008 – Add a node and resolve conflict…

In the first article of this series(Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology), we configured a two-node Peer-to-Peer replication topology. In this article, we will add a third node to the topology and demonstrate how to resolve an update-update conflict. In SQL Server 2005, if you need to change an existing…

0

How-to : Collecting performance counters and using SQL Server to analyze the data…

Problem Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times. I find it handy to push the performance monitor counters into SQL Server where I can query it or perhaps display…

0

Procédure : Nettoyage des mails sauvegardés dans MSDB…

There are two system stored procedures you can take advantage of in order to clean up Database Mail messages, attachments and log entries stored in the msdb database.   These two system stored procedures are sysmail_delete_mailitems_sp and sysmail_delete_log_sp. The full article is here : http://www.mssqltips.com/tip.asp?tip=1732

0

Using Web Service and XML Tasks in SQL Server 2008 Integration Services…

Cet article décrit en mode pas à pas la méthode pour implémenter la récupération de données XML via un Web Services en utilisant SSIS. Le résultat donne ceci : L’article est accessible ici : http://www.sql-server-performance.com/articles/biz/webservce_xml_tasks_ssis_p1.aspx 

0

SqlCredit – Developing a Complete SQL Server OLTP Database Project

C’est une longue suite d’articles parus dans le Database Journal  . The purpose of the SqlCredit series is to demonstrate the database design and development portion of a development project. We will build a complete, functioning, tested credit card database to illustrate the complete software development lifecycle. Microsoft provides us with AdventureWorks, but all we…

0