• 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 30/09/11

September 30, 2011 by John Sansom 1 Comment

I hope you’ve had a great week!

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

I’m back! Did you miss me? Of course not because you were instead treated to great SQL Server content courtesy of Neil Hambly(Blog|Twitter) playing host in my absence. I think you’ll agree he did an absolutely smashing job, thanks Neil!

Yesterday(Thursday) was the start of an action packed week of SQL Server events here in the UK. I am unfortunately unable to make it to SQLBits this weekend myself and I have to say that I’m super jealous right now of all you lucky folks in attendance, getting your SQL learn on. I hope you have a fantastic time and look forward to catching up with you again soon. I’ll see some of you next week at SQLRelay.

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

SQL Server Links

  • How does DBCC CHECKDB WITH ESTIMATEONLY work? – A fascinating look into the internals of the ESTIMATEONLY feature of CHECKDB courtesy of Paul Randal (Blog|Twitter).
  • Optimizing Database Restores – Nicholas Cain (Blog|Twitter) shares with us how with tweaking and testing you can improve the performance of your database restores.
  • September 2011 SQL Server 2008 Instance Level Diagnostic Queries – More DMV magic for your toolbox thanks to Glenn Berry (Blog|Twitter).
  • How to Plan a SQL Server Virtualization Project (Video) – One to watch here for the weekend courtesy of Brent Ozar (Blog|Twitter).
  • Start daily programs – More n00bz fun with #Powershell! – An excellent idea here from Jen McCown (Blog|Twitter) as I’m always looking for ways to improve efficiency.
  • How to move a Published Table to a new File Group – Getting down and dirty with replication administration with the Microsoft SQL Server Replication Support Team(Blog).
  • Maximizing SQL Server Throughput with RSS Tuning – More performance tuning advice from those super clever folks in the Microsoft SQLCAT (Blog).
  • Database Properties Health Check – Fantastic article from Brad McGehee (Blog|Twitter) that incorporates some PowerShell magic.
  • After Applying SQL Server 2008 R2 SP1 Error 9013 is logged – Real world support case lessons and experience, shared courtesy the CSS SQL Server Engineers (Blog).
  • SQL Server MVP Deep Dives Vol 2 – get my chapter free – Get your hands on a free chapter from the upcoming SQL Server MVP Deep Dives book courtesy of Rob Farley (Blog|Twitter). Better yet, put your hand in your pocket and order your copy from Amazon now. It’s for a good cause!
  • SQL Cruise 2012 Registrations Open – SQL Cruise dates for next year have been announced and registration is open. Brent Ozar (Blog|Twitter) here with the details.

UK SQL Server Upcoming Events

  • SQLBits 9 –  Thur 29 Sep – 1 Oct – The UKs largest SQL Server event heads to Liverpool.
  • SQLRelay – Mon 3 Oct – Thur 6 Oct – 13 SQL Server Events taking place across 4 days throughout the whole of the UK.
  • SOUTHAMPTON – Wed 9 Nov -Allan Mitchell and James Rowland-Jones taking over the evening.
  • LEEDS – Wed 23 Nov – Provisional date.
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

  • Security Intelligence Report : Series : Lessons from Least Infected Countries
  • Amazon Kindle Fire to enter tablet computer market
  • The future of the silicon chip

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!

Did you enjoy this  post? The best way to show your support is by clicking the Like/Google Plus 1 button at the top of the on site post.
It spreads the word helping our SQL community grow and shows you care :-)

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