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

January 17, 2010 by John Sansom 2 Comments

I hope you’ve had a great week.

Have you got what it takes to be a SQL Server DBA or are you looking for that new SQL Server role? Be sure not to miss my Top 10 Junior DBA Interview Tips.

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

SQL Server Links

  • IN vs INNER JOIN – I had been under the impression that Gail Shaw would be taking a respite from Blogging. I for one am sure glad this appears not to be the case as here’s another excellent blog post from her.
  • Knowing and not Knowing – Although not SQL Server specific this excellent post from Jeremiah Peschka discusses an important concept required in order to be a successful DBA.
  • User defined function performance is awful, Microsoft please sort this out
  • Fooling the Query Optimizer – An interesting little peek here at the inner working of the query optimizer from Ben Nevarez.
  • Free eBook on SQL Server Maintenance Plans – Get yourself a copy. Sure you may think you know all there is know about maintenance plans but it’s free right!
  • SQL Server – How many times is the subquery executed? – An interesting snippet here at how subqueries do not always work as you might expect.
  • Adding a PK online? – Can this even be done? Take a look at this blog post from Tibor Karaszi to find out.
  • Is there and overhead to RPC events? – A fantastically insightful and detailed analysis, including walk through.
  • Finding Implicit Column Conversions in the Plan Cache – Brilliant SQL Snippet here.
  • The Database Design Process – Buck Woody tells us how he goes about the process.
  • Learn Free at SQLLunch – FREE SQL Server Training! Find out how you can make the most of your lunch, snacks not included.
  • How to Use SQL Backup Inside a Maintenance Plan – Fantastic little tip here that can be applied to any 3rd Party Database Backup Utility.

Misc Technology News

  • German government warns against using MS Explorer
  • Kodak sues Apple and RIM over iPhone and Blackberry

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