• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

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

July 8, 2011 by John Sansom Leave a Comment

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

  • SaveToSQLServer method error | Communication Link Failure – Another interesting tip this week from Pradeep Adiga (Blog|Twitter). I really love these tips that Pradeep shares because it helps us DBAs to broaden our troubleshooting experience to cover issues that we may have yet to see for ourselves.
  • Undocumented Query Plans: The ANY Aggregate – Paul White (Blog|Twitter) walks us through.
  • Survey results on rebooting – is it good or bad? – This weeks survey results are in from Paul Randal (Blog|Twitter). What’ interesting this week are the reasons other’s give for “needing” to perform a reboot.
  • What Do You Think are the Most Common DBA Pain Points? – An invitation this week from Brad McGehee (Blog|Twitter) to share your woes. Ah where shall I begin Brad, where shall I begin. Be sure to add your thoughts and read the comments to see what other DBAs had to say.
  • New whitepapers on latches and spinlocks published – Two excellent whitepapers from the SQLCAT team looking at latches and spinlocks with regard to performance tuning, shared via Paul Randal (Blog|Twitter).
  • Make Your Life Easier With Fun Denali Tricks – I’m all about making life easier and so this weeks post from Michael J. Swart (Blog|Twitter) is a welcome treat of some things we have to look forward to in Denali.
  • Converting OR to Union – Gail Shaw (Blog|Twitter) highlights the importance of knowing your data to avoid some pitfalls when performing this tuning technique.
  • Bitmap Magic – This weeks post title from Paul White (Blog|Twitter) sounds like a bad Take That song but it’s actually a brilliant look at some SQL Server internals.
  • Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2 – I’m consistently blown away by the amount of effort that goes into some of content produced by the community. Another impressive technical post from Wes Brown (Blog|Twitter).

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

  • Facebook adds Skype video chat
  • Deep inside AMD’s master plan to topple Intel
  • Printer produces personalised 3D chocolate
  • Nice try, Amazon: ‘One-click’ payment too obvious to patent

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).

Filed Under: Administration, Link Posts

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy