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

July 9, 2010 by John Sansom 1 Comment

I hope you’ve had a great week!

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

SQL Server Links

  • Using a UDF as a SARG. Make a hash of it! – Query optimization post.
  • One Size Mostly Fits All – Thom LaRock talks fashion and general purpose database servers.
  • Comparing the Performance of Different String Data Types in SQL Server 2008 R2 – An excellent walk-through by example here from Glenn Berry
  • Linked Server Query Running Slow? – Here’s an account of a recent problem and it’s solution courtesy of Mike Walsh.
  • Why doesn’t SQL Server use statistics and index on this computed column? – This weeks instalment from the SQL Server Customer Service and Support (CSS) Engineers.
  • The Effects of Dropping a Database on the Proc Cache – Find out here with Jim McLeod.
  • Bug in SQL 2008: Why you shouldn’t create large tables in the Model Database – Discussed by Jonathan Kehayias.
  • SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan – Great tip here from Pinal Dave. It’s simple but often overlooked.
  • Are we there yet? – Here is a professional development/motivational piece from Janice Lee who is a relatively new blogger on the scene that has caught my attention with some great content.

SQL Server Upcoming Events

  • SQLCruise – 2nd August
  • UK SQL Server Usergroups
    • London – 14th July – SQL Server and Disk IO (File Groups/Files, SSD’s, Fusion-IO, In-RAM DB’s, Fragmentation)
    • Leeds – July 20th – AGI Northern Group meeting: Using geospatial data in the Microsoft world.
    • Manchester – 5th August – Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008.
    • Kent – 18th August – This is a new SQL Server Usergroup.
    • Leeds – 15th September – Using XML data in SQL Server with Anthony Brown, and Martin Bell explores change management in SQL Server 2008 and Iain Kicks from Quest Software.
  • SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL.
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

  • Google’s Street View ‘snoops’ on Congress members
  • Solar-powered plane lands safely after 26-hour flight
  • Android slurps market share from Apple, RIM, Microsoft

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! Leave a comment below, send me an email or message me on Twitter(@JohnSansom).

Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.

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