Articles en ligne sur SQL Server...

C'est dans la précédente édition du "Technet magazine "

SQL ServerReduce Downtime: Implement SQL Server 2000 On A Cluster

Running SQL Server 2000 on a Windows Server 2003 Server failover cluster will get you more uptime by alleviating your reliance on a single server.

Stephen StrongXML To The Max: Get More Power Out Of Your SQL Server

Using the SQL Server 2000 T-SQL syntax, you can manipulate XML in a variety of ways. For example, you can access data contained in an XML string passed into a stored procedure and produce XML output. Find out what these flexible, powerful XML features can do for you.

Ward PondGet A Traffic Report: Analyze Your Database Usage With System Tables

By querying data from the master.sysprocesses table you can get almost any information you need about connections to your SQL database, what each process is doing, which processes are blocking, and lots more. Then you can use this data to create some truly enlightening reports.

Matt Evans and Josh MoodyAsync Lifestyle: Manage Your Tasks With Service Broker

SQL Server 2005 Service Broker is more than just a developer tool. DBAs can use it to schedule tasks, run batch processing, and perform routine database maintenance.

Roger WolterOn The Horizon: Improved Data Security In SQL Server 2005

Microsoft has performed extensive threat modeling and security analysis to identify the threats facing database servers. This work has resulted in an upcoming version of SQL Server, SQL Server 2005, that is secure by design. This article enumerates the various security improvements to the popular database.

Don Kiely