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

July 10, 2009 by John Sansom Leave a Comment

What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on all the weeks goodies.

So without further ado here is my weekly roundup of the action for you to get stuck into.

SQL Server Links

Understanding the VAS Reservation (aka MemToLeave) in SQL Server – Jonathan has put together a fantastic and detailed discussion of VAS (Virtual Address Space) reserveration in SQL Server. Grab a coffee before you get started though ;-) there’s a lot to get your head round here.

Renaming Your MS SQL 2008 Database – Thomas La Rock tells of his early days as a SQL Server padowan and how he tackled this problem we’ve all had to work on at some point.

How to Create a Server-Side Trace with SQL Profiler – Jorge Segarra provides this excellent walkthrough.

5 Common Mistakes with Tempdb – Short, simple and good points to be aware of. Courtesy of Strate SQL.

Clone Database – This is very cool! You can take a meta data copy of your database and use it as a clone to generate estimated execution plans without the overhead of all the table data. For example, you can use this technique to see how your database query plans will be effected by new server hardware setup.

Top 10 SQL Server Connect Items by votes – Michael Swart blogs on his findings researching popular SQL Server Connect items.

So You Want To Learn Business Intelligence – Aaron Alton posts the second installment of his adventures into the world of Business Intelligence with SQL Server.

Misc Techie Stuff

Scaling up vs. Scaling out – Jasson Massie gives his take on Jeff Atwood’s recent blog post of the same topic.

Death of the IT Professional? – The British Computer Society (BCS) published an e-article speculating on the future of the IT professional. Thought provoking stuff.

Stunt Car Drivers and Eggs Benedict – Slightly off beat post about end user experience by Brent Ozar

My Random Pick of the Week

Random Posts

TechCrunch dubs Linux a ‘big ol’ bag of drivers -Brilliant humourus discussion about the recent google announcement to provide an operating system for netbooks.

That’s it for this week. If I’ve missed anything that you think is worth mentioning then be sure to let me know. Fire me an email or a tweet on Twitter.

Have a great weekend.

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