Welcome to TechNet Blogs Sign in | Join | Help

May 2008 - Posts

Séminaire d'une journée sur le DATA-MINING

L'exploration de données est un thème porteur et plein d'avenir. Voici une série de 4 webcasts (en anglais) sur ces principes et son utilisation. http://www.microsoft.com/emea/spotlight/event.aspx?id=99 Read More...
Posted Friday, May 30, 2008 1:05 PM by patricg | 0 Comments

Livre BLANC HP sur SQL Server 2008...

Après le très bon Optimizing HP Servers with Microsoft SQL Server 2008 voici un nouveau livre blanc HP sur SQL Server 2008. Ce CFT (Customer Focused Testing ) couvre les résultats de tests faits par HP sur 3 nouvelles fonctionnalités Read More...
Posted Friday, May 30, 2008 12:45 PM by patricg | 0 Comments

SQL code layout and beautification

There is a good article on this here : http://www.simple-talk.com/sql/t-sql-programming/sql-code-layout-and-beautification/ The problem : Badly-formatted SQL is the bane of my life. That is because my life is spent staring at SQL Code. Other peoples SQL Read More...
Posted Friday, May 30, 2008 11:33 AM by patricg | 0 Comments

DATABASE SNAPSHOTS

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database that gives you a consistent view of a database as of a certain point in time. You can use the snapshot for operations supported Read More...
Posted Thursday, May 29, 2008 6:57 PM by patricg | 0 Comments

How to remove duplicate rows from a table in SQL Server

Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as "key" or "PK" in this article, but this will always denote "primary key." Read More...
Posted Monday, May 26, 2008 12:38 PM by patricg | 0 Comments

La documentation de SSDS (SQL Server data Services) est en ligne ...

C'est ici : http://msdn.microsoft.com/en-us/library/cc512417.aspx     Read More...
Posted Thursday, May 22, 2008 5:02 PM by patricg | 0 Comments

Est-ce que la recherche en texte intégrale est installée ?

Avec SQL Server 2008, la recherche en texte intégrale (Full text search) est complètement intégrée dans le moteur SQL Server et donc il n'y a plus de services séparé au niveau windows. Pour vérifier que ce composant Read More...
Posted Thursday, May 15, 2008 4:41 PM by patricg | 0 Comments

SQL Server 2005 SP3...

Il y aura bien un SP3 pour SQL Server 2005. Il sortira dans le courant de l'année calendaire 2008. Il suivra la sortie de SQL Server 2008. L'annonce a été faite ici : http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx Read More...
Posted Wednesday, May 14, 2008 10:27 AM by patricg | 0 Comments

Le Blog du décisionnel en francais...

Plutôt orienté utilisateurs fonctionnels, c'est ici : http://blogs.msdn.com/blog_bi   Read More...
Posted Tuesday, May 13, 2008 3:44 PM by patricg | 0 Comments

SQL Server PerfMon counters for access methods and buffer manager

A serie of 4 screencasts by Kevin Kline, where he goes through significant Perfmon counters for tracking Windows and SQL Server activity. Part 1: SQL Server PerfMon counters for tracking Windows memory Part 2: SQL Server PerfMon counters for Windows operating Read More...
Posted Tuesday, May 13, 2008 10:13 AM by patricg | 0 Comments

SQL Server Management Studio Reports and Dashboard

SQL Server 2005 and SQL Server 2008 provide graphical reports for monitoring system health and performance. While there have always been various queries, stored procedures, and of late, Dynamic Management Views, to gather system statistics, none were Read More...
Posted Tuesday, May 13, 2008 8:57 AM by patricg | 0 Comments
 
Page view tracker