SQL Server Blogs

Voices from the UK SQL Server Community

UK SQL Communities

UK SQL Server User Group was established in 1998; it facilities community via it's website and through physical meetings across the UK.
 

Popular Tags

Browse All Tags

Welcome

SQLBlogCasts is a free service to those folk who want SQL Server related blogs. It's there to support the online community especially in but not limited to the UK.

The site is a partner of the UK SQL Server User Group a group of professionals with an interest in and using Microsoft SQLServer.

If you have any questions or want to participate then contact Tony Rogerson or Simon Sabin

Thanks to Telligent for supporting SQLBlogCasts - please check out their site; Community Server is a complete Content Management System package.

Income generated from the general areas (not blogs) or sponsorship of the general SQLBlogcasts.com site will go towards funding the UK SQL Server User Group physical regional events. 

What's New

  • How atomic is a SELECT INTO?

    Last week I got an interesting situation that prompted me to challenge a long standing assumption. I always thought that a SELECT INTO was an atomic statement, i.e. it would either complete successfully or the table would not be created. So I got very surprised when, after a “select into” query was chosen as a deadlock victim, the next execution (as...
    Posted to My two cents (Weblog) by leo.pasta on Tue, May 22 2012

  • Coming back from (blog) retirement

    So, it has been more than 3 years without a single blog post. I wished I could have a decent excuse for it, but in the end, I guess it boils down to laziness and procrastination. :-) Even though I learned a lot in that period (and added a feel tricks to my bag), I couldn’t find the will to sit down and write. I hope all my readers (yes mom and dad,...
    Posted to My two cents (Weblog) by leo.pasta on Tue, May 22 2012

  • Changing Server Side Trace Scripts

    Although SQL Trace is marked started it’s deprecation stage, it will be around for quite some time to come. Therefore I thought I would share a couple of changes I make to server side traces when I use them. (It also means I will always have somewhere to find the code without writing it from scratch!) In the past when you scripted a service side trace...
    Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sun, May 20 2012

  • SQL Server data platform upgrade - Why upgrade and how best you can reduce pre & post upgrade problems?

    SQL Server upgrade, let it be database(s) or instance(s) or both the process and procedures must follow best practices in order to reduce any problems that may occur even after the platform is upgraded. The success of any project relies upon the simpler methods of implementation and a process to reduce the complexity in testing to ensure a successful...
    Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Sat, May 19 2012

  • Microsoft SQL Server 2008 R2 Administration Cookbook

    Its one year on my first book released, keeping aside the financial gains from this book I'm more happy to achieve one of the important goals from my career. This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration...
    Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Fri, May 18 2012

Who Is Online

Powered by Community Server (Commercial Edition), by Telligent Systems