To defrag external fragmentation takes an operating system utility, not a SQL Server utility. One of the most popular tools for defragmenting SQL Server database files is a tool from Executive Software called Diskeeper. Diskeeper has been around for many years, and many of you may already be familia

From Data Access – combit GmbH (www.combit.net) has announced the release of extensive Visual DataFlex support for their report generator List & Label software. According to combit, the tool seamlessly integrates with VDF and provides developers with a database independent report generator that equi

Written by: Scott Klein – This tutorial will introduce you to using XML with Microsoft SQL Server 2000™ and guide you through the concepts and techniques of how to read and write data using XML with Microsoft SQL Server 2000™. You will learn the various methods used and see how powerful and flexible

Microsoft Corp. is bringing its next SQL Server release, code-named Yukon, in line with its .Net and Web services vision, with new data unification and integration technology. Microsoft plans to embed .Net CLR (Common Language Runtime) in the SQL engine, as well as provide deeper and richer XML su

By JORIS EVERS – Microsoft Corp. released three software patches rated “critical” and a fourth rated “moderate.” The patches plug holes in Internet Explorer, Windows XP, SQL Server 2000 and Commerce Server 2000.

by Alexander Chigrik – In this article, I want to tell you what should you know about some undocumented SQL Server 7.0 trace flags, and how you can use them for administration and monitoring.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a par

In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Queries. Most of the time we use ASP pages, we use them to retrieve or manipulate records in the database. These database connections are resource heavy and every query takes time on part of the

The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java™ environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.

By Matt Berger – DEEP IN THE midst of an effort to beef up the security of its software, Microsoft Monday made available a free tool designed to search out security vulnerabilities hiding in Windows-based computers.Called the Microsoft Baseline Security Analyzer (MBSA), the tool is intended

by Dean Thompson – Log Shipping is a Disaster Recovery (DR) tool that provides you the ability to have a readily available “warm backup.” Essentially, should your existing system fail, you have a backup SQL Server and database available to take over with relatively up-to-date information. If your da