The Data Access Application Block is really quite excellent. This is also another opportunity to plug Code Generation. I know, I know, I promised to write an article on the...

I use this technique frequently. It is also handy for giving clients big chunks of data for them to edit so they don't have to wade through screen after screen...

The indexes should be like any other index but some of those modelling tools use some strange naming conventions. You should be able to script these out like any other...

Avi,

Some Entity-Relationship modeling tools create indexes on FK relationships for you behind the scenes but SQL Server does not do this on its own. Also, an index can only apply...

Here is the list of counters I used to use when I was a DBA. It is based on the SQL Server Operations Guide from Microsoft (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx). Many of...

Great article!

Here are a couple ways to check to make sure there is a mix of upper and lower case letters.

Use the LOWER function. This only ensures that there is at least...

I doubt it since SQL Server can not actually issue SQLXML requests to other servers. SQLXML is an API for applications to access SQL Server (Sort of like ADO, OLE...

If this is a ASP .NET web application then this newsgroup item might help you: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=1163d41c.0310170506.134be4a2%40posting.google.com&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3D.net%2Bsql%2Bprovider%2Bmdac%2B2.8%26sa%3DN%26tab%3Dwg

It looks like it was a security issue around identity impersonation.

Good luck!

I will try to write an article for the site if you're interested. I have been meaning to write several articles for some time now but can rarely find the...

I don't know much about the protocol-level stuff but I found this site via Google: http://www.freetds.org/tds.html. I am not sure if this is 100% correct since the page states "This...

If you're using SQL 2000, you would want to use a table variable rather than a temporary table for performance reasons (See BOL for details). You may also want to...

You're not concerned with performance? I bet your users are and...

The active account should not even be a DBO in the database(s) it uses. I recommend creating at least two db roles, one for general users and one for administrative...