The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Michael Otey
Microsoft says that the move to .NET will be more significant than the adoption of Windows. Don't get left behind.
By Itzik Ben-Gan
Mathematics plus T-SQL can equal a powerful way to solve your business problems.
By Kalen Delaney
Knowing how SQL Server splits pages can help you keep your tables in shape.
By Mary Chipman
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 Michelle A. Poolet
Extend the retail-sale metamodel to include product-assembly relationships.
By Joe Tillotson
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 Dino Esposito
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.
Learn how SQL Server stores binary large objects (BLOBs) differently from other data types.
Use the new ADO 2.6 Stream object to store binary large objects in your SQL Server database.
By Paul Goldy
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 Brian Moran
SQL Server MVP Brian Moran answers readers' questions about using REPLACE and CHAR commands for string manipulation, managing Windows-authenticated logins, and more.
You can use application roles in a Visual Basic (VB) Data Environment.
By Rich Rollman
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 Rick Dobson
This column looks at the SQL-DMO syntax required to examine and manipulate SQL Server views and stored procedures.
Use these seven tips to get the best ADO performance with SQL Server.
Microsoft neglected to document three trace flags that might prove helpful when you're troubleshooting a particular database or trying to solve problems with starting SQL Server.
Managed providers, a new type of data provider, are the only direct ADO.NET way to access data sources.
By Richard Waymire
Richard Waymire answers readers’ questions about mapping a logical drive, reinstalling a clustered SQL Server 2000 Enterprise Edition, securing tables, and more.
Here's the proof that Cast9(a) = mod9(a -1) +1.
advertisement