• 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 04/12/09

December 6, 2009 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

  • Comparison: Switching Tables vs. sp_rename – An interesting walk-through that evaluates the differences between using the sp_rename system stored procedure and the partitioning support SWITCH statement, courtesy of the The Database Whisperer (Michael J Swart).
  • Insecure Metadata – A look at SQL Server Metadata security, by Ben Nevarex shows how even when your environments adhere to best practice they could still be giving away exploitable information.
  • Restoring SQL 2005 Master Using LiteSpeed – If you are Litespeed user and you have not had to restore your master database using the tool then I strongly advise you to review this first hand experience account from Thomas La’Rock.
  • SQL Server 2008 Diagnostic Information Queries (Late November 2009) – Here is a nice list of SQL Server diagnostic queries courtesy of Glenn Berry.
  • Free Tool for SQL Server Encryption Key Management – Everyone likes a freebie.
  • Upgrading the SSC SQL Servers: Part 1 – An interesting discussion from Brad McGehee about working on the SQL Server Central upgrade project.
  • Odd that you can’t create a filtered index on a deterministic persisted calculated column – An interesting scenario shared by Greg Low.
  • Performance impact: UNION ALL views, ANSI_PADDING, and bad query plans – An interesting Demo, kindly provided by Linchi Shea
  • Who is Active? v9.57: Fast, Comprehensive DMV Collection – What’s Really Happening on Your Server? – Here is the next release of Adam Machanic’s very useful script for identifying what is happening right now on your SQL Server instance.
  • Aren’t DBA’s Just System Admins for Databases? – More and more IT professionals are waking up to the fact that there is a whole lot more to the humble DBA. Perhaps it is time that you considered yourself as a Data Professional, Buck Woody discusses.

Misc Techie Stuff

  • Intel unveils 48-core cloud computing silicon chip – Not sure if the terminology “cloud computing” should really be being used here but a very interesting development nonetheless.
  • Google set to offer property dimension to UK mapping – Well it was only a matter of time really that once Google Maps had launched and become established, this was the next logical business move. Not good news for property websites!
  • Troubled £12bn NHS IT system to be scaled back – There must be UK Public Sector IT projects that are or have been successful? Let me know about them!

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. Have a great weekend!

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