• 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 28/10/11

October 28, 2011 by John Sansom Leave a 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.

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

SQL Server Links

  • Transactional replication and massive data updates – Administering a replication topology can be a particularly tricky endeavour, especially when it comes to handling large data modifications. Linchi Shea(Blog) shares how he approaches the problem and interestingly it’s different to how I would typically go about doing it.
  • SQL Server 2012 Developer Training Kit – Give the Developers in your shop a taste of the Denali(sorry SQL 2012) magic with this freely available training kit.
  • Dataflow mechanics [SSIS] – A lot of wisdom shared in this post from Jamie Thomson(Blog|Twitter) and should be considered essential reading for SSIS Developers.
  • Dedicated Access Control for SQL Server Express Edition – An interesting administrative support tip this week from Pinal Dave (Blog|Twitter).
  • SQL Sentry Plan Explorer v1.3 – If you are not using this tool already you’re missing out on making life easier for yourself! With details of the latest release it’s Aaron Bertrand (Blog|Twitter).
  • My 3 Favorite Connection String Tips – Not the most exciting blog post title but then it’s all about the content, which I’m pleased to say is the same excellent quality we have all come to expect from Brent Ozar (Blog|Twitter).
  • Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot – Microsoft SQLCAT (Blog)
  • Troubleshooting Repeated Login Failures on SQL Server – An interesting look at a common error encountered on a DBA support desk, brought to you by Kevin Kline(Blog|Twitter).
  • Where Are Your Popular Joins? – Alluring us to the Dark Side this week, it’s Michael J. Swart (Blog|Twitter).

UK SQL Server Upcoming Events

  • LONDON – Tue 1 Nov – SQL Server 2008 Developer Workshop with Gavin Payne.
  • SOUTHAMPTON – Wed 9 Nov -Allan Mitchell and James Rowland-Jones taking over the evening.
  • DUNDEE – Sat 19 Nov – A FREE single-day software development conference.
  • 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

  • On Parenthood – OK so this is not a technology post but it is authored by a prominent technical blogger and is a truly fantastic read.
  • RIM faces compensation lawsuits over Blackberry outage
  • Nokia bets on Windows Phone future
  • Hackers could have TAKEN OVER Amazon Web Services

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