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...

We're still trying to get everything up to sql server 2008 (not R2) and not currently planning to upgrade from that because the business is up for sale at present.

Most...

The IT skills shortage is just like the so called plumbers shortage we had 10 years ago. A government initiative pushed teenagers into training as plumbers at the colleges, but...

In the properties of his login in Security in Management Studio, user mapping tab, msdb database, I think he should have one of the db_ssis..... roles ticked, probably db_ssisadmin.

Being...

If the csv format is the same why create new tables? Having a staging table which is cleared at the start of the whole import and just adding another column...

Also answers such as "I'd get on the SQL Server central website and see what others who have faced similar problems recommend examining" show a readiness to learn new techniques...