(Steve Joubert) Let’s say you’ve decided to build a smart client application. You’ve determined that it will run on Microsoft SQL Server and employ a data store solution that the client will use in disconnected mode. Your next step will be deciding how the two data storage mechanisms will interact w

(Arthur Fuller) By default, SQL Server locates all its files on the same drive as the server. In addition, it places the log file for each database on the same drive. All that disk access can cost you a significant amount of performance. When installing SQL Server, you can specify the default drive

Access to the right information, in the right format, at the right time is critical. This whitepaper explains how enterprises can achieve these goals by leveraging MIS Plain and Microsoft SQL Server Reporting Services in a best-of-breed software solution. (R)

(Teemu Keiski) Now that ASP.NET 2.0 is about to be released to manufacturing, we ASP.NET developers have very interesting times ahead of us. Along with the new Framework, we have a major set of new controls to use and to ease our development work. One of the new controls, also my favorite, is the Tr

(Hilary Cotter) As a SQL Server DBA, you frequently modify Data Transformation Services (DTS) packages, either to correct errors in logic, to extend DTS package functionality or to change the server, database or object name. But rather than debug DTS packages in production environments, you should d

(graz) The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what’s going on inside SQL Server. They can provide information on what’s currently happening inside the server as well as the objects it’s storing. They are designed to be used instead of system

(Gregory A. Larsen) Wouldn’t it be nice if you could change DTS package properties at runtime? If you could then you could have a generic package that processed different files, loaded different database tables and/or connected to different servers, plus a slew of other things. In this article, I wi

(Jeremy Kadlec) In the business world, everything is about being "better, faster and cheaper" than the competition — and SQL Server 2005 offers many new features to save energy, time and money. From programming to administrative capabilities, this version of SQL Server tops all others and it enhanc

(Sekhar Lanka) In this article I am going to talk about a cool new feature of SQL Server 2005 called "CLR Integration", its advantages and how to program database objects using managed code with a simple project in Visual Studio 2005 beta 2.

(Robert Beatty) SQL Server 2005 allows you to upgrade from SQL Server 7.0 Service Pack 4 and SQL Server 2000 Service Pack 3 and above. Direct upgrade from SQL Server 6.5 is not supported; you need to first upgrade from SQL Server 6.5 to SQL Server 7.0 Service Pack 4 and then use the SQL Server 2005