Articles

External Article

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.

2001-11-26

1,684 reads

Technical Article

SQL Server 2000 Replication Chat Hosted by PASS Today

SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!

2001-11-15

3,885 reads

Blogs

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

The Importance of Patch Management to Avoid Downtime

By

A recent Microsoft outage caused by a bad patch pushed out to Windows instances...

Friday Flyway Tips–Comparison Defaults

By

One of the little details that I find matter more and more in enterprises...

Read the latest Blogs

Forums

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers