• 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 13/08/10

August 13, 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.

  • Check out the recently added Popular Posts section to find out what content visitors to this site enjoy the most.
  • Don’t forget to have a go at this weeksSQL Server Crossword.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

  • Index Tuning Advisors – Some vendor bashing and a reminder to not treat the DTA results as gospel here from Thomas LaRock.
  • New Disaster Recovery option for Peer-2-Peer (P2P) Replication in SQL 2008 – An interesting feature change to how Peer-2-Peer Replication behaves in SQL Server 2008.
  • Iterators, Query Plans, and Why They Run Backwards – An intriguing look at some query plan specifics here from Paul White.
  • Passing a TABLE variable into dynamic SQL – A T-SQL coding tip from Adrian Hills (@AdaTheDev)
  • Vardecimal storage format and upgrade to SQL2008 RTM or SQL2008R2 – Useful knowledge, shared by the SQL Server Storage Engine Team via their blog.
  • Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details) – The next instalment of Paul Randal’s excellent series on performance benchmark testing SSD’s.
  • Finding SQL Agent Jobs Owned By The Wrong Person – A nice T-SQL tip for DBA’s here, courtesy of Jeremiah Peschka.
  • Conor vs. Misbehaving Parameterized Queries + OPTIMIZE FOR hints – I really enjoy reading Conor Cunningham’s posts on the Query Processor but I know that some readers may find the content tough going. It’s incredibly valuable content if you can understand it.  I suggest that if you’re struggling go and read SQL Server 2008 Internals to get you started.
  • Microsoft announces SQL Server Migration Assistant for MySQL – Could prove very interesting. I’d be very interested to hear from anyone who has played around with this.
  • Introducing sp_CascadingDataViewer – A nifty little utility Stored Procedure here from Jamie Thomson.
  • The Impact of Non-Updating Updates – Here’s this weeks second contribution from Paul White and great work once again.

SQL Server Upcoming Events

  • UK SQL Server Usergroups
    • Kent – 18th August – This is a new SQL Server Usergroup.
    • 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 – Agenda to be confirmed
  • 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

  • What’s On Your Utility Belt? – If it’s good enough for Batman right.
  • How I Use My iPad for Business – So it is possible to do business on the iPad but with the number of quality games that are just a click away I think I will have to steer clear.

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 emailor 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