According to Windows Server Division WebLog the Service Pack 2 for Windows 2003 will improve SQL Server 2005 performance by introducing some changes in Winsock API. However you won’t notice the change unless you have a server with 8 or more CPUs and multiple NICs.   http://blogs.technet.com/windowsserver/archive/2006/08/01/444365.aspx

http://www.theserverside.net/news/thread.tss?thread_id=27876 Developmentor and TheServerSide.NET have teamed together to provide you with the entire book ''Essential XML Quick Reference'', by Aaron Skonnard and Martin Gudgin, . The book offers quick-reference access to the XML Schema, XML, XSLT, XPath and more.

Programming the .NET Compact Framework in C# Programming the .NET Compact Framework in Visual Basic .NET http://www.paulyao.com/cfbook/index.asp

If you loveChannel 9 you would like PS-TV. For BI guys check this: http://blogs.msdn.com/ptstv/archive/category/13832.aspx

It's ShowTime site has new SQL Server videos:http://www.microsoft.com/emea/itsshowtime/sqlserver.aspx Indexing Creation with SQL Server 2005 Kimberly L. Tripp Indexing De-fragmentation with SQL Server 2005 Kimberly L. Tripp Upgrading the Database Engine / New features in SQL Server ...

If you try to code a DDL managed trigger there is a small chance to have problems with the parameters of SqlTrigger attribute: Name, Target and Event.Here’s an example that works :Imports SystemImports System.DataImports System.Data.SqlClientImports System.Data.SqlTypesImports Microsoft.SqlServer.ServerPartial Public Class ...

Almost everything around us is temporary starting with your job and ending with your beer supply. You may argue that a job may last for a life time but even life is temporary. In SQL Server temporary means tempdb, a database where all ephemeral things happen. As you may know by now, SQL Server 2005 uses tempdb more than its predecessors, a lot ...

Sometimes computers fail due to hardware or software. This time your database server is not responding. If it’s SQL Server 2005 you still have an alternative to restarting your production server – Dedicated Administrator Connection. This article will give you an idea on what is DAC, how to use it and when to use it.   What is DAC ? At a ...

In 1993 the alternative rock group, 4 Non Blondes, were climbing the charts all over the world screaming at the top of their lungs “What’s going on?”. Almost 12 years later, the SQL Server team came with the answer – the Dynamic Management Views and Functions. If you care what’s going on with your server, read on and I’ll try in 10 minutes of your ...