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.
Other News
Why 2003 Will Be The Year Of Enterprise Web Services
By Nick Evans – As we get ready to begin a new year, we stand at an important point in time for the software industry. The Web services paradigm, one of several factors helping drive the industry towards the use of software as a service, stands to gain mainstream acceptance and deployment within the
Tip: Basics of bootstrapping with DOM, Part 2
By Brett McLaughlin – In this tip, you’ll learn about a better way to bootstrap in your DOM applications. This builds upon the previous tip, which examined the abilities that DOM natively provides for this task.
Reports from XML 2002
by Eric van der Vlist – For many participants, the most memorable event of XML 2002 will be Jean Paoli’s presentation of Office 11, which promises to deliver easier access to XML for hundreds of millions of workstations.
Oracle seeks to align Eclipse with Sun’s Java
An IBM-backed Java tools initiative could be yanked back into Sun Microsystems Inc’s sphere of influence, to heal a potential community rift, through efforts lead by Oracle Corp, writes Gavin Clarke.
How to Manage Multiple Developers Using the System Administrator Account
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
Handling database file growth
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.
Introduction to SQL Server 2000 Analysis Services: Exploring Virtual Cubes
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.
Microsoft Talks Up Office 11 Developers Tools
By Gregg Keizer – Microsoft answered questions about how developers were supposed to take advantage of Office 11’s new functionality, particularly its XML expertise, by unveiling a set of development tools, code-named Visual Studio Tools for Office.
Most efficient way to remove duplicate rows
By Pau Fores – This script uses a hash join — the most efficient way of joining huge tables — to find duplicate rows. It has been tested on Oracle 6.0 to Oracle 9i v2, and it works in all of those versions.