(Srinivas Sampath) Service Broker is the new kid in the block in SQL Server 2005. Before we actually delve into the features of Service Broker and write our first program, let us first imagine a scenario where we would want to fit Service Broker and then work off that.
Author: SSWUG Research
XHTML-Print leaps to recommendation status
(Ed Tittel) In the late 1980s and early 1990s, when Novell and Microsoft were duking it out for network dominance, Novell’s then-marketing VP Craig Burton said "the great thing about [networking] standards is that there are so many to choose from." Though it was meant half-jokingly, Novell’s tardine
Features and limitations of the .NET Managed Provider for Oracle
This article describes the features and the limitations of the current version of the Microsoft .NET Managed Provider for Oracle.
DB2 SQL Introduction
(Ramesh Krishna Reddy) SQL (structured query language) is used to acccess, manipulate or control the access of rantional database. Databases like DB2, ORACLE, SQL SERVER 2000 support the SQL (Structured query language).
Tip: Use data URIs to include media in XML
(Uche Ogbuji) If you have some XML to be bundled with related media, such as an image file, you can use simple URI reference. Listing 1 is an example of some XML with such a reference — based, incidentally, on a construct in the IBM developerWorks content format.
Exceptions and Performance
(Jon Skeet) Almost every time exceptions are mentioned in mailing lists and newsgroups, people say they’re really expensive, and should be avoided in almost all situations. As an idea of just how expensive some people think they can be, in one article someone asked whether the fact that his web appl
Building a High-Availability MySQL Cluster
(Kris Buytaert) Today’s enterprise depends on the availability of mail and web services. Failure is never far away, whether it be a hardware failure or a human error. We have to try to make an infrastructure as highly available as possible.
Introducing the ASP.NET 2.0 GridView Control
(Ziran Sun) Most web applications perform some sort of data access. The data access tools made available in ASP.NET 1.x were far more powerful then anything available in classic ASP, but with that power came an additional level of complexity. With ASP.NET 2.0, Microsoft has taken things to the next
Using Hash Keys instead of String Indexes
(Arthur Fuller) Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice
Returning Rows Through a Table Function in Oracle
(James F. Koopmann) In Oracle9i, we are now able to call a table function within the FROM clause of a SQL statement and have it return a result set that mimics what we would normally expect from a traditional SQL SELECT statement.