Work Around Errors in Database Web Apps

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.

Quarter of a Century Competition on P2P

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.

Blogs

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Data Visualization, Context, and Domain Expertise

By

I recently posted a graph to twitter and asked people to explain it. Let’s...

Approaches to running Databricks ETL code from Azure ADF

By

Databricks is fantastic, but there is a small issue with how people use it....

Read the latest Blogs

Forums

How to compare 2 databases to find what objects are out of sync?

By Goalie35

Last night, my company tried deploying a large update to almost all tables &...

Worker Threads Per Session

By alex.sqldba

Morning All, Is it possible to determine how many threads are spawned by a...

Is it acceptable to use the presence of a value in a NULLable column as a flag?

By edwardwill

I have a stored procedure that processes rows in a table. The stored procedure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers