SQL Server Magazine March 2002
[Focus]
Are you struggling with data-integrity losses? Learn how to balance integrity and performance with these normalization best practices that you can apply to your environment.
By Michelle A. Poolet
Bring the ancient art of Feng Shui into your design to let your data flow more smoothly. When you orient the data flow toward the user and remove bottlenecks that block the flow, you can achieve true balance and harmony in your system.
By Morris Lewis
[Features]
Avoid the double-hop problem in Windows 2000 authentication by putting Active Directory account delegation to work in your SQL Server configuration.
By Kevin Christensen
[SQL Server Savvy]
Here's how to use T-SQL's DATEDIFF() function to determine whether a date is the last day of the month.
By Brian Moran
A faster sort order doesn't necessarily improve performance.
By Brian Moran
[Editorial]
Visual Studio .NET is solid and reliable and delivers more enterprise- and database-oriented features than previous Visual Studio versions. Skip this release, and you’ll be missing out.
By Michael Otey
[Reader to Reader]
A reader shares a tip for sending job notifications in SQL Server 7.0 to multiple operators.
By Readers
A reader shares a tip for transferring login security from a source server to a test server.
By Readers
[SQL Seven]
Use these seven system stored procedures to monitor your SQL Server system and trace your applications' performance.
By Michael Otey
[Inside SQL Server]
When you're tuning JOIN queries, good indexes can make a world of difference in SQL Server's performance.
By Kalen Delaney
[Mastering Analysis]
When you understand Analysis Services architecture, you can use underlying properties to boost your query performance. Here are four connection properties in PivotTable Service that you can manipulate to improve performance.
By Russ Whitney
[Solutions by Design]
Multivalued attributes often mask lists and collections. Here's how to identify these normalization irregularities and correct your database design.
By Michelle A. Poolet
[T-SQL Black Belt]
Test your skill with three tricky new moves for avoiding cursors.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team tells you how three applications can help you convert data in an Access table into XML.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team provides step-by-step instructions for using the SQL Server Upgrade Wizard to convert all elements of SQL Server 6.5 databases (except the data) to SQL Server 7.0.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team describes two ways to import a table embedded in a Word 2000 document into SQL Server 2000 or 7.0.
By Microsoft's SQL Server Development Team
Microsoft's SQL Server development team charts the recommended clauses that help you avoid errors in date/time format.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team gives three reasons why you might receive this error message.
By Microsoft's SQL Server Development Team
[Exploring XML]
Have you hit a brick wall trying to use XML Bulk Load to upload ADO-generated data? Try this nifty solution.
By Rich Rollman
[Letters]
Readers write in about January 2002's career development articles, Analysis Services' Time dimensions, T-SQL's strength, and more!
By Various Authors
[New Products]
Check out these new and improved products for SQL Server.
By Carolyn Mader , et al.
|
