scott.w.white (7/30/2008)

This is a valid critique, ORM solutions or any dynamic SQL solution will be a little more chatty on the network. I would argue with gigabit networks and...

OK, it makes sense to grant a SQL login used only by an application the ability to change data. We do that by making the SQL login dbo. I was...

If you grant datawriter, how do you prevent users from making changes to data outside the scope of a program? If you grant datawriter, can't a user just connect with...

We use stored procedures for several reasons. first, we don't have to give insert/update/delete access on tables to users. Yes, users can run the stroed procs from Access or other...

Thsoe DBA's may have been certifiable, but definitely weren't certified. They also wanted to start archiving data when database size reached 1GB, so I tend to believe they were mainframe...

The DBA's that specified the 50MB were of the opinion that aproperly designed application doesn't need more tempdb. I was glad I didn't have to deal with them. Our tempdb's...

I would add that giving sysadmin access on a production server to anyone's everyday ID is just plain stupid. Set up ID's that are specifically for privileged access. That makes...

Is tempdb set to autogrow? If not, that might be the issue as well. One application I support makes liberal use of temp tables. A guy I knew at another...

If your encryption tool works like PGP, it may be trying to use or create temporary working folders. You may need to give permission on the folders to the account...

I second the backup and restore method. Create the databases on the new machine, then restore a backup from the old machine. Copying the mdf and ldf files is a...

My wife wanted me to get an MBA. I pointed out that I would either have to quit my job, or spend evenings and weekends for the next several years...

I would love to improve the vendor package I support, but management won't let me unless I can convince the vendor to make the change. Which happens occasionally. Unfortunately, some...

We only have one instance per server, so that simplifies things somewhat. Each server has service accoutns that follow a naming ocnvention that includes the server domain and the server...

On more than one occasion, I've wished for a BCD data type like IBM uses on the AS/400 (iSeries now). Specify enough places, nad there's never a rounding issue. Of...

I've been doing things with computers seriously since 1973, when I was in the 10th grade, and have spent most of my working life using computers to improve business. However,...