UK SQL Server User Group

Thanks to our Partners:

SQLBlogCasts

Public Content

Microsoft 2005 KB's

FIX: A Deadlock occurs when two transactions try to perform a DML operation on a table that contains a TABLOCK locking hint or an XLOCK locking hint.
FIX: Heap corruption occurs when you use SQL Server Compact 3.5 Service Pack 2.
Cumulative Update 2 for SQL Server Compact 3.5 Service Pack 2.
You have to reinstall some drivers when you install SQL Server 2005.
FIX: ACCESS_VIOLATION error when you rebuild indexes online in Microsoft SQL Server 2005.
FIX: "SOS_Task::GetCurrent() == m_parentTask" assertion failure occurs when you run a backup and restore command in Microsoft SQL Server 2005 SP3.
FIX: An unresolved deadlock occurs when a database is recovered in Microsoft SQL Server 2005 SP3.
Cumulative update package 11 for SQL Server 2005 Service Pack 3.
FIX: An incorrect cardinality estimate is returned When you run a query in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2.
FIX: "An SqlCeParameter with ParameterName '<Parameter Name>' is not contained by this SqlCeParameterCollection" error message when you use the .NET Compact Framework Data Provider for SQL Server Compact to access SQL Server Compact 3.5.
A SQL Server 2008 or SQL Server 2005 Analysis Services ROLAP query returns incorrect results.
Microsoft Advisory Services Engagement Scenario – Diagnose SQL Server Compact 3.5 application performance issues and memory issues.
Microsoft Advisory Services Engagement Scenario – Synchronization performance issues of SQL Server Compact 3.5 merge replication.
Microsoft Advisory Services Engagement Scenario – Best practices to reduce data corruption in SQL Server Compact 3.5.
Huge blocking in SQL Server that is used with Configuration Manager 2007 Server.

Microsoft 2008 KB's

Cuppa Corner ScreenCasts

Profiler Data in StreamInsight. Taking Profiler data and streaming it through StreamInsight whilst doing analytics	Table Variable Gotchas. Ever wondered why (or have you even noticed that ) the percentage of query cost relative to batch can be widely different from the real execution cost ? The use of table variables is just one of the things that can cause this. Dave Ballantyne tries to lift the fog....	StreamInsight Left Anti Semi Join. In this session Allan Mitchell show you how to perform an outer join on your StreamInsight streams.
Unbalanced DataLoads. Dave Ballantyne - Sql Server is great at producing and caching efficient query plans. However these plans may not be the most efficient, if called with different parameters. How can optimal plans be created to cope with differing ranges of data ?	Fusion IO Technical Overview and Benchmarks. Technical overview of the FusionIO IO Memory devices, how it works - how it differs from SSD, throughput rate examples and benchmark compared to SAS using SQLIO and IOMeter.	Unpivotting Techniques in T-SQL. Rob Farley shows a few ways to unpivot data in T-SQL, including a look at the execution plans involved
Sorting data in the SSIS pipeline. In this sessions I show a couple of ways to sort data in an SSIS Data Flow Task. I have been asked about this a number of times and hopefully this explains some options available to us.	SQL - Basic Windowing using Joins. Tony Rogerson talks about what he calls "Windowing" in SQL, this is a basic talk - he shows how rolling totals work and how that method can be used for other things.	Lookup and Cache Transform in SSIS. A look at how the cache transform can help you when having to perform the same lookup more than once using SSIS.
Database Design - A Trip to First Normal Form. Introduction to First Normal Form, in this short presentation Tony Rogerson covers Domains, Functional Dependencies, Repeating Groups, Relation Valued Attribute and First Normal Form.	Pipeline Limiter in SQL Server Integration Services. You heard right. The pipeline can be, by design, stalled. In SQL Server 2008 you can see this limiter whereas in 2005 you couldn't even though it was there. Be assured though that the limiter does what it does for the right reason.

Coming Events

Tue, 7 Sep in 4 days BRACKNELL Evening Meeting SQL Server CLR and T-SQL Functions - Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) - Neil Hambly	Wed, 15 Sep in 12 days LEEDS Evening Meeting (15 registered) ****Win an MSDN Subscription worth $1,000's ********* Using XML data in SQL Server with Anthony Brown, and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
Thu, 16 Sep in 13 days MANCHESTER Evening Meeting (14 registered) ****Win an MSDN Subscription worth $1,000's ********* User group evening with Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown	Wed, 22 Sep in 19 days MAIDSTONE Evening Meeting Kent User Group - Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
Thu, 23 Sep in 20 days CARDIFF Evening Meeting (13 registered) Chris Testa O'Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products Keep Checking back for further updates	Thu, 30 Sep in 27 days YORK Multi Day Seminar SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 34 days EDINBURGH Evening Meeting (5 registered) Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell)	Wed, 27 Oct in 54 days LEEDS Evening Meeting (5 registered) User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 55 days MANCHESTER Evening Meeting (12 registered) SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008	Wed, 8 Dec in 96 days LEEDS Evening Meeting (4 registered) User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns
Thu, 9 Dec in 97 days MANCHESTER Evening Meeting (6 registered) User group evening - Agenda to be confirmed	Wed, 19 Jan in 138 days LEEDS Evening Meeting (4 registered) User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O'Neill

Past Events

19 Aug 2010 EDINBURGH Evening Meeting (11 registered) Execution plans and Performance Tuning (Rob Carrol); Extended Events (Martin Bell)	18 Aug 2010 MAIDSTONE Evening Meeting Kent User Group - Complex Event Processing (Allan Mitchell), Replication (Neil Hambly)
5 Aug 2010 MANCHESTER Evening Meeting (21 registered) Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill	20 Jul 2010 LEEDS Evening Meeting AGI Northern Group meeting: Using geospatial data in the Microsoft world.
14 Jul 2010 LONDON Evening Meeting (92 registered) SQL Server and Disk IO (File Groups/Files, SSD's, Fusion-IO, In-RAM DB's, Fragmentation) - Tony Rogerson; Physical Join Operators in SQL Server - Ami Levin; Complex Event Processing - Allan Mitchell	28 Jun 2010 EDINBURGH Evening Meeting (14 registered) Replication (Components, Adminstration, Performance and Troubleshooting) - Neil Hambly and SQL Server Upgrades (Notes and Best practice from the field) - Satya Jayanty
24 Jun 2010 CARDIFF Evening Meeting (16 registered) Alex Whittles on data warehouse design case studies and an introduction to PowerPivot with Adam Morton	23 Jun 2010 READING Evening Meeting (31 registered) Introduction to NoSQL (Not Only SQL) - Gavin Payne; T-SQL Gotcha's and how to avoid them - Ashwani Roy; Introduction to Recency Frequency - Tony Rogerson; Reporting Services - Tim Leung
17 Jun 2010 LONDON Full Day Seminar SQL Server Master Class with Kimberly Tripp and Paul Randal	27 May 2010 ONLINE Online Q & A Session with the UK SQL Server Product Team
20 May 2010 LONDON Evening Meeting (30 registered) Business Intelligence: Implementing common business calcs using DAX in PowerPivot (Chris Webb); Case Study on how to deal with Metrics on high data volumes	19 May 2010 LONDON Evening Meeting (38 registered) Service Broker (Intro, Terminology, Design Considerations); Monitoring and Controlling Resources in SQL Server (Resource Governor, Data Collector); BakBone NetVault: FASTRecover provides byte-level continuous data protection
7 May 2010 ONLINE Webcast (14 registered) "Cuppa" Corner: Database Design What is and Why is Normalisation important? Domains, Functional Dependencies, Repeating Groups, First Normal Form.	21 Apr 2010 READING Evening Meeting (40 registered) Service Broker (Intro + Guidance), Indexing (Selection, Usage, Fragmentation etc...), Normalisation, Surrogate Keys - Locking considerations
15 Apr 2010 LONDON Evening Meeting (11 registered) Social for SQL and SQL Server professionals - SQL quiz, meet your peers, ask the group Q & A

Member Chat

To post messages you must be signed on - please register or logon.

Stephanie Sullivan Wed 3:34PM

Looking for a lift to sql bits from south wales. Anybody driving up who welcome a reduction in petrol money?

neil_hambly Tue 2:11PM

My next presentation (DAC-PAC) is @ the VBUG Bracknell (7th Sept) http://bit.ly/9ZgObb along with GrumpyDBA (CLR vs TSQL functions) #sqlfaq

allansqlis Sun 9:08PM

Solution to a practical problem when issuing Current Time Increments in StreamInsight http://goo.gl/UhQn #StreamInsight #CEP #sqlfaq

gavinpayneuk Sat 10:02PM

@SQLRich #sqlserver #sqlfaq Using the internal SQL Server encryption tools

sqlrich Sat 9:58PM

@GavinPayneUK Do you mean SQL's internal code or DBA's implementing encryption? #sqlserver #sqlfaq

gavinpayneuk Sat 9:14PM

@mouldie Have they started using SQL's internal encrypt tools or is it still done at the app, o/s or storage level? #sqlserver #sqlfaq

gavinpayneuk Sat 8:40PM

Does anyone bother with encryption actually within SQL Server? #sqlserver #sqlfaq

neil_hambly Sat 9:44AM

Can't stop laughing RT @tonyrogerson: RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq

tonyrogerson Sat 9:26AM

RT @fasel: Mongo DB is web scale :D http://bit.ly/cWY3el #nosql very funny video and so true #sqlfaq

bletchleypark Fri 12:00PM

RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!

neil_hambly Fri 10:28AM

I have also pledged 1 day RT @tonyrogerson: I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, #sqlfaq

tonyrogerson Fri 10:10AM

I've given up a days pay for the 16th Sept Bletchley Park pledge http://bit.ly/bshbSs, done via paypal #sqlfaq - very worthy cause!