I'll only take on freelance work if I'm certain I can do the job. If there's any areas I feel I'm weak on then generally I'll let the client...

If you have a process logging in as sa, then for pre-2012 versions you'll be able to lift the sa password from the Win32 MSSQLSERVER (or your named instance) memory...

Thank you, the timing for this couldn't have been better as I'm looking into Powershell now, it's an area I've been avoiding too busy to concentrate on 🙂 Thanks...

What method are you using to load the data from the CSV files to your table?

Call me arrogant but if an interviewer asked me questions which were designed to trick me, or were utterly stupid in themselves, or that were designed to be unanswerable, I...

Please review the information in http://msdn.microsoft.com/en-us/library/ms345117(v=sql.90).aspx, it provides a good introduction to XML and SQL Server. By following the links you'll be able to see examples of importing XML...

It sounds like a custom job application technical test, are you able to post the job description for the role you're applying for please? That may shed some light...

Andy - Brent's script is a good one but the OP should be warned it isn't a catch-all. I used this script once, took note of the recommendations and...

I'm afraid I have no idea, I'm not a server admin.

Alerts here -> http://msdn.microsoft.com/en-us/library/ms180982.aspx

Replication here -> http://msdn.microsoft.com/en-us/library/ms151198.aspx

Replication with alerts here -> http://technet.microsoft.com/en-us/library/ms151752.aspx

and here -> http://msdn.microsoft.com/en-us/library/aa237180(v=sql.80).aspx

and here -> http://www.mssqltips.com/sqlservertip/1901/customized-alerts-for-sql-server-transactional-replication/

Hope this helps.

There isn't a catch-all script, this is something you would normally manage yourself. I use a collection of scripts, some of which I wrote, some I didn't - automatic...

The transaction log will be kept in check by a regular full backup schedule. If you're using a full recovery model, you should be prepared for a greater transaction...

This sounds like a bounceback from your mail server, check with your sys admins that you can send e-mail to an external domain.

I'm a bit of an SSIS n00b but I'm okay with temporary tables, so you'll have to excuse me if I'm totally wrong - but I believe your problem might...

Answer is wrong, last query returns an error. Point refund please, my good sir!