Additional Articles

SQL Server 2000: .NET and the Death and Re-Birth o

by Additional Articles

Microsoft MSDN

Triggers

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.

2001-07-27

1,538 reads

SQL Server 2000 Operations Guide

by Additional Articles

Microsoft MSDN

Administration

Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.

2001-07-24

933 reads

Discuss

SQLServerCentral.com Wrox Book Giveaway

by Additional Articles

SQLServerCentral.com

Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-07-23

50 reads

Discuss

Troubleshooting ASP and ADO Errors

by Additional Articles

Microsoft MSDN

Stored Procedures

My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.

2001-07-20

2,008 reads

Harnessing the Power of SQL's Analysis Services

by Additional Articles

Microsoft SQL Home

WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.

2001-07-17

4,327 reads

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

All authors

Additional Articles

SQL Server 2000: .NET and the Death and Re-Birth o

SQL Server 2000 Operations Guide

SQLServerCentral.com Wrox Book Giveaway

Troubleshooting ASP and ADO Errors

Harnessing the Power of SQL's Analysis Services

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

Blogs

My 2024 in Data: Music

A New Word: Suente

Side Projects

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

Timeout Error while executing a TSQL statement in Sql server Express Edition

Sql script replace and rearrange numbers

Question of the Day

DCL