Thanks! Useful script!

Will try this idea! Thanks.

Thanks Jack.

Will SSDT sync the local project and the physical database automatically? My devs make changes direct to DB in our dev/uat env.

We have a UAT and PROD DB and as developers we modify the UAT environment directly. Then script out any changes for PROD.

We did request a copy of Redgate...

Let me try that. I need our networking team to set up the DNS records first.

Thanks

Not quite that simple I don't think

Our current SSRS url is - http://server.net:16000/Reports/Pages/Folder.aspx

What I want to achieve is - http://reports.server.net/

Yes this is what went for in the end. Opening in sublime and copying and pasting the relevant xml. Saved so much time!!!

Thanks will give this a go.

I was going to do this - but can't find a way of building 2008r2 packages from msbuild. Is there something I'm missing?

Thanks Phil. No issue really - I'm working on getting files in the SVN.

All our packages are run via dtexc on a dedicated server - so trying to decide...

Thanks Ed - some interesting reading there. Didn't realise SSDT was so useful! Also the SQL Developer Licences are cheap enough for us to move towards a developer instance model.

Cheers

Nick

I'm keen to get our team using source control. However we have a couple of things that are making it hard to understand the best way of approaching it. Would...

Wow!

That's a dramatic increase! Thanks so much

See attached. Looks like it's not using the new index and instead the previous cluster.

Thanks - this definitely improve things. The query alone is now much faster - however the join with the exception table is very slow.

SELECT m.reportMonth

,m.reportYear

,ex.service

,sum(m.volume) AS Vol

,SUM(m.cost) AS effort

FROM [cts].[exception_Main]...