Let me start by stating some disclaiming remarks. I'm not against stored procedures in general, I find that the choice why procedures should be used, should be based on proper facts, not on claims without any proof.
2006-05-29
4,315 reads
Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?
2006-05-26 (first published: 2001-11-08)
31,335 reads
This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.
2006-05-26
2,841 reads
Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.
2006-05-25
5,300 reads
Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution.
2006-05-25
1,816 reads
Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.
2006-05-24
17,992 reads
This article, published in the June 2005 issue of SIGMOD Record, provides an overview of SQL Server Data Mining from a standards perspective.
2006-05-24
2,097 reads
Is a data warehouse required for business intelligence? Are these synonyms for the same concept? Vincent Rainardi brings us the next part of his data warehousing series that examines these two concepts and how they fit into your data analysis infratructure.
2006-05-23
14,160 reads
In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.
2006-05-23
3,059 reads
With the release of SQL Server 2005, it is more of challenger to Oracle than ever before. Guru Haidong Ji takes a quick look at how these two products compare and gives a few words of wisdom for the next version of SQL Server.
2006-05-22
10,600 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers