Regardless of your opinion on SOAP (and I don't hate it nearly as much as some other folks here), having the SQL Server dishing it out directly was always kind of silly. Thats what a Web Server is for.
Amen to this.
DBA 101:
- Limit your connections to the database.
- Let the database do what the database is designed to do.
- For the love of FSM, eliminate dynamic SQL.
Cheers,
-m
Slashdot Mirror
Regardless of your opinion on SOAP (and I don't hate it nearly as much as some other folks here), having the SQL Server dishing it out directly was always kind of silly. Thats what a Web Server is for.
Amen to this. DBA 101: - Limit your connections to the database. - Let the database do what the database is designed to do. - For the love of FSM, eliminate dynamic SQL. Cheers, -m