The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Compare and contrast SQL Server 2000's core high-availability technologies, then walk through 6 steps to implementing failover clustering. Also, see how to work with BLOBs in ADO.NET, how to use dimension writeback, and more!
By Brian Knight
Many DBAs and systems administrators are intimidated by the idea of SQL Server clustering. But by breaking the process into these six manageable steps, you can set up a clustered environment to provide high availability for SQL Server.
By Russ Whitney
Discover a query that returns the top 10 non-beer products that were purchased with beer in the FoodMart 2000 Sales cube.
Try your hand at writing a query that returns all the FoodMart 2000 Sales cube customers whose total Store Sales equal at least 5 percent of the sales to the customer who has the highest total Store Sales.
By Michael Otey
Although delaying Yukon has financial implications and leaves SQL Server behind in the release race, Michael Otey applauds Microsoft for taking its time.
By Kalen Delaney
The query optimizer is a complex but vital part of SQL Server. Learn how the optimizer has evolved over the years in this first article in a series about the optimizer.
By
Readers share more mixed-mode authentication tips and ask about using ORDER BY in an assignment SELECT, which might not always work as expected.
You might think that using WinForm data binding with BLOBs is impossible. But this workaround lets you combine BLOB data in SQL Server with image controls on .NET WinForms.
By Rich Rollman
If you have an XML Schema, XML Views are the easiest way to obtain XML results from SQL Server. Find out how you can optimize your XPath queries by translating them into FOR XML EXPLICIT queries that you can include in stored procedures.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
Here's an alternative method for using the DataSet object to import BLOBs.
XML has become a vital interoperability tool and a core component of many applications. Here are seven XML document types that are most often used in SQL Server database application development.
By Brian Moran
You don't need a SQL Server license to run a DTS package and you can legally distribute some core DTS files.
SQL Server lets you write an outer join two different ways. You can use the old syntax, which is proprietary to SQL Server, or you can use the new ANSI-compliant syntax for expressing the join.
By Itzik Ben-Gan
Two readers submit solutions to problems of how to track dates and times. Using auxiliary tables is the key.
SQL Server never drops an auto-created statistic, even when you create a real index on the column. Deleting unnecessary auto-created statistics is up to you.
Dimension writeback is an essential function of budgeting and planning applications. You can create your own cube to learn how dimension writeback works in SQL Server 2000 Enterprise and Developer editions.
By Michael Hotek
Some IT executives are unwilling to spend money on disaster recovery, though they see the profit in high availability. But you can't have available systems if you can't recover them.
SQL Server 2000 provides three technologies that you can use to build highly available systems. But availability is more than technology. This article can help you put all the pieces together.
The way you use binary large objects (BLOBs) in ADO.NET is completely different from the way you use BLOBs in ADO. These examples will help you see how to incorporate BLOB data into your ADO.NET applications.
advertisement