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.

Combine Insert and Select into one call?? But of course - all the time. It's nothing new.

We've been doing that in ASP.NET ever since 2005 when we started working with...

I would get a windows group created with these users in it and then give that group read only permissions on the cube. I give the cube permissions via management...

A regular theme for fancy dress night at sailing national championships is to dress as the name of your boat. If we ever go I plan to dress as Sir...

It's so automatic that I had to think hard as to whether I'm mis-reading something in your post, but this is what we do to deploy reports.

We set up project...