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

I have to ask why should these events be totally free? Most people would be happy to pay a fiver or tenner (UK) which would cover the hire of a...

OCTom (12/11/2014)

---

As professionals I believe we should recognize citizen programmers and offer to mentor them in proper techniques. I have done this several times with good results. One thing you...

I strongly believe that in a business that markets itself as professional, the end users should stick to being end users and query and report from data but not try...

we do this using either the Ola Hallengren job or a TSQL Backup command in the first step and a second step of type Operating system (cmdexec) which reads

xcopy "\\server\drive\*.*"...

We've got plenty of work to do but the hardest part is blanking out the idle chatter in the office from those who have a bit less to do because...

No, BIDS only needs to...

Just to clarify:

Integration services needs to be installed on one sql server where the packages will be run

That integration services can connect to databases on other sql servers or to...

Best thing that has happenned to my T-SQL coding in years was going on Itzik Ben-Gan's Advanced T-SQL course eighteen months ago.

As a result I got my head around...

The nearest I've got to changing people's lives (and the nearest I ever want to get) is supplying the data that told the business that lots of workshop mechanics were...

Try putting

USE Master

Go

before your "restore database" statement - you've probably got management studio pointing at the database you're trying to restore - it's a common slip up.