In this tutorial you will see how you can add, use and delete alias data types in Microsoft SQL Server 2005 using T-SQL. http://www.tutorial5.com/content/view/126/145/
A collection of 16 FAQs on creating and managing databases on SQL Server 2005. http://dba.fyicenter.com/faq/sql_server/Creating_and_Managing_Database...
This tutorial describes the different types of Data Flow components and show you how to create your first transformation component using script. http://www.codebeach.com/tutorials/sql-server-integration-services-you...
The core concept in Service Broker is the conversation. Conversations introduce a new messaging paradigm. http://www.codebeach.com/tutorials/sql-server-service-broker-conversat...
Install an enterprise portal solution in under an hour using freely available software solutions such as Tomcat, Microsoft SQL Server 2000, Java. http://www.compuworx.com/eLearning/portal/vapsql1.html
This guide will show you how to install the Microsoft SQL Server Desktop Engine 2000A for your localhost server. http://www.geekpedia.com/tutorial57_Setting-up-MS-SQL-Server-2000.html
This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval. http://www.codebeach.com/tutorials/murach-search-date-time-microsoft-s...
Using SQL Server 2000 and above versions you can retrieve data from SQL Server in XML format directly from the database. http://blog.codebeach.com/2008/02/how-to-use-sqlxml-to-retrieve-data-f...
SQL Server 2005 Express is much improved over its MSDE predecessor in that visual tools are provided along with the database engine. http://www.codebeach.com/tutorials/sql-server-2005-express-tools.asp