• 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 16/07/10

July 16, 2010 by John Sansom 3 Comments

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.

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

SQL Server Links

  • Benchmarking: Introducing SSDs (Part 2: sequential inserts) – Here’s Part 2 of this excellent benchmarking series from Paul Randal. What I want to know is what are the life expectancy of these SSD’s?
  • Using “Verbose history agent profile.” while troubleshooting Replication – I’m always getting my hands dirty with Replication and any pointers on troubleshooting are very welcome indeed. Here’s some great advice from Microsoft Replication blog team.
  • Top ten mistakes to make when attending a class – Thinking of attending a SQL Server class? Here’s what not to do when you’re there.
  • Sampling can produce less accurate statistics if the data is not evenly distributed – An interesting customer case working with statistics here from the Microsoft CSS Team.
  • Ors belong in Boats, Not Where Clauses – A nice real world example from Jim McLeod that shows how using Dynamic SQL can in the right circumstance provide superior performing solution.
  • The Future of Databases – Brilliant article from Jeremiah Peschka. Very well written, detailed and thought provoking.
  • I CAN HAZ JOB – A non technical post but instead a great piece of SQL Server community inspiration. Oh and congratulations Tim!
  • Why is my SQL Clustered Instance changing authentication modes? – Very interesting walk through detailing how the Microsoft CSS team solved this customers case. Provides a nice insight into some interesting internals to SQL Clustering.
  • How Can I Quickly Script Out Replication? – I’m always on the look out for ways to save time and that’s why I love PowerShell. Check out this handy tip from David Levy.
  • Side-By-Side Installations – What gets changed? – Buck Woody reveals all.

SQL Server Upcoming Events

  • SQLCruise – 2nd August
  • UK SQL Server Usergroups
    • Leeds – July 20th – AGI Northern Group meeting: Using geospatial data in the Microsoft world.
    • Manchester – 5th August – Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008.
    • 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.
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

  • Apple fixes one iPhone bug as another appears
  • Search engine Bing gains market share
  • Google profits up sharply but fail to impress

Stuck for ideas what to do this weekend? I’m off to see the new movie Inception. The trailer looks awesome!

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