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

August 7, 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

Stolen Pages, Ad-hoc queries and the sins of dynamic SQL in the application – Excellent well written example on how dynamic ad-hoc queries can, if left to get out of hand, consume valuable memory. Includes detailed walk-throughs and some interesting looks at how DMV’s can be used to investigate this problem.

More About Successful Directors versus Successful Technologists

The Biggest Cloud Computing Pitfall – Jason Massie discusses what he believes to be the biggest hurdle that Cloud Computing must overcome, if it is to encourage faster uptake.

Importance of running regular consistency checks – Paul Randal has released the results of hist latest online survey and discusses.

Are DBAs Losing Power? – Brent Ozar raises a very thought provoking question indeed. There are some good discussions going on in this post too so be sure to have your say on the matter.

Find Recently Executed Stored Procedures – Nice tip.

RANT: Got Performance Problems? Buy bigger hardware! – It’s another good old rant from Jonatahn Kehayias.

24 hours of free SQL training – Everyone loves a freebie and this case you get to learn a mountain of SQL Server stuff too.

DBA Compliments – Have you ever received any?

Editing Configuration files : SSIS Nugget – Here’s a nice and simple tip courtesy of Jamie Thomson

The Mythical Silver Bullet – Buck Woody goes in search of the answer.

Misc Techie Stuff

Massive Attack Strikes Websites – BBC news report on the recent attacks.

How Many Triangles? – If like me, you enjoy solving problems then you will love this puzzle courtesy of Bill the Lizard.

Murdoch signals end of free news – Could this be the end of free news content? Would you pay for your digital news?

Software Pricing: Are We Doing It Wrong? – Jeff Atwood discusses.

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