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

  • Read Committed Snapshot Isolation– Two Considerations

      The Read Committed Snapshot database option in SQL Server, known perhaps more accurately as Read Committed Snapshot Isolation or RCSI, can be enabled to help readers from blocking writers and writers from blocking readers.  However, enabling it can cause two issues with the tempdb database which are often overlooked. One can slow down queries...
    Posted to Gavin Payne (Weblog) by GavinPayneUK on Fri, May 11 2012

  • “Query cost (relative to the batch)” <> Query cost relative to batch

    OK, so that is quite a contradictory title, but unfortunately it is true that a common misconception is that the query with the highest percentage relative to batch is the worst performing.  Simply put, it is a lie, or more accurately we dont understand what these figures mean. Consider the two below simple queries: SELECT * FROM Person.BusinessEntity...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Thu, May 10 2012

  • Changing SQL Server Port with Powershell

    The other week, we were fortunate to have Mark Broadbent ( blog \ twitter ) as a guest speaker at the Leeds SQL Server User Group. he did a great presentation on using Windows Server Core and SQL Server. If you haven’t taken time to learn Powershell then this could be the best reason to do so. Of course if you are already have your own toolbox of Powershell...
    Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Mon, May 7 2012

Who Is Online

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