I think I did miss my target with the myth, though as I think about it, giving up a liver every day for your boss might be how many of...

You can go dynamic. The SQL Browser service is what determines which port it is if you address the instance by name. So if you have a server named SUIS01...

2000 is the Server network Utility.

Try here: http://www.sqlservercentral.com/Forums/Search1-2-1.aspx

It's likely a transient error. The nHibernate stuff flips out at times. We did have issues this morning, but things seem to be running better now.

Brandie,

I'm slightly buried, but I'll try to get you one in the next week. Got to finish a presentation first 🙁

I think this is a good reason why we should have "certified" applications for SQL Server. Some way to limit access to the server to both a user and an...

Performance could be drastically different, though. Keep that in mind and set expectations from users. Especially if you have > 4GB of RAM.

If you are using SQLMail, I'd start to move off it. It is deprecated in 2005, meaning it will be removed in future versions. Also, it doesn't work on 64-bit...

The NO_LOG and TRUNCATE_ONLY options break the backup chain. IF you run these, you need to do a full backup right away.

However, a log backup removes the inactive transactions, or...

Filestream is only in 2008.

I think Agile works great in the DB, it's just different clients. Communicate often and regularly with the developers, who are your clients. Address their needs and change direction when...

The danger is knowledge.

MySQL is used by Yahoo and some other huge clients. Sun now supports it and it runs great in all sizes of companies. It has a modular...

You can implement your own version of log shipping without the overhead from SQL.

Run a backup, move that, while it's moving, run a diff, move that, then while things are...

It should be using SSIS, which I think has a few issues between 32 and 64 bit. However if you run it from the source, or from your workstation, I'm...