• 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 05/02/10

February 7, 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

  • Looking at Page Contents – A little code template here from Michael J Swart.
  • Why You Might Want to Buy SQL Server 2008 Now – Brent Ozar explains why you may want to look into SQL Server 2008 now in order to minimise longer term costs to your business.
  • Searching for Objects or Text Strings Using SQL Search
  • Removing Columns – Now this is why I just love working with SQL Server, you really can learn something new each day. Did you know that removing a column from a table does not reclaim the space? Michael J Swart (Database Whisperer) reveals all.
  • Script: open transactions with text and plans – Nice T-SQL script here from Paul Randal that identifies who currently has open transactions on the server.
  • Performance improvement by orders of magnitude when merging partitions in SQL Server 2008R2 – A nice technical blog post here from the SQL Server Storage team.
  • Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008 – A tale of Troubleshooting here from Glenn Berry including a couple of nice queries.
  • Three Engine Improvements in SQL Server 2008 R2 – So by now you probably all know that SQL Server 2008 R2 is for the most part all about Business Intelligence and feature integration with Microsoft Office. Sigh…..That’s nice but what about the SQL Server Storage engine? Read this post from Glenn Berry to find out more.
  • SQL Search – a review – Here’s a nice review of the new FREE utility from those clever folk at RedGate.
  • Using Union All to simplify Lookup Component code – Here’s a nice little SSIS tip.

Misc Technology News

  • Microsoft to patch 17-year-old computer bug
  • US Department of Justice objects to Google book plan
  • Juniper bakes 250Gbps core router chip
  • MS hits Office 2010 upgrade program button prematurely

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