• 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 for the week 20/08/10

August 22, 2010 by John Sansom 1 Comment

I hope you’ve had a great week!

Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.

Congratulations to Tracey Hamlin(@tracyhhamlin), Winner of the 2010 Exceptional DBA of the Year Award!

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

SQL Server Links

  • Taking A Hint – A fantastic in depth article, courtesy of Brad Schulz, that walks the reader through a real world performance tuning scenario utilising Query Hints.
  • How to change the SQL Replication Agent History Cleanup Job – A simple but important tip here, especially if you are administering high throughput OLTP topologies, courtesy of the Microsoft Replication Team Blog,
  • Proper Usage of MAXDOP Setting When Compressing Indexes in SQL Server 2008/2008 R2 – Discussed here by Glenn Berry.
  • This Blog Post Won’t Explain Anything –  There’s been a lot of discussion regarding the PASS Directors nominations and the selection process involved. Thomas Larock provides his thoughts here.
  • Thoughts On The 2010 PASS BoD Elections Candidate List – Kendal Van Dyke shares his thoughts on recent events.
  • How To Find Duplicate Indexes – This is a powerful and often overlooked performance optimization opportunity. Find out how you can benefit from it using this excellent walk-through with example code, brought to you by Thomas Larock.
  • How Do You Defragment Your SQL Server Indexes – Continuing the performance optimization theme, here are some interesting results of a Survey carried out by Brag McGehee, providing insight into how other SQL Server data professionals are administering the indexes in their environments.
  • Integer List Splitting: A SQL Fable – Another great post, again coming to you from Brad Schulz.
  • How to Performance Tune a VLDB on your Desktop – A discussion into some uses for SQL Virtual Restore, a relatively new product offering from RedGate.

SQL Server Upcoming Events

  • UK SQL Server Usergroups
    • Bracknell – 17th September – SQL Server CLR and T-SQL Functions – Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) – Neil Hambly
    • Leeds – 15th September – Using XML data in SQL Server with Anthony Brown, and Martin Bell explores change management in SQL Server 2008 and Iain Kicks from Quest Software.
    • Manchester – 16th September – User group evening with Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
    • Cardiff – 23rd Septemeber – Chris Testa O’Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products.
    • Edinburgh – 7th October – Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell).
    • Leeds – 27th October – User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey.
    • Manchester – 28th October – SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008.
  • SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL. Pricing
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

  • PlayStation 3 ‘hacked’ by hardware crackers
  • Ofcom report highlights ‘multi-tasking media users’ – Interesting to see how users now regularly consume multiple media streams in parallel.

That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! You can leave a comment below, send me an email or message me on Twitter(@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