UK SQL Server User Group

Organiser

Tony Rogerson, SQL Server MVP

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 Mon Jul 20, 2009 in Leeds

Back to Events List

Managing a large SQL Server estate (Martin Cairney); SQL Nuggets

LiveMeeting Attendee URL	This event is not available via LiveMeeting
Time	Starts (UK time) at 19:00 , Finishes 21:00
Cost	Free
Organiser	UK SQL Server User Group
Address	Remarc, Capitol House, Bond Court, Russell Street, Leeds, LS1 5SP
	Directions to Event
Tags

Leeds Area SQL Server User Group Meeting, Leeds - Monday 20th July

Managing a large SQL Server estate
If size matters Martin Cairney would have the bragging rights!! How do you control and keep track of over 600 SQL Server instances on a global network? SQL Server 2008 Policy Based Management is a good starting point and Martin will discuss some of the challenges and solutions for keeping on top of things as a DBA - leaving you more time for the fun things in life like presenting at User Groups.

Martin Cairney
Martin Cairney has over 10 years experience as a SQL Server DBA. In his time he has worked for one of the largest IT services companies in the world deploying and supporting SQL Server installations from versions 6.5 through to 2005. Martin has supported some the SQL Server estate of some major Government Departments and Financial Institutions as well as a variety of occasional consultancy roles

SQL Nuggets
The first half of the evening will be a SQL Nugget competition. If you don't know what a SQL Nugget is check out http://blogs.technet.com/industry_insiders/pages/sql-nuggets.aspx. The best one will get a prize. If you need a specific environment to demonstrate on please contact me

Agenda

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

19:00 - 19:50 – SQL Server Nuggets - A prize for the best nugget!)

19:50 - 20:00 – Break

20:00 – 20:50 – Managing a large SQL Server estate - Martin Cairney

20:50 – 21:00 – Close

Location:
Remarc, Capitol House, Bond Court, Russell Street, Leeds, LS1 5SP http://www.remarc.co.uk/remarcgroup/locations.aspx

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!