As an IT pro and graduate, I've been involved in the recruitment of programmers and the very first requirement on the job spec. is a degree or HND or equivalent...

If copying a scheduled job, delete the line that begins "@schedule_uid= " and the preceeding comma as it can't create two schedules with the same id.

If it's for backups, have...

It works both ways - my job title is DBA but as well as managing the backups/restores, databases and security and query tuning etcI also do BI development, loads of...

Could you try getting management help to introduce some new tools or even just new tricks for the devs with the selling pitch that these are going to speed up...

I was doing some tuning on a database a couple of days ago and added indexes as there were none. Came back the next day and they'd vanished!

The developers'...

We do lots of csv import and have found that | isn't a good delimiter character as it can easily be mistyped into data when hitting the shift key or...

We do this on two or three systems - backup live between 6pm and midnight then restore that backup to test server from 4a.m. onwards. It's a good way of...

I would go for a separate database for each customer every time for security reasons.

Most customers do not want anyone else (and especially competitors) seeing their data and even...

My general rough rule and first setting on a new server is to set it so sql server max memory is 75% of the total available memory. Then see how...

My general rough rule and first setting on a new server is to set it so sql server max memory is 75% of the total available memory. Then see how...

Personally I would tell your managers that there's no point in you being there if the developers insist on continuing these diabolical practices and either you get the management support...

Of the 25 main sql servers I work with only 5 are physical and they are all production servers. Dev and Test are 100% virtual.

File and print servers are...

Another free ebook that may be useful is The Accidental DBA

If you are using Ola Hallengren scripts that's a good sign that backups are in place, but make sure that...

I suggest sending a copy of Brad McGhee's Maintenance Plan book https://www.simple-talk.com/books/sql-books/brads-sure-guide-to-sql-server-maintenance-plans/[/url] to each and every DBA in that team, especially the manager!

Or any other recommended book on Maintenance...

As someone who attended launch events for SQL 2005 I can only say that ten years is too short a life for a product from a business perspective. It takes...