From SQL Team – Dynamic SQL is a term used to mean SQL code that is generated programatically (in part or fully) by your program before it is executed. As a result it is a very flexable and powerful tool. You can use dynamic sql to accomplish tasks such as adding where clauses to a search based on w

By Joe Lax – One of the inherent difficulties in backup and contingency planning is that it usually takes only one thing to go wrong to bring down your entire system. To be truly successful, your backup plan must account for all possibilities. Unfortunately it's easy to forget to account for one

By Steve Jones – Your manager—or a client—approaches you with an assignment and says, "I want you to make this scope change. And by the way, you need to get the job done today—with documentation—because the other developers are waiting for this project." Then, when you begin work, you discov

Book Review – The SQL Server 2000 Resource Kit is an eclectic collection of in-depth information on SQL Server 2000, and most likely it has something of interest for you. At 1,159 pages, it is not a book you will want to sit down and read for fun. But it contains much valuable information on SQL Ser

By DAN VERTON – Not so long ago, it was de rigueur for IT managers and analysts to ridicule Microsoft for selling enterprise database software that couldn't compete with Oracle and IBM in terms of scalability and reliability. How times have changed. Although Oracle and IBM

SQL Probe® is the first DBMS solution designed exclusively for Microsoft SQL Server monitoring and management. A 32-bit multi-tasking and multi-threaded application, SQL Probe's design and development includes input and feedback from Microsoft's Development and Primary Support teams, resulti

This article will explain each step you need to know to display records from the database using Servlets. The steps for displaying records in JSP pages and Java Beans are almost the same. We will first build a small example Microsoft Access database, create a DSN for it and using JDBC ( Java Databas

by Neil Boyle – First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance. To demonstrate how Index Intersection works, I am going to use the "authors"

By Igor Dayen – There are various ways to solve the problem of effective, automatic conversion of XML data into and out of relational databases. Database vendors such as IBM, Microsoft, Oracle, and Sybase have developed tools to assist in converting XML documents into relational tables. The various

June 27, 2001 from 9:00am to 10:30am Pacific Time. Enroll Now! Registration closes 24 hours prior to the event start time.<br> Do you use SQL Server as one of your relational databases? Are you aware of the powerful analysis tools included in the product? Many customers are in your same predicament