Learn how to get MSDE, install it, and use it as your application’s database engine: integrate it with Access or SQL Server, manage it with OSQL, implement security and authentication, and do backups and replication.

Because you’re working in a development environment where SQL Profiler and server tracing are suitable for use (that is, the potential performance impact doesn’t affect production), you could set up a server trace to log information to a table in the background. Then, you could search this table to

By Peter Schmitz – Scripts to automatically get notified if a database grew due to the autogrowth option being turned on. I wrote this after searching all over the web for something like this, but didn’t find anything.

Join author Bill Pearson in a hands-on introduction to virtual cubes in the SQL Server 2000 Analysis Services series. Learn how virtual cubes provide options to extend cube functionality, act as an adjunct to security strategy, and otherwise add value to information products.

Get an overview of Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) query processor, followed by some application and query performance tuning approaches.

By Michael Otey – Even with Microsoft’s ramped-up security efforts, your systems are still only as secure as you make them. Here are some common-sense measures you can take to safeguard your SQL Server systems.

By Andrew Barringer – This view allows you to easily see the top 10% by Row Count, Space Used, etc. This is useful for answering the question “what’s taking up all the space in my database?” I wrote it when asked to find what table(s) were using all the space in a particular database.

By Sara Cushman – Every DBA knows the importance of a good backup and recovery plan, but finding one that actually works isn’t so simple.

by Daryl Barnes – Find out about SQL Server and XML in this chapter except from SQL Server 2000 XML Distilled from Curlingstone Publishing.

IBM, Oracle and Microsoft are readying supercharged versions of their databases to take advantage of new high-end hardware–but analysts say sheer processing muscle may not be enough to spur demand.