John Sansom – SQL Server DBA in the UK Rotating Header Image

Posts from ‘July, 2009’

Something for the weekend 31/07/09

Have you had a good week?
This past week has been both horrendously busy and challenging for me, although strangely I actually enjoyed it and  dare I say, I quite like it that way. There is just something about getting stuck into tough projects that brings out the best in us DBA’s and challenges us to [...]

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model

In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility.
Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of your [...]

Something for the weekend 24/07/09

There’s been a lot of banter and hype in the SQL Server community this week about the upcoming PASS Summit. Bloggers and Tweeters alike have been sharing their thoughts on which pre-conferences to attend, organising post conference social events and exchanging tips on networking.
If you’re not one of the lucky attendees this year then you [...]

Win an all expenses paid trip to PASS 2009!

If you are like me and absolutely gutted that you cannot attend the PASS 2009 summit, then this could be just the ticket that you have been waiting for.
Understandably if you live/work on the other side of the globe it is not exactly the most practical of away fixtures to attend and getting sign off [...]

SQL Server Essentials – Part 1: The Database Administrator’s Primary Responsibility

You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which [...]

Something for the Weekend 17/07/09

Another week has zoomed by again and so it’s time for you to kick back, relax and enjoy some the best SQL Server content on offer this past week.
SQL Server Links
VLDBs and Instant File Initialization – In this podcast, Brent Ozar talks about a simple problem: managing file growth when your files are hundreds of [...]

Something for the weekend 10/07/09

What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on [...]

SQL Server Reporting Services Tip: email subscription tweak

What’s the problem?
How to configure SQL Server Reporting Services 2005 to permit users to assign the delivery email address for their own subscriptions.
Why does SQL Server work this way?
When you subscribe to a report, the e-mail delivery settings you work with vary depending on whether your Role includes the “Manage individual subscriptions” task or the [...]

SQL Server Guru Challenge – confirmation of entry

This is just a quick update to let you all know that I have released confirmation of the successful entrants to the SQL Server Guru Challenge, so far. The league table can be found here however, everyone who has qualified so far has answered all questions correctly which means there is nothing to separate all [...]

Top 5 SQL Server Forums

As you no doubt already know, there is a ridiculously large amount of SQL Server Information available out there on the internet. Whether you’re browsing forums, web sites or blogs, knowing what the best sources of SQL Server information are and more importantly which one’s you can trust, can be tricky.
So to help you get [...]