• 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 23/04/10

April 24, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week!

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

SQL Server Links

  • SQL Server DBA Telecommuting Tips – Some good tips here for those Database Professionals that work remotely.
  • FILESTREAM storage, garbage collection, and more – Continuing with his excellent blog post series, Paul Randal dismisses yet more myths this week.
    • A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged
    • A SQL Server DBA myth a day: (22/30) resource governor allows IO governing
  • index-defrag-script-v4 – Here at last, it’s version 4 of the worlds best SQL Server Index Defrag Script, well at least I think so! This update has been a long time coming, as SQLFool herself points out but at least she has a good excuse for being busy! I was drafted to help out with the testing of this version of the procedure but failed to deliver with no excuse other than I’m just rubbish. Congratulations by the way Michelle!
  • An Introduction to SQL Server 2008 Change Data Capture – Learn the basics of this SQL Server feature courtesy of Brad McGeHee.
  • Europe PASS, a volcano, Live Meeting, and SQL 2008 R2 BPA…. – Check out the new Best Practice Analyzer for SQL Server 2008 R2.
  • Sometimes the grass is greener… – Yeah right.
  • When are Statistics Updated – What triggers Statistics to Update – This week, Pinal Dave has been taking a closer look at statistics.

SQL Bits

  • The SQLBits VI Experience – I had the pleasure of meeting with Adrian(@AdaTheDev) at this awesome event. Here’s his thoughts on the day.
  • SQLBits VI – Here’s fatherjack’s take on the days events.

SQL Server Upcoming Events

  • 24 Hours of PASS 2010 – 19th May, Global.
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

If there is an upcoming SQL Server event that I’ve not included?

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 contact me on Twitter.

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