I listen to fairly unintrusive music.

Movie soundtracks can be quite motivating without distracting.

Similarly, I find some of the LoFi chanels on youtube excellent to help focus by giving a quiet...

can you add a screenshot of the window in visual studio where you select existing remote?

It sounds like you need to do a sync/pull first.

But the question still remains, do the properties initialcatalog, username, password & servername overwrite the values in the connection string?

Quote Neil:

However, when I move on I've got experience that I can take elsewhere and I might end up being the only person who's touched AWS or Windows Clusters.  I...

• This reply was modified 2 years, 6 months ago by  winston Smith.

This post really resonated, thanks Steve.

Every email subscription, meetup, user group I see are all talking about massive volumes of data, tools to manage this data & very quickly I...

• This reply was modified 3 years, 1 month ago by  winston Smith.

A bit late posting to this but I'd like to offer an alternative opinion to those expressed above.

I agree, certs are not experience & they are easy to game. But...

Apologies, i got mixed up, i remembered that if a table is referenced by a FK it cant be truncated, but thats not the case here, so yes, truncate will...

Excellent, exactly what I need to know. Thanks for the help!

Burnout can equally occur if one is not busy enough and does not feel useful.

Ive been in both situations. Ive done the consultancy thing and although I learned more there...

• This reply was modified 5 years, 5 months ago by  winston Smith.

Pretty much spot on Grant! The only thing i would change is to say they wont automate me (or anyone) out of the process as they are kind of a...

Brilliant responses guys, some great thoughts for me to consider.

And apologies, I should have been clearer in my first post on a few things also:

• I was a consultant into...

perfect, exactly what i needed, i wanted to see what pros/cons there were of storing the non events, as they are in the source data. they are some good reasons...

yes, i probably can. I guess im asking is there any benefit to storing a non-event, in this case, the non attendance at a course?
is there any benefit of...

That makes sense. In relation to the article, is it incorrect to say the logins "exist automatically" if both instances is running under a domain account? i.e. they wont already...

I saw that KB article which mentioned that if i was on SQL 2012 i needed a CU or SP1.

Im running SQL 2014 SP1 so i dont think that should...