Tag: sql server

Community

Power Up Database Apps With XML

by Daniel Anderson and Mary V. Hooke – In this article, you’ll look at the XML for SQL Server 2000 Web Release 2 beta 2 (WR2) package and discover what it brings to your development toolbox (see Resources). You’ll build a small Visual Basic example using the XML Web release and the XMLHTTP object pr

Community

Restoring Your Database Safely

By Joe Lax – As I’ve shown in my previous 10-Minute Solution, "Choosing the Right Backup in SQL Server," SQL Server provides you with numerous ways to back up your database, allowing you to choose the options that best suit your situation. However, the best backup solution comes to naught if you don

Community

SQL Server Locks – Introduction

by Michael Balloni – Relational databases like Microsoft’s SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data a

Community

Restoring Your Database Safely

By Joe Lax – As I’ve shown in my previous 10-Minute Solution, “Choosing the Right Backup in SQL Server,” SQL Server provides you with numerous ways to back up your database, allowing you to choose the options that best suit your situation. However, the best backup solution comes to naught if you don