Personally, I don't think it is possible to be a narrow-focussed specialist. To be great at one area you have to understand the things that impact that area.

I'm...

I concur that poptarts (although we don't really have these much in the UK) would be useful in a survival situation but I'd still want to do further investigations into...

I've resolved this- the issue was caused when the projects in the associated project list were deleted and resulted in a number of items in the log having their project...

Thank you for the help. That's provided me with the column and table list for informationS_chema.

Thanks 🙂

I use 'squishy bit' e.g. the problem with the system is the squishy bit in the chair....

It might not sound like much but being able to highlight a string and press F1 to get help on the selected text is absolutely awesome in SSMS- it's not...

My company's BI is lightyears behind where it could be (and should be IMO) and being able to prototype and demo more sophisticated data analysis methods and visualisations to anyone...

ZETM, I fully believe in maximising strengths instead of minimising weaknesses, and in this case I don't think it's a flaw that you quit and had an employment gap.

I'd be...

Some people have already touched on the BI side of things and it's the most relevant for me.

I started off as a completely non-technical analyst, but started working on ways...

A manager is responsible for you, not the systems you have access to. They are not one and the same.

In the companies I've worked for, most of my managers...

As the full details of the story still seem unknown, the discussion on his behaviour seems to focus around 1) password sharing policies and 2) the extent to which an...

Thank you very much for the response. I've downloaded the extension pack and its working well. The table difference task and a few others are already proving invaluable!

The...

*bump*

It's a bit on the heavy handed side in terms of the endorsement but it is an interesting concept- I was going to take a look to see if it...

To expand on davec's comment since you seem unfamiliar with the insert into x select * from z here is the basic syntax for temporary table population

CREATE TABLE #[tablename] (column1...