OK, so I'm curious and interested in expanding my repertoire when it comes to liquor...

Whiskey / whisky vs scotch, and, what's so bad about Jack D?

(Note, I've only...

Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more.  It is in excel...

• This reply was modified 6 years, 3 months ago by MVDBA (Mike Vessey).

Thanks, that's indeed very helpful.

Let me add some remarks:

<li style="list-style-type: none;">

1. Yes, I fully agree. Actually one reason for hiring me was to get rid off all the...

as far as I can see, that looks about correct.

why are you checking CPU speed, SQL needs disk as its main resource, with RAM a close contender.

I know you used...

a few options  I can think of

1. use Redgate from the start - SQL compare to a blank database, or check it all in via source control and then build...

you would not want to create the replication objects (ok it's fairly safe as the SQL agent job won't be there to pollute your distributor) - but not all users...

I think we all forgot to ask Grant …. 'How was the Haggis?" - I know it's just "meat porridge with herbs" , but I like it

if you are anywhere near Aberlour, they have a distillery with tasting sessions... you know, it might fill up your free time 🙂

depends where it comes from for...

• This reply was modified 6 years, 3 months ago by MVDBA (Mike Vessey).

haggis is great - it's the whiskey that makes it better

(and PS Grant, you are our long...

it looks like this data is coming from an excel spreadsheet that is casting everything as text, hence the scientific numbers and the bad data

maybe worth looking at adding a...

ok - this might be a stupid question - you want it as a number, but still keep it stored as varchar?

why ?

one of the key things and true DBA...

i'm 99% sure you can't restore master from 2005 to 2008

might I suggest you take a huge leap and go to 2019????

and to reattach the databases - use restore database...

cancer is truly horrible and I've had a few...