SQL Server Magazine April 2001
[Focus]
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 Brian Knight
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.
By John Green
[Features]
Learn how and why to use named parameters when you use ADO 2.6 to execute SQL Server stored procedures.
By William Vaughn
Use recursive stored procedures to generate a tree from a SQL Server table.
By Rohit Nadhani , et al.
[Lab Reports]
MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.
By Rodney Landrum
[SQL Server Savvy]
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 Brian Moran
[Editorial]
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 Michael Otey
[Reader to Reader]
Readers share their tips for shrinking log files, checking a disk controller's write cache, and finding and inserting missing records.
By Various Authors
[SQL Server Q&A]
Microsoft’s Richard Waymire explains security with dynamic T-SQL, triggers on multiple tables, and much more.
By Richard Waymire
[SQL Seven]
Check out Michael Otey's picks for SQL Server 2000's top 7 XML-integration features.
By Michael Otey
[SQL Server/Office Integration]
SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.
By Rick Dobson
[Inside SQL Server]
Kalen Delaney leads you through the wilds of undocumented SQL Server commands to solve another mystery.
By Kalen Delaney
[Web Dev]
Sweep out the cobwebs while you upgrade your Web site.
By Ken Spencer
[Mastering Analysis]
Microsoft's XML for Analysis specification will help Analysis Services build a bridge to the Web and .NET.
By Russ Whitney
[Solutions by Design]
You can design a useful database for every corner of your life—including your cherished music CD collection.
By Michelle A. Poolet
[T-SQL Black Belt]
As NULLs, UNION ALL, and random sorting show, sorting issues aren't always trivial.
By Itzik Ben-Gan
[News Analysis]
Small Business Server 2000 suite, which includes SQL Server 2000, promises relief to tech-challenged small and home businesses.
By Paul Thurrott
Oracle targets SQL Server and IBM DB2 users with 9i Application Server Release 2.
By Paul Thurrott
SQL Server 2000 and partner products from EMC, Knosys, and Unisys deliver record-smashing OLAP performance in the T3 trials.
By Paul Thurrott
[XML Q&A]
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.
By Rich Rollman
|
