• 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 29/01/10

January 30, 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

  • XML Validation in SQL Server Intergration Services – A nice walkthrough here from Simon Sabin.
  • SQL Azure Frequently Asked Questions – So what’s this SQL Azure all about then? Brent Ozar answers the most frequently asked questions about this young technology.
  • Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency – Some indepth SQL Server technical discussions here from the SQL Server Storage Engine team.
  • DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 – As the title describes, the legend that is Paul Randal notifies us of this latest bug fix.
  • Benchmarking: 1-TB table population (part 1: the baseline) – Awesome first installment to this series of intricately detailed performance analysis from Paul Randal.
  • Tuning ‘cost threshold for parallelism’ from the Plan Cache – Interesting discussion here from Jonathan Kehayias about consistently producing a parallel query plan.
  • Changes to sp_estimate_data_compression_savings stored procedure in SQL2008R2 – Another great contribution from those clever chaps in the SQL Server Storage Engine Team.
  • SQL Server – Find the most expensive operations in Execution plans – Now this is cool! I will be adding this my collection of handy DBA scripts.
  • Setting a Dedicated Login To Run DMV Queries in SQL Server 20052008 – Frustrated with permissions required to access SQL Server DMV’s. Check out Glenn Berry‘s solutions to your woes.
  • Index Defrag Script Updates – Beta Testers Needed – Michell Ufford – Needs you!
  • Cross Apply – What is it and how does it work. SQL Agent Man reveals all.
  • Question: Is NT AUTHORITYSYSTEM a sysadmin in your SQL Server and Why? – A very interesting question posed by Jonathan Kehayias here. Have you removed yours?

Misc Technology News

  • Apple Unveils iPad Tablet device – BBC news coverage. Really unexcited about this. Will it be on your Christmas list this year?
  • Windows 7 upgrades Vista laptops to lower battery life – “I can-ne find the power captain!”
  • Russia Tests Stealth Fighter Jet – More BBC News coverage. Is it just me or does this video look fake?
  • How secure are virtual desktops, really? – With the increasing uptake of virtualisation technologies, how much thought have you given to their security?

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 Tagged With: Events

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
  • Script SQL Server Agent Jobs Using PowerShell
  • 10 Character Traits of Outstanding DBA’s
  • SQL Server Memory Configuration, Determining MemToLeave Settings

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 © 2021 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy