The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Read all about SQL Server 2000's new and improved Data Transformation Services (DTS) tasks, which could cut your DTS development time in half. Then check out our exclusive lab report to find out which is faster for moving a large amount of data into or out of a SQL Server database: bulk copy program (bcp) or DTS's Bulk Insert task.
By Michelle A. Poolet
You can design a useful database for every corner of your life—including your cherished music CD collection.
By Brian Moran
If you need to upgrade SQL Server Personal Edition to SQL Server Standard Edition, simply run the setup program from a SQL Server Standard Edition CD-ROM.
By John Green
Seven issues to consider when using a bulk copy operation.
By Michael Otey
No sooner did Oracle and Sun finish lambasting Microsoft’s new .NET Framework than they both turned around and launched their own Internet application platforms—both modeled on the Microsoft.NET Framework.
By Itzik Ben-Gan
As NULLs, UNION ALL, and random sorting show, sorting issues aren't always trivial.
By Russ Whitney
Here is the solution to March's MDX Puzzle.
Check out Michael Otey's picks for SQL Server 2000's top 7 XML-integration features.
By Vikash K. Agarwal
A comparison of local temporary tables and global temporary tables.
By Rick Dobson
SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.
Microsoft's XML for Analysis specification will help Analysis Services build a bridge to the Web and .NET.
Use recursive stored procedures to generate a tree from a SQL Server table.
By Rodney Landrum
MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.
Here is the April MDX Puzzle.
By Paul Thurrott
Oracle targets SQL Server and IBM DB2 users with 9i Application Server Release 2.
By Richard Waymire
Microsoft’s Richard Waymire explains security with dynamic T-SQL, triggers on multiple tables, and much more.
By Ken Spencer
Sweep out the cobwebs while you upgrade your Web site.
Small Business Server 2000 suite, which includes SQL Server 2000, promises relief to tech-challenged small and home businesses.
The contents of the eight fields that make up the format file header.
By William Vaughn
Learn how and why to use named parameters when you use ADO 2.6 to execute SQL Server stored procedures.
SQL Server 2000 and partner products from EMC, Knosys, and Unisys deliver record-smashing OLAP performance in the T3 trials.
Need to move a large amount of data into or out of a SQL Server database as fast as possible? This report from the SQL Server Magazine Lab compares bulk copy program and Data Transformation Services' Bulk Insert task.
Learn how to manage trace operations with SQL Server Profiler, how to move databases and their objects from one server to another, how to upgrade SQL Server Personal Edition to SQL Server Standard or Enterprise Editions, and more.
By
Readers share their tips for shrinking log files, checking a disk controller's write cache, and finding and inserting missing records.
By Brian Knight
SQL Server 2000's Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.
By Kalen Delaney
Kalen Delaney leads you through the wilds of undocumented SQL Server commands to solve another mystery.
By Rich Rollman
Rich Rollman answers readers’ questions about using XML with SQL Server 7.5, posting parameters to a template, and accessing the value of an HREF attribute.
advertisement