From my observations (my role is only "advice from a distance" for our larger developments), schema are simply not used. Business areas of the model are split into separate databases...

I absolutely believe it is useful to upgrade from SQL 2005 Standard to 2008 Standard. The warehouse I manage has gone from 7.0, 2000, 2005 to 2008. Going to 2005...

Why do I like SSC? It is a factor that it's free, but the main reason is that it's a friendly helpful place to look for answers and to expand...

Seamless upgrade? Now that was an unexpected topic 😀

I'm in two minds about whether it's truely a new version, but they've certainly put in a lot of work and there...

The words in the keynote that got my attention were "seamless upgrade". There were sufficient nice things about 2005 on the relational and administrative side that we decided to quickly...

On release day I found I could buy an OEM copy of Ultimate for "only" $NZ400. So despite intentions of being rational about the whole thing, I couldn't resist.

The pleasant...

Great stuff Steve. I really appreciate the effort you go to for the "after party party". It's been two whole years since I last got to PASS, so the lengthy...

Sigh, lost my post again Just as well this time I saved the text to an editor. Perhaps there should be a warning on...

New Zealand has two legal languages - English and Maori. The only "special" character in Maori is the little bar that can be placed over a vowel. It indicates that...

I'm assuming you got a better price than the YouTube founders. That makes sense since (a) SQLServerCentral is a damn sight more useful; and (b) you've earned it.

I always feel a pang of...

A particular area where you can never please everyone - and just to prove my point ...

I've never found prefixing table names with...

The first significant programs I wrote were both as a result of my having a ham radio licence. I built an ASCII keyboard from scratch (okay, I didn't build the...

Nice interview. Always good to hear about the people behind the product.

Graham - you say: As long as step 8 is followed (Click "Print column headers(*)") which I think is the default anyway then the header row will be there. Try it...

Hi Graham,

It could be that I'm really tired (and I am), but step 3 of Method 1 says:

   Click "Results in Text"

So we're no longer in "Grid" mode. The...