SQL Server provides several methods to protect against data loss. Alexander Chigrik explains of the various methods.

By Marcin Policht – In the previous article, I explained the meaning of the “Allow posted updategrams” and “Allow template queries” options on the Settings tab of the Virtual Directory Properties dialog box in IIS Virtual Directory Management for SQL Server tool. I also presented examples of taking

By Michael Otey – Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.

SQLXML enables XML support for your SQL Server Database. It allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file.

Microsoft released two hotfixes for SQL Server. The first fix corrects a problem of slow connections to Analysis Services. The article “FIX: HTTP Connections to Analysis Services Server Computers Running Windows Server 2003 Are Slow” explains that HTTP connections to Analysis Services server compute

Written By: Jeremy Kadlec – Needless to say, backups are one of the most critical aspects of a SQL Server environment and a Database Administrators (DBA) last line of defense to resolve a critical problem. As a DBA, how many times have backups saved you? Even with numerous advancements with RAID and

(Peter Galli) Microsoft Corp. last week made available the release candidate for its Windows Small Business Server 2003, the latest product in the Windows Server 2003 family headed for release. The premium version will include technologies such as SQL Server 2000 and Microsoft’s Internet, Securit

(Timothy Dyck) eWEEK and sister publication PC Magazine early last year published results of a comparative performance test of database servers. It had been almost a decade since either publication had performed a similar test, so we expected significant interest in the story. The actual response

by Robbe Morris – If you want to script stored procedures in the correct order, then this script may help you out.

Brian Moran stumbled across two free Microsoft e-books that he thinks many SQL Server professionals will find valuable. Both books cover information that can help you use Microsoft technologies to deliver more effective BI and data-warehousing solutions.