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

June 13, 2010 by John Sansom Leave a 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.

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

SQL Server Links

  • Rebuilding system databases in 2008 R2 – Apparently it can’t be done at this time so ensure you have a file level backup.
  • SQL University – HA/DR Week – This weeks lesson at the SQL University brings clarity to two often misunderstood concepts in database technology. Make sure you understand the difference and can educate others in your workplace of the same. I see this confusion a lot and it’s important the distinction is made for the safety of your data.
  • Purging Data – Nice write up here from Bart Duncan that presents a walk-through of the various methods available to your for Deleting data efficiently.
  • Reporting Services, Scale Out and Clusters… – Some good advice and technical info here from the SQL Server CAT (Customer Advisory Team).
  • Sargability: Why %string% Is Slow – A clearly presented walk through here courtesy of Brent Ozar.
  • SQL Server 2008 R2 Standard Supports Less Memory – An interesting observation here.
  • What is a good way to run CHECKDB on a very large database?
  • Optimising wildcard prefixed LIKE conditions – A good query performance tuning article here from AdaTheDev.
  • Whitepaper on high-availability architectures published – Looking forward to getting stuck into this…

SQL Server Upcoming Events

  • SQL Server Master Class – 17th June – Paul Randal and Kimberly Tripp are coming over to the UK! I can’t wait for this and I will be bringing a few chums from work along too.
  • SQLCruise – 2nd August – This will be awesome!
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

I want to hear about your iPad experiences. Have you bought one and what version? Are you pleased with your purchase? Let me know…..

  • ITV HD viewers miss England’s first World Cup goal – Seriously, this is a big deal for us Brits!
  • US debates its broadband future

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