• 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 12/08/11

August 13, 2011 by John Sansom 1 Comment

I hope you’ve had a great week!

Subscribe to the Blog Feed now to ensure you catch all posts. Don’t miss out on your weekly fix of SQL Server Links, community news and technology banter.  You can also receive posts via Email.

It’s a double round-up for you, as I write this weeks SFTW post from Seattle Tacoma (Sea-Tac as the locals call it) Airport. I’ve been away with work for the last two weeks and so blog time has been in short supply but nevertheless I always endeavour to come up with the goods for the regulars.

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

SQL Server Links

  • Avoiding Uniqueness for Performance – Continuing to share performance tuning insights by example, it’s Paul White (Blog|Twitter). Proof, as if it were ever needed, that it depends.
  • Book Review: SQL Server Hardware by Glenn Berry – Brent Ozar (Blog|Twitter) on Glenn Berry’s latest SQL title. Certainly sounds like a perfect candidate to be added to your SQL reading list.
  • RTFM. No seriously, R.T.F.M. Then ask your question – This really shouldn’t be anything new to anybody. RTFM was drummed into me way back when I was learning my very first programming skills as part of my Computer Science degree and it has done good by me ever since. Paul Randal (Blog|Twitter) explains.
  • SQL Server, Seeks, and Binary Search –  More fascinating SQL Server performance internals from Paul White (Blog|Twitter).
  • The Stages of Growth – Taking a ride on the emotional DBA roller-coaster courtesy of Jeremiah Peschka (Blog|Twitter).
  • ACID Properties By Example (And Counterexample) Part Two: Consistent – Continuing his excellent post series,  I give you Michael J. Swart (Blog|Twitter).
  • Should All Data Be Encrypted By Default? – Interesting discussions this week from Buck Woody (Blog|Twitter) where he considers a security philosophy that is becoming ever more prevalent with the adoption of Cloud services.
  • Do yourself a favor… Trust No One – Sound advice from Paul Randal (Blog|Twitter).
  • Configuring, Benchmarking and Validating an I/O Subsystem for SQL Server, Part 1 – Kicking off what looks set to be a fascinating series, it’s Glenn Berry (Blog|Twitter).
  • When was the Last Time You Removed an Index Because it was Never Used? – Sharing the results of his latest user survey, Brad McGehee (Blog|Twitter).
  • How compressed is your backup? – More real world customer support experience, courtesy of CSS SQL Server Engineers (Blog).
  • Windows Azure Security Review – A look at the security framework of Windows Azure from Buck Woody (Blog|Twitter). If you’re considering implementing services that leverage this Cloud platform then you’ll really want to know this stuff.

UK SQL Server Upcoming Events

  • EDINBURGH – Wed 17 Aug – Reporting Services and Sharepoint Integration with Rob Carrol
  • LONDON – Thur 18 Aug –
  • SURREY – Thu 18 Aug – A packed evening covering Business Intelligence, Denali and a newcommer’s first session!
  • MANCHESTER – Wed 24 Aug – Replication by Neil Hambly and Cube versus tables with Steve Powell at the Coop
  • LEEDS -Thu 25 Aug – XQuery Fundementals with Neil Hambly

Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

Misc Technology Posts

  • US military loses contact with hypersonic aircraft
  • Era of the PC ‘coming to a close

That’s it for this week. If you’ve read a post this week that you think deserves a mention be sure to let me and other readers know by using comments section below. You can also reach me on email and find me on Twitter(@JohnSansom).

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