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

January 2, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week.

Here’s this weeks, smaller than usual due to the Holidays, roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

  • sp_db_space_usage – A very nice stored procedure from Tibor Karaszi for reporting database size details.
  • Getting the ISO Week and Year – Handy little function here with some reporting panache.
  • A Small Collection of I/O Specific DMV Queries – Another fantastic contribution from Glenn Berry. I’m a big fan of DMV’s and will certainly be putting these queries to good use.
  • Fun With DBCC FREEPROCCACHE – Are DBA’s perhaps overly cautious about using this DBCC statement?
  • How To Get a Count of SQL Connections BY IP Address – A nice little DMV query here, courtesy of Glenn Berry.
  • Got a slow holiday seaons? Why not spend it learning? – Some ideas and tips on how to make the most of your free time this holiday season from Kevin Kline.

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. Happy New Year!

Get your SQL SQL Server Questions Answered!

Got a question about SQL Server or being a DBA? Send me your queries and I will do my best to answer them for you!

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