SQL Server Magazine June 2002
[Focus]
Follow the choices that one development team made to create a secure Web-based analysis system.
By Mark Scott , et al.
Did you know that your database can tell you how to increase your revenue and build customer loyalty? With Analysis Services, mining your data for gold is easy.
By Frances Keeping
[Features]
Keep your complex software-development projects in check by building a version-control system that uses Enterprise Manager and Visual SourceSafe.
By Wayne Kurtz , et al.
[SQL Server Savvy]
Learn how to calculate the number of lines in a bulk copy data file.
By Brian Moran
Learn how to provide feeback to the SQL Server development team in a forum that it responds to: sqlwish@microsoft.com.
By Brian Moran
Discover what the Paste command actually does in SQL Server 2000.
By Brian Moran
Learn about the pitfalls of using the approximate data types float and real.
By Brian Moran
[Editorial]
Solving problems, learning about new technology, or writing stored procedures to address user requests might be more fun, but ensuring database consistency and recoverability comes first.
By Michael Otey
[Reader to Reader]
A reader shares a tip for solving the problems that crop up when a view's objects change.
By Readers
[SQL Seven]
Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.
By Michael Otey
[Inside SQL Server]
Knowing what happens under the data-modification covers can help you tune your indexes for your most frequent operations.
By Kalen Delaney
[Mastering Analysis]
Track the time employees spend working on projects.
By Russ Whitney
[Solutions by Design]
The who, what, when, where, and how of inventory control can quickly get out of hand. Take charge by applying this metamodel for basic inventory management.
By Michelle A. Poolet
[T-SQL Black Belt]
Next time someone tells you to think outside the box, try this rectangular technique.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team explains why you should set up your databases to retain transaction-log records.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team gives examples of the changes SQL Server users should be aware of when upgrading their systems from SQL Server 7.0 to 2000.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team provides code that shows how to get around the T-SQL INSERT command’s lack of support for a variable argument.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team explains why a log-file backup is huge after large tables are reindexed.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team explains why ownership changes when you’re using SQL Server 7.0’s merge replication utility and why it doesn’t change in SQL Server 2000.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team provides statements that return a trigger’s single and multiple results.
By Microsoft's SQL Server Development Team
[Exploring XML]
Web services is the hot new topic for the Internet. Find out how to use them to access your SQL Server databases.
By Rich Rollman
[Letters]
Readers write in about using realistic data in testing, handling data-flow design, using Profiler to see how SQL Server tools work, and more.
By Various Authors
[New Products]
Check out these new and enhanced products.
By Carolyn Mader
|
