SQL Server Magazine June 2001
[Focus]
Use the new ADO 2.6 Stream object to store binary large objects in your SQL Server database.
By Michael Otey
[Features]
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
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.
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]
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]
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]
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]
Use these seven tips to get the best ADO performance with SQL Server.
By Michael Otey
[SQL Server/Office Integration]
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]
Knowing how SQL Server splits pages can help you keep your tables in shape.
By Kalen Delaney
[Mastering Analysis]
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]
Extend the retail-sale metamodel to include product-assembly relationships.
By Michelle A. Poolet
[T-SQL Black Belt]
Mathematics plus T-SQL can equal a powerful way to solve your business problems.
By Itzik Ben-Gan
[XML Q&A]
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
|
