(Jayaram Krishnaswamy) In this article, we will simulate migrating a relatively small but established business from Microsoft Access 2000 to SQL Server 2000. There are a variety of reasons a business might wish to perform such a migration. Legacy queries, forms, and reports will be taken into consid

(William Pearson) In this lesson, we revisit Named Sets, a subject that we undertook in my article MDX in Analysis Services: Named Sets in MDX: An Introduction, in March of 2004. There, we introduced Named Sets from the perspective of the MDX query language, having obtained brief exposure to the con

(Siddhartha Batra) Connecting to atabases on the SQL Server is an elementary task often repeated needlessly by developers. The SQLServerClient is an assembly which provides a very easy to use and organized mechanism to access databases on the SQL Server. It comes with a demo windows forms applicatio

(Lauren Walker) In 2006, Microsoft will ramp up its redesigned certifications program, publishing curricula and offering the first exams for the new SQL Server 2005-based credentials and rolling out new certifications. That’s all in conjunction with its anticipated major product releases for Windows

(Robert Walters) This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.

(Geert Vanhove) This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I’ll also give you some tips on how to use them in a not so obvious context.

(Hilary Cotter) Not surprisingly, many e-commerce sites experience periods of high activity at the holidays. For instance, 1-800-Flowers.com Inc. (1-800-flowers.com) experiences bursts of ordering activity around Valentine’s Day, Mother’s Day, Christmas, Easter, Thanksgiving, Secretary’s Day and Tea

(Marcin Policht) In the previous installment of our series, we discussed various approaches to debugging Control Flow components of SQL Server 2005 Integration Services. While this satisfied our primary goal of facilitating real-time monitoring and troubleshooting of the package workflow, it is impo

(Roger Wolter) This paper describes user instances in SQL Server 2005 Express Edition and how you can use them to simplify adding database functionality to your Visual Studio projects.

(Greg Robidoux) When most people think of disaster recovery, their initial thoughts are about recovering from a complete disaster like Hurricane Katrina. In reality, this type of disaster is rare and often hits specific areas prone to earthquakes, hurricanes, tornadoes and other types of natural phe