The last books I bought were Klaus Aschenbrenner's Pro SQL Server 2005 Service Broker and the MCTIP training courses for SQL2008.

The problem is that books are relatively expensive door stops...

:connect $(Maindbserver) -U YourUserName -P YourPassword

Personally I would avoid SQL standard...

Back in the early 1990s I got made redundant on my birthday. Of course they waited until after lunch when I had bought the cakes that employees are supposed...

In addition to the above I would look at putting the tables on separate file groups and possibly separating out the indexes from the data.

Thanks Jonathan, much appreciated.

If you have a contact table and the contact is "The company secretary" then you are trying to contact a title rather than a person...

To be honest I am shocked to hear that people don't verify their backups.

I'm also surprised that it isn't the default action for a backup and requires a DBA to...

Some of the stored procs that my company uses to detect problems with application performance are actually the main cause of the performance problems.

The data management views are quite good...

ISO5218 has the following definitions for Gender

0 = Not Known

1 = Male

2 = Female

9 = Not applicable

If you have the freedom to choose the encoding then start with the ISO...

I work for a calculated risk taker who is VERY good at calcuating.

I think it depends on what the boss was before he was a boss.

I've found accountants uniformly awful...

Bert (2/13/2009)

---

David.Poole (2/12/2009)

---

I regard God as an external manifestation of the human desire to aspire to be better than we are.

As long as there is a worthwhile target that is...

As far as BI and global warning is concerned I would say that it tells us that there is a lot of money to be made out of climate change.

There...

I regard God as an external manifestation of the human desire to aspire to be better than we are.

As long as there is a worthwhile target that is within our...

I know someone who described an auditing system as a blame culture with proof.

I am fortunate to work within a very strong team who I trust implicitly. I know...

This time last year I wrote about how to share templates within a team of DBAs http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/

I use templates in conjuncton with the SQL Prompt and the combination of the...