By Russ Whitney, 05/22/2002
Learn how dependency risk analysis works in this solution to May's puzzle.
By Michelle A. Poolet, 05/22/2002
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 Kalen Delaney, 05/22/2002
Knowing what happens under the data-modification covers can help you tune your indexes for your most frequent operations.
By Microsoft's SQL Server Development Team, 05/22/2002
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 Michael Otey, 05/22/2002
Solving problems, learning about new technology, or writing stored procedures to address user requests might be more fun, but ensuring database consistency and recoverability ...
By Michelle A. Poolet, 05/22/2002
PowerDesigner 9.0's notation--including data types--converts easily to SQL Server formats.
By Microsoft's SQL Server Development Team, 05/22/2002
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 Rich Rollman, 05/22/2002
Web services is the hot new topic for the Internet. Find out how to use them to access your SQL Server databases.
By Michael Otey, 05/22/2002
Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.
By Itzik Ben-Gan, 05/22/2002
Next time someone tells you to think outside the box, try this rectangular technique.
By Readers, 05/22/2002
A reader shares a tip for solving the problems that crop up when a view's objects change.
By Russ Whitney, 05/22/2002
Track the time employees spend working on projects.
By Russ Whitney, 05/22/2002
Challenge yourself to create a measure that calculates utilization for a selected employee and time period.
By Brian Moran, 05/22/2002
Learn about the pitfalls of using the approximate data types float and real.
By Microsoft's SQL Server Development Team, 05/22/2002
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 Brian Moran, 05/22/2002
Learn how to calculate the number of lines in a bulk copy data file.
By Sameer Dandage, 05/22/2002
Keep your complex software-development projects in check by building a version-control system that uses Enterprise Manager and Visual SourceSafe.
By Microsoft's SQL Server Development Team, 05/22/2002
Microsoft’s SQL Server development team explains why a log-file backup is huge after large tables are reindexed.
By Frances Keeping, 05/22/2002
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 Carolyn Mader, 05/22/2002
Check out these new and enhanced products.
By Brian Moran, 05/22/2002
Discover what the Paste command actually does in SQL Server 2000.
By Brian Moran, 05/22/2002
Learn how to provide feeback to the SQL Server development team in a forum that it responds to: sqlwish@microsoft.com.
By Frances Keeping, 05/22/2002
When you want to use an Access database for data mining, you first need to set up your data source. Here's how.
By Microsoft's SQL Server Development Team, 05/22/2002
Microsoft’s SQL Server development team provides statements that return a trigger’s single and multiple results.
By Various Authors, 05/22/2002
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 John Lynn, 05/22/2002
Follow the choices that one development team made to create a secure Web-based analysis system.
By Microsoft's SQL Server Development Team, 05/22/2002
Microsoft’s SQL Server development team explains why you should set up your databases to retain transaction-log records.