Additional Articles

Work Around Errors in Database Web Apps

by Additional Articles

Microsoft MSDN

Miscellaneous

ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.

2001-07-13

1,579 reads

Quarter of a Century Competition on P2P

by Additional Articles

Other

P2P, the programmer's resource centre from Wrox Press, reached a milestone of 25,000 subscribers this week. To celebrate this fact, Wrox are giving away $1000 worth of books and ASPToday subscriptions in a free prize draw. For more details on how to enter, please visit: http://p2p.wrox.com/25k.asp. The draw will be made on July 16th.

2001-07-12

45 reads

Using Stored Procedures in SQL Server

by Additional Articles

Microsoft MSDN

Stored Procedures

If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.

2001-07-09

4,417 reads

Taming the Stateless Beast: Managing Session State

by Additional Articles

Microsoft MSDN

Performance Tuning

Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.

2001-07-06

1,721 reads

SQL Server CE: New Version Lets You Store and Upda

by Additional Articles

Microsoft MSDN

Miscellaneous

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.

2001-07-05

802 reads

PASS 2001 North America - Register and Save $500

by Additional Articles

PASS

Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!

2001-07-04

3,665 reads

Clonation and the Case of Table Dolly, Part 2

by Additional Articles

Microsoft MSDN

.Net

In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.

2001-07-03

950 reads

SQL Server 7.0 Log Shipping Frequently Asked Questions

by Additional Articles

Microsoft MSDN

Administration

This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.

2001-07-02

1,764 reads

Microsoft Certification Exams Included in VA Education

by Additional Articles

Microsoft MSDN

Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).

2001-06-29

4,208 reads

Using Stored Procedures from ADO 2.1

by Additional Articles

Microsoft MSDN

Stored Procedures

If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.

2001-06-29

1,967 reads

All authors

Additional Articles

Work Around Errors in Database Web Apps

Quarter of a Century Competition on P2P

Using Stored Procedures in SQL Server

Taming the Stateless Beast: Managing Session State

SQL Server CE: New Version Lets You Store and Upda

PASS 2001 North America - Register and Save $500

Clonation and the Case of Table Dolly, Part 2

SQL Server 7.0 Log Shipping Frequently Asked Questions

Microsoft Certification Exams Included in VA Education

Using Stored Procedures from ADO 2.1

Blogs

SQL Server 2025 RegEx and AI

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

Why Databases Still Fascinate Me

Forums

Columnstore index question

Transactional Replication

Member was not found in the cube when the string

Question of the Day

Identify a Slipstream Installation