Be Professional

Check out http://www.tomshardware.com/. These guys test computer hardware and have a knack for being "Brutally honest" without being overly harsh. They perform detailed tests under fair conditions and stick...

This option should not be available for servers but it is quite useful for desktop applications using MSDE; in fact, MSDE databases have this set as the default. There is...

In the article you stated "you'll have to store your code in a file and execute it as an OS task using wscript.exe" but what you really want to use...

What Microsoft released prior to the Slammer crisis was little more than a "Here's a patch so you can't blame us" release. I manage over 140 SQL Servers (Not including...

Some additional comments and corrections (from experience):

the 039 patch is not sufficient to keep a server from becoming infected and, from what I have seen, SP3 does not keep SQLSlammer...

I tried this on my installation of SQL Server 2000 (SP2 plus security patch 061) and it couldn't find the table. It turned out that the table name in the...

SQL Server 2000 SP3 is supposed to have an option to enable cross-database ownership chains. This might help you out (in 1-2 weeks).

Bryant E. Byrd, MCDBA

SQL Server DBA/Systems Engineer

Intellithought, Inc.

bbyrd@intellithought.com

I find it a lot easier to remember where something is in a book on my shelf than trying to search a web site to find the article I read...

Another reason to name your constraints is to help debug applications. A foreign key violation message states which column(s) in the key table were violated but doesn't tell you the...

SQL logins are the only way to handle connections for web applications that connect directly from ASP code to the database with no intermediate components; otherwise, SQL logins have no...

Without a doubt, as a DBA or a developer, storing the images in the same DB as the rest of the data is the best way to handle it.

Developer point-of-view:...

As a developer or DBA, the most important think you can know is "where to look". You don't know everything. You can't know everything so don't try; that is what...

Another advantage of the BAS file is that you can perform search and replace functions on it from your favorite text editor. This has come in handy for me when...