UK SQL Server User Group

Organiser

Chris Webb

my blog | hire me

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

Evening Meeting on Thu Feb 25, 2010 in Edinburgh

Back to Events List

Prize Draw , An evening of performance troubleshooting with Iain Kick , Learning SQL Server with Alistair Board

LiveMeeting Attendee URL	This event is not available via LiveMeeting
Time	Starts (UK time) at 18:30 , Finishes 21:00
Cost	Free
Organiser	UK SQL Server User Group
Address	Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG
	Directions to Event
Tags	Performance Analysis

Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 25th February

** Prize Draw Win £50 of Amazon Vouchers courtesy of Quest Software **

Entry only available to attendees.

End-to-End SQL Server Performance Troubleshooting – Iain Kick

When attempting to diagnose a problem in a SQL Server application, there's no right or wrong way to go about troubleshooting. However, certain techniques yield much better results when used for end-to-end troubleshooting.

This presentation will teach you the best practices for finding the root cause of a problem in a SQL Server application, correlating that root cause to a specific set of activities being performed on the server, and tuning the problem activity for maximum performance-all using the native SQL Server tools. We will then compare and contrast those techniques to Quest Software's performance management and query tuning tools. All examples and syntax are verified for Microsoft SQL Server 2005.

Ways to learn SQL Server – Alistair Board and Martin Bell

One of the reasons that I like to work with SQL Server is that you never stop learning new things. This may sound daunting to new people coming to this as a career change or taking their first steps in a new position, but it’s one of the areas why we still work with SQL Server. Everyone has their own preferred methods of learning, but finding the resources that suit you best is not always easy. This talk will draw on the many years of experience that Alistair and Martin have with SQL Server, but if you have something you wish to contribute feel free to bring it along.

Agenda

18:30 - 19:00 - Introduction, Networking and Food

19:00 - 19:50 – End-to-End SQL Server Performance Troubleshooting – Iain Kick

19:50 - 20:00 - Break

20:00 - 20:50 – Ways to learn SQL Server - Alistair Board and Martin Bell

20:50 - 21:00 - Close

Location:

Microsoft Office at Waverley Gate

http://www.microsoft.com/uk/about/map-edinburgh.mspx

Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.

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!