(Jeffrey Juday) SQL Server developers and administrators are no strangers to Data Transformation Services (DTS) packages. They likely develop DTS packages to perform everything from simple database operations to data aggregation. As such, when they upgrade some or all of their servers to SQL Server

When you cancel a remote query that returns many data rows in Microsoft SQL Server 2000, a memory leak may occur. The size of the memory leak depends on the size and the type of data that is being retrieved from the remote server. You may receive an error message that is similar to one of the follow

(Greg Robidoux) If you’re new to SQL Server and not sure how to set up backups, Maintenance Plans may be the way to go. Although not all of the backup functionality is available using Maintenance Plans, Microsoft has developed an easy interface to set up backups for all of your databases. (R)

(Arthur Fuller) Benchmark testing can be a waste of time if you don’t have a realistic data set. Arthur Fuller exhibits how you can set up your test to accommodate for more than one million rows, thus returning more accurate test results.

When you run a query against Microsoft SQL Server 2000 Analysis Services build 8.00.0909 or a later build, you may experience a decrease in query performance. The problem occurs when the following conditions are true: • The query uses a virtual dimension or a changing dimension. • You run the

(Christian Forsberg) This article is about migrating Pocket PC applications that are written in eMbedded Visual Basic to the .NET Compact Framework. The migration includes a change from using ADO CE for accessing data in a Pocket Access database to using ADO.NET for accessing data in SQL Server CE.

(Joel Scambray and Stuart McClure) Hacking into Web servers and replacing home pages with pictures of scantily clad females and clever, self-ingratiating quips is all fine and dandy, but what can we do about hackers intent on doing more than defacing a few pages? Sooner or later you’ll be up aga

(William Pearson) In this article, we will examine the TopCount() function, whose highest value lies in its capability to enable us to isolate best performers from among hundreds or thousands of fellow members. This ranking capability is critical in data analysis and decision support scenarios: In m

(Margie Semilof) Microsoft released a second service pack for its SQL Server Reporting Services, which includes new features in addition to the normal bug fixes for a service pack. (R)

When you run a distributed transaction against a linked server in Microsoft SQL Server 2000 on a computer that is running Microsoft Windows Server 2003, Enterprise Edition, you may receive the following error message: Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be perf