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
Tag: sql server
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
SQL Server 2000, XML and XSL: The Ultimate Combination
By Mitchell Harper – All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically structure
New JDBC drivers link XML to SQL
DataDirect has launched a set of drivers for connecting Java 2 Enterprise Edition (J2EE) applications to data in the major relational databases.
How Valuable Are Benchmark Scores?
By Brian Moran – You can’t judge a book by its cover, and you can’t judge a benchmark by its raw score. On behalf of PC Magazine and eWeek, eTesting Labs recently conducted database- and application-server benchmark tests.PC Magazine conducted a Nile-based benchmark test to compare the perfo
Yukon Destined as Microsoft’s Common Data Store
By Roger Jennings – The questions: Are Oracle and Microsoft using the same playbook? Are Bill Gates and Larry Ellison reading from the same page? The quick answers: “When pigs fly.” “Never happen.” “You crazy, man.” Not so fast. According to Microsoft’s recently announced plan
SQL Server Outperforms Java with Oracle
See how the Microsoft .NET platform outperformed Sun on its blueprint application, the Java Pet Store, running 28 times faster than previously published J2EE benchmarks.
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
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
Tracking Down Event Clues – Tracing the server side of SQL Server 2000
By Kalen Delaney – The SQL Server Trace tool lets you keep track of all the operations that SQL Server performs. For SQL Server 7.0, Microsoft completely rewrote the Trace tool. Microsoft dubbed the new incarnation SQL Server Profiler. However, the SQL Server 7.0 documentation never made it complete