Jeff Moden (9/17/2014)

---

I'm curious. What are you using to determine that a file is done being written to and is...

SSIS can also do this well along with SQL Agent to run the SSIS package. Either waiting for a file to appear in a folder or running at specified times...

CTEs are just so much more elegant and readable and easier to test each step - I've ended up with 6 in one query to build up data and do...

It's all so very "big company".

In a smaller outfit like this with only half a dozen in the dev team covering DBA, design, development and day-to-day application support, you...

Grins and nods - been there! SSRS multiselect can be a real pain, especially with string parameters.

Which is why our report writers insist on having Jeff Moden's DelimitedSplit8K [/url] and...

Gary Varga (7/3/2014)

---

P Jones (7/3/2014)

---

We base our operation on the ITIL framework so the central IT helpdesk is the single point of contact - the front line for anything IT...

You could also contact the vendors of the CRM system and find out what their default passwords are when installing systems. It may well be that the sa password is...

We base our operation on the ITIL framework so the central IT helpdesk is the single point of contact - the front line for anything IT (or phones) related and...

General answer is "I'm just a civil servant" - that is usually understood by most people as boring so they don't go further.

And the next level is "working in...

Yes there are uses for these files. It logs what has been delivered and lets others see what fields are available.

It also gives you a way of checking if...

Like you we do DBA, .NET and SQL development and working for the government we have to jump through these hoops too and our server guys keep taking privileges away.

We've...

Maybe they have to jump through QA hoops to deploy packages so having the truncate in an sp is done with a view to future amendment or expansion as it...

Visio is my favourite tool for documentation and design (and the one available when you work in a restricted Microsoft shop!).

I reverse engineer my databases into Visio Premium to give...

As one of the "middle generation" - a fifty something woman - I think the difference nowadays is that the technology works without being nursed along by those with more...

As a developer who doesn't want to lose my work as well as being the main DBA I make sure the development and test servers have the Ola Hallengren backup...