I agree and last year started a SharePoint Wiki where we can put such nuggets of information about the tools of our trade (SQLServer including SSIS, SSAS and SSRS ,...

SQLBill - as I said above, they already have sql agent operator role (the highest level). Without sysadmin permissions it doesn't do the job.

Thanks - they've got their sandbox and got sa on that. Normally I would insist we migrate to live, but there's politics and history to this lot from companies amalgamating...

When people tell me they have spreadsheets they want importing into sql, I usually ask them if they can supply it as csv because it saves any problems with differences...

There's never enough holiday - even if you can find time to take it!

I grew up with Potters fortnight as our local holiday and then there's Wakes weeks and...

We use Express edition for some small bought in applications but the big issue is that it doesn't have sql agent so we have to rely on backupexec for backups...

When SQL Server is installed (2008 anyway) it creates some local windows groups with names like SQLServerSQLAgentUser$Myserver$MSSQLSERVER and you'll see they have descriptions such as "Members in the group have...

Anything we purchased individually wouldn't be allowed onto the corporate network and own laptops, tablets etc aren't allowed either.

However if we can justify a tool or resource and it's...

Adding to all the above, make sure I've an accessible but secure location to store my library of SQL scripts (every DBA should have one) and get them onto the...

I'd like to work on the data and databases feeding the handicapping system for sailing. Clubs return race times for all the different types of boats and these are analysed...

I know where I want to land, but I'm still having to work towards it - into a happy retirement with enough money for a comfortable lifestyle and not having...

I found this guidance many years ago but can't find a link so here's the text:

Guidance on recording valid postcodes

The postcode is a combination of between five and seven letters/numbers...

Print etc as others but I've fallen in love with CTEs (Common Table Expressions) and use them a lot now, especially to build up complex queries or those with running...

Vernon Jimmerson-306463 (7/20/2010)

---

(using a friendly positive tone with a little smart *** worked in!)

Or if they've had to deal with it for 15 years! There a thing...

The server team here think the same way as your boss. They moan all the time about the space needed for sql backups and the log backups in the day...