Data Protection for SQL Servers: MS-SQL is used to power some of your most critical information applications. Complete protection of MS-SQL requires a high-availability solution as well as a disaster recovery plan. View this white paper to understand data protection strategies using Double-Take

(Jayaram Krishnaswamy) File Transfer Protocol (FTP) is a custom task in SQL 2000 Server’s Data Transformation Services. The files from an internet site can be transferred to a directory, or files can be transferred from one directory to another directory. This, in conjunction with the other DTS

(Klaus Aschenbrenner) People receive many notifications daily: weather updates, news updates, updates about stock prices, or a current account balance via a SMS message. But how can you build such notification applications on the Microsoft platform? You have two options: the first and less palatable

The easiest way to write managed code for SQL Server 2005 is to use Visual Studio 2005. As of the writing of this article, the full Beta 2 of Visual Studio is available; it works well with the SQL Server 2005 April(2005) CTP. To write managed code for SQL Server, you must have at least the Team Serv

This article describes late-breaking changes in Microsoft SQL Server 2005 Community Technical Preview (CTP) 15. These changes are not documented in the Readme file.

(Serdar Yegulalp) One of the earliest books on software for personal computers was named Nailing Jelly to a Tree. “Software is nebulous, and sometimes hard to get a grasp on,” the authors wrote in the introduction. This is still true today: When people talk about software as a solution to a given pr

(Marcin Policht) In the previous article of this series dedicated to the SQL Server 2005 Integration Services (SSIS), we started exploring features, which provide the ability to reuse packages (without modifying their design) in situations where some of their parameters need to be changed (frequentl

You receive incorrect results when you run a query that uses a cross join operator in Microsoft SQL Server 2000 Service Pack 3 (SP3). This problem may also occur if the SQL Server query optimizer generates an incorrect plan. If the SQL Server query optimizer generates an incorrect plan, you may r

Seventeen new webcasts are Scheduled for July, covering such topics as Database Tuning Advisor, Advanced MDX Scripting, Applying SQL Server 2005 Data Mining to Enterprise Business Problems and more.

(Arthur Fuller) Even though you’re probably familiar with the basic data structures such as stack, queue, and linked list, you may not have implemented these structures in SQL Server. Before I show you how to implement a stack, I’ll discuss why you may want to implement one.