And if anyone's up for a bit of light reading I've captured the output by running snapshot.exe in the command prompt and logging at outputverboselevel 2 (you can see the...

Really good article Warren!

I, like you, have recently discovered the joys of Powershell and how it can make the life of a DBA easier by automating daily checks. I've...

I've only just looked at this question and like so many before me would like my point for getting the right answer (only to be told I was wrong). ...

Thanks Logan,

It's not so much of a concern, although I do think it is peculiar behaviour - particularly when I have several other SQL instances behaving as I would like.

The...

Thanks Jack - I really appreciate the effort you've put into this!

I've run the traces myself when going to look at the shrink options for the database and files. ...

Hi Jack,

Thanks for the response. I'm afraid there's only 1 data file for the tempdb databases affected. Here's the output of your query run against one of the...

But just think how great a nation you could have been if you'd stayed with us! 😉

Only joking - it seems you've done alright for yourselves!

Happy Independence Day!!

I should probably add that it's not my intention to be rude or to put people off from...

No! Don't put it in to...

Hmmm tricky one. Do I want enhancements made to the product that could potentially do me out of a job/career, but that could be of real benefit in the...

I've had to interview for DBA positions in the past and I've looked to quiz my interviewees on some basic DBA concepts, such as backup and restores or performance troubleshooting....

I've been a great supporter of allowing my staff time in work to read and develop their knowlegde. As long as it's relevant to their job, I invariably benefit...

Interesting article Andy, thanks! Interesting in the sense that the organisation I work for is currently looking at developing a BI solution, and the approach that's being taken by...

The security issues are that you have to poke a hole in your firewall for ports 1433 (default for SQL Server) and port 80 (default for HTTP). Both of...

Well I couldn't get the FTP side of things to work so I had to go for an alternative. If anyone's interested (or is suffering with similar problems) I...