As an aside, I worked through the MS XML SQL Server programming book and having got through lots of interesting and useful stuff on updategrams etc the book finally said...

Andy,

From your experience what are the advantages of dot.net over the previous MS offerings.

We are having a struggle to get dot.net into our company and at this stage we're at...

I tend to use the DataEnvironment object to execute any views, stored procedures and commands within my app.

Intellisense lets you reference your database objects, and in the case of views...

I would love to see a good article/book on xp's.

There is a good example on this site to read an external text file. Note that it uses...

I do a lot of Web development and one of the problems I find is that the constants (adCmdStoredProcedure) used to indicate command types are rarely defined outside of an...

Have you ever considered storing them encrypted in the registry?

When my company develops internet applications we run a stress test tool against the site to see what sort of load the site will stand.

Does anyone know of any stress...

If you don't hard code your connection strings and you don't use NT security then what do you do?

My understanding is that "Full Recovery" records absolutely everything and is granular.

My understanding is that Bulk logging is used for massive inserts into the database.

I've had a situation where Full...

There is quite a bit of disagreement here with regard to naming conventions.

We are all in agreement that a naming standard is a good thing, but there is an absence...

I notice that Microsoft haven't encrypted the build in stored procedures within SQL Server!

Ripping off the SQL code is only practical if you rip off the database schema as well.

I...

quote:

---

What's convenient for DBAs, VB programmers, Access developers, end-users using something like Access or Crystal Reports, PowerBuilder and Java are all different;...

It would be useful if someone could come up with a naming standard that can grow as databases evolve i.e. to take us through to SQL Server 2050, ORACLE 69i,...

Brian,

Forgive my ignorance, but what do you put an SSL certificate on a SQL box for?

I use a number of Web Content Management Systems and have seen horrendous memory leak problems in some of them.

There are one or two that use an ISAPI filter in...