Something for the Weekend – SQL Server Links 08/07/11

I hope you’ve had a great week!

Make sure you catch all my posts by Subscribing to the Blog Feed. You can also receive posts via Email.

This week I had the opportunity to work on an interesting SQL Server reporting solution. The environment in question was using a combination of Database Mirroring and Database Snapshots in order to offload reporting from the Principle database/server. The Snapshot was being refreshed every 10 minutes however the refresh cycle was experiencing delay (for a variety of reasons) during which time user connectivity was unavailable to the Snapshot because it essentially did not exist. Rather than go into more details here (I’ll save those for a separate post) I’ll skip straight to the solution, which was to create a pointer database using Synonyms to reference the most recent Snapshot. This permitted the switch between Snapshots to be transparent to the connections of the reporting application. I developed the solution by building upon something similar from a post written by the SQLCAT team. I extended/modified the code in order to support Database Mirroring. I’ll be sure to share the details of how I did this with you in a future post but for now I thought I would bring the post by SQLCAT your attention. I had not seen or considered this type of solution previously and so thought it may be of interest to you too.

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

UK SQL Server Upcoming Events

Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

  • CARDIFF – Thu Jul 14 – Cardiff User Group. Agenda TBA
  • LONDON – Fri 15 Jul – SQL in the City
  • LEEDS – Wed 20 Jul – Leeds UG meeting with Steve Powell
  • LONDON – Wed 20 Jul – User Group Meeting with Neil Hambly, Alex Whittles, Avanade
  • MANCHESTER – Thu 21 Jul – Manchester UG meeting at BSS with Jen Stirrup and Nicholas Colebourn

Misc Technology Posts

That’s it for this week. What was your favourite post? If I’ve missed a post from the week that you think should have made the cut then don’t forever hold your silence, share it via the comments or Twitter(@JohnSansom).