SQL Server Magazine July 2003
[Focus]
When you use ActiveX controls along with the administration functionality that SQL-DMO provides, you can programmatically administer, customize, and control an entire replication topology.
By Jeannine Hall Gailey
[Features]
DTS package logs can provide valuable troubleshooting information--if you can keep them under control. By using this article's VBScript code with a scheduled SQL Server Agent job, you can manage both the size and number of text-file-based DTS log files.
By Shane Dovers
ADO.NET connection pooling improves the performance of .NET applications, but a busy application can sometimes accumulate connections, overflowing the pool and sinking performance. Here's how you can keep a watchful eye on your connection pools.
By William Vaughn
[SQL Server Savvy]
Do you need to call a Visual Basic .NET object from the INSERT trigger? Explore your options...
By Brian Moran
Learn how to find the size of the files in tempdb when SQL Server was last started.
By Brian Moran
Many DBAs forget the performance impact of auto-growing files when managing space for tempdb.
By Brian Moran
[Editorial]
SQL Server reached significant milestones in performance and overall market share this past year. But Microsoft faces the challenge of keeping SQL Server affordable and easy to use while adding advanced features aimed at the enterprise.
By Michael Otey
[SQL Seven]
Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
By Michael Otey
[Inside SQL Server]
This system (pseudo) table can help in your troubleshooting, but use it carefully.
By Kalen Delaney
[Mastering Analysis]
Working with any OLAP solution can help you better understand the technology, but using data that has personal meaning can help you learn even more about OLAP. Here's a practice solution that uses data you'll care about--your personal finances.
By Russ Whitney
[Solutions by Design]
Catalog inventory management can be one of the most complex challenges for database designers and developers because inventory is constantly growing and changing. Here's a basic ERD model that can adapt to a company's changing inventory.
By Michelle A. Poolet
[T-SQL Black Belt]
When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks.
By Itzik Ben-Gan
[News Analysis]
By the end of the year, Microsoft will roll out a new SQL Server product called Reporting Services that will let you manage the entire reporting life cycle, from authoring, to management, to delivery.
By Brian Moran
[Letters]
Readers write in about DTS portability tips, selling OLAP's benefits, a query for analyzing set relationships, and more.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
