Yeah, I threw that little nugget in there to show that I originally requested to telecommute when we in the States thought that $1.80USD was high for gas. It...

Tricky question, but a fair one. I almost got suckered into the 8KB calculation...

I'm the DBA for a large medical system in the midwest and we purchase many of our solutions versus doing in-house builds. While I'd flogg my developers for coding...

First of all Grant and Gail, coming from the Program Committee, all I can say is that the sessions have been selected and it's to the point where Tom and...

The commit process is an almost organic process - it depends upon so many factors that it is almost easier to say that SQL commits when it feels it needs...

When configuring log shipping what you are essentially doing is configuring a backup scheme that will perform the following steps:

1. Run a log backup

2. Restore the backups to a standby...

Additionally you can also run either query below:

EXEC sp_helpdb @dbname --Where @dbname is sysname or varchar

SELECT * FROM sys.sysfiles --Will return info for the...

I've been telecommuting at least 2 days, if not 4 per week now for over 8 years and I'm a huge advocate. However, my situation is unique compared to...

Simple explanation: this is just a leftover April Fool's QOTD. Just give everyone a point who submits an answer, give me 5000 points for coming up with this...

Funny, us DBAs here in Kalamazoo have not heard anything about this until now. We are the new Redmond, y'know!

DTS can use a User, System, or File DSN. Linked Server specifically wants a System DSN.

Ah, my bad!

We've run both SQL 2K and 2K5 on VMWare in both prod and test environments. We even had a really beefy OLTP db suite running on it for 3...

Wow, I think the defragging is overkill....

Enough with the editorializing though, does the service account for SQL have the right to Lock Pages in Memory? If not, grant it...

SQL Server (and IIS too) require System DSN. A Technet search will confirm this.

Create the System DSN on the SQL server and it should work though I have no...