SQL Server Magazine June 2001

    Options
Programming/Return of the BLOB
Don't be afraid of the big, bad BLOB! This issue shows you how to tame the BLOB by using the ADO 2.6 Stream object to store binary large objects in your SQL Server database. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

Return of the BLOB

Use the new ADO 2.6 Stream object to store binary large objects in your SQL Server database.
By Michael Otey 



[Features]

ADO.NET: A Bridge to the Future

You've heard about ADO's data-access object model for server platforms based on Windows 2000 and Windows NT. Now learn about ADO.NET for .NET-enabled platforms.
By Dino Esposito 

Mastering Application Roles

Take advantage of application roles, a powerful and convenient way to administer security. The permissions that you grant to an application role are available to your users only when they run the activating application.
By Andy Baron  , et al.

OpenXML and Commerce Server: A Dynamic Duo

Use Commerce Server components and SQL Server 2000’s OpenXML feature to easily pass multiple rows of data from an application to SQL Server in one network round-trip.
By Joe Tillotson 



[SQL Server Savvy]

Questions, Answers, and Tips

SQL Server MVP Brian Moran answers readers' questions about using REPLACE and CHAR commands for string manipulation, managing Windows-authenticated logins, and more.
By Brian Moran 



[Editorial]

Get Ready for .NET

Microsoft says that the move to .NET will be more significant than the adoption of Windows. Don't get left behind.
By Michael Otey 



[SQL Server Q&A]

Answers from Microsoft This article is only available to registered users. Sign up now and get instant access!

Richard Waymire answers readers’ questions about mapping a logical drive, reinstalling a clustered SQL Server 2000 Enterprise Edition, securing tables, and more.
By Richard Waymire 



[SQL Seven]

ADO Performance Tips

Use these seven tips to get the best ADO performance with SQL Server.
By Michael Otey 



[SQL Server/Office Integration]

Views and Stored Procedures

This column looks at the SQL-DMO syntax required to examine and manipulate SQL Server views and stored procedures.
By Rick Dobson 



[Inside SQL Server]

Do the Splits

Knowing how SQL Server splits pages can help you keep your tables in shape.
By Kalen Delaney 



[Mastering Analysis]

Scaling and Decimal Accuracy

You can vary the accuracy of displayed numbers on a cell-by-cell basis by defining multiple calculated cells on the same range of cells. Learn how in this column.
By Russ Whitney  , et al.



[Solutions by Design]

Metamodel for Product Assembly

Extend the retail-sale metamodel to include product-assembly relationships.
By Michelle A. Poolet 



[T-SQL Black Belt]

Figure It Out

Mathematics plus T-SQL can equal a powerful way to solve your business problems.
By Itzik Ben-Gan 



[XML Q&A]

Exploring XML This article is only available to registered users. Sign up now and get instant access!

Rich addresses a behavioral issue in Query Analyzer and examines how it displays the results of XML queries. Then, he discusses the new XML Bulk Load feature that Microsoft introduced in XML for SQL Server 2000 Web Release 1.
By Rich Rollman