• 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 17/06/11

June 17, 2011 by John Sansom 1 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.

One of drawbacks to a Blog site layout is that it can be easy for good content to get buried and go unnoticed. I try to get around this by keeping the Popular Posts section up to date, highlighting both the last months most popular content alongside my all time most popular posts. What about all the stuff in between though? Well I’ve now simplified and organized all my post categories, which you can see on the right hand menu widget on the blog. I hope this will improve your experience of the site and maybe even introduce you to some content you’ve yet to enjoy.

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

SQL Server Links

  • Non use of persisted data – Discoveries from a recent client engagement, Dave Ballantyne (Blog|Twitter) demonstrates how a persisted column may not always be chosen by the optimizer.
  • T-SQL Script for Estimating Compression Savings – A handy T-SQL script shared courtesy of Michelle Ufford(Blog|Twitter).
  • SQL Server and Soft NUMA – Jonathan Kehayias (Blog|Twitter) continues his excellent post series on NUMA technology and it’s application within SQL Server.
  • T-SQL Tuesday #19 – Beyond Backups – Talking on this months theme it’s Robert L. Davis(Blog|Twitter).
  • Dipping My Toes Into SQL Azure – Part 2 – Protection Mechanisms – CSS SQL Server Engineers (Blog)
  • Resolving Conflicts in the Database – The Replication technology debate is up for discussion this week by Jeremiah Peschka (Blog|Twitter). Replication can be an awesome technology but it must be integrated with the complete application platform design in order to ensure you don’t run into trouble.
  • Rebind and Rewind in Execution Plans – I’m sure you’ve seen these mentioned in your execution plans but do you know what they actually mean? Grant Fritchey (Blog|Twitter) explains.
  • Rankings Updated – Updating his very own chart of the Top SQL Server bloggers in our community, it’s Thomas Larock (Blog|Twitter). This is a great resource to find out which SQL Server bloggers you should be following.
  • Enforcing Business Rules Vs. Avoiding Triggers: Which Is Better? – The business logic debate continues, Michael J. Swart (Blog|Twitter) discusses.
  • You Probably Already Have a “Private Cloud” – This week Buck Woody (Blog|Twitter) proclaims that many of us are in fact already leveraging the power of the Cloud and that we may not know it just yet.
  • Service Broker, not ETL – An interesting discussion of a recent customer project with a difference, that Jamie Thomson(Blog|Twitter) worked on.

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.

  • LONDON – Mon 20 Jun – Multi Day Seminar – SQLskills Immersion Event on Internals and Performance – 5 day event 20th June – 25th June
    • Tue 21 Jun – SQLskills hosts in London: Tips for Query Tuning with SQL Sentry Plan Explorer and More!
    • Wed 22 Jun – Fusion-io will present: SQL at the speed of FLASH
  • LONDON – Tue Jun 21 – London UG meeting on BI topics including spatial data support & other topic (TBC)
  • EDINBURGH – Thu 23 Jun – Scottish Area User Group Meeting
  • READING – 27 – 28 June – Microsoft Business Intelligence – Discover SQL Server “Denali” with SSAS (Days 1-2)
  • KENT – Tue 5 July – A  SqlServer focused event with not one but two sql server MVPs. Tony Rogerson & Chris Testa-O’Neill
  • SOUTHAMPTON – Wed Jul 6 – SQL User group evening of Matt Whitfield (@atlantis_uk) and Alex Whittles (@PurpleFrogSys)
  • CARDIFF – Thu Jul 14 – Cardiff User Group. Agenda TBA
  • LONDON – Fri 15 Jul – SQL in the City
  • LONDON – September 12 – 14 – Advanced SQL Server Troubleshooting Workshop

Misc Technology Posts

  • LulzSec hackers claim CIA website shutdown
  • Man says he lost $500,000 in virtual currency heist
  • Facebook denies losing users

That’s it for this week. What was your favourite post? If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me onTwitter(@JohnSansom).

Filed Under: Link Posts, SQL Server Community

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