UK SQL Server User Group

Organiser

Tony Rogerson, SQL Server MVP

my blog | hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

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.
The execution of a SQL Server Integration Services (SSIS) package stops responding when you enable DTC transactions for a package in Microsoft SQL Server.
Considerations when using the SQL Server Full-Text search engine for the Japanese language.
.NET Compact Framework Assembly Redirection Fails.
FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005.
Cumulative Update 1 for SQL Server Compact 3.5 Service Pack 2.
Error message when you shrink data files on principal in a Database Mirroring for two SQL Server 2005 servers.
FIX: Error message when you use database mirroring in SQL Server 2005, and an assertion failure occurs intermittently.
FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled.
Cumulative update package 10 for SQL Server 2005 Service Pack 3.

Microsoft 2008 KB's

Evening Meeting on Wed Feb 13, 2008 in EDINBURGH

Back to Events List

Scottish Area SQL Server User Group Meeting

LiveMeeting Attendee URL	This event is not available via LiveMeeting
Cost	FREE
Organiser
Address	HBOS Plc, 2 Bankhead Crossway North, Sighthill Industrial Estate, Sighthill, Edinburgh. EH11 4E
	Directions to Event
Tags

Scottish Area SQL Server User Group on conjunction with Scottish Developers: Wednesday 13th February 18:30 - 21:00 : Edinburgh Speaker: Colin Angus Mackay Where’s my data? An introduction to Spatial Queries in SQL Server 2008 Colin Angus Mackay is a software developer specialising in Microsoft technologies located in Glasgow, Scotland. He is a Member of the British Computer Society, a Microsoft MVP (C#), a Microsoft Certified Solutions Developer, a Core Member of Scottish Developers, Code Project MVP for three years running and while not involved in software related pursuits is an amateur photographer, cyclist, map maker and is also the Vice President of Education for South Side Speakers, the Glasgow South Side Branch of Toastmasters International. And if all that wasn’t enough he is also organising Developer Day Scotland It is reckoned that 80-90% of data has a spatial component to it. But what do we do with it now? At best, we constrain it to postcodes. Well, that would be great if we were delivering letters, but the majority of us aren’t. In this session we look at Spatial Queries in SQL Server to see how it works and what can be done with it. Speaker: Martin Bell "SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking" Martin has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003. Currently he organises the Scottish Area Meetings and is a founding organizer of the SQLBits Community Conferences. Dynamic Management views were introduced in SQL Server 2005 and have made management and troubleshooting of SQL Server significantly easier than in previous versions. Even if you do not write your own queries against these DMVs you may be using them in Performance Dashboard Reports or other performance reporting applications. In this talk I will go through my TOP favorite DMVs and show how and when they can be used and why I like them! This event will be held at the HBOS's Sighthill office. For security reasons we need to submit a list of deligates in advance. If you wish to attend you MUST email Martin Bell before 12:00 on 11/12. The event will start at 18:30 and go on till 21:00 Sandwiches and refreshments will be provided for attendees.

Coming Events

Thu, 5 Aug in 7 days MANCHESTER Evening Meeting (18 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	Wed, 18 Aug in 20 days MAIDSTONE Evening Meeting Kent User Group - Complex Event Processing (Allan Mitchell), Replication (Neil Hambly)
Wed, 15 Sep in 48 days LEEDS Evening Meeting (9 registered) 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 49 days MANCHESTER Evening Meeting (7 registered) User group evening with Tony Rogerson, Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown
Thu, 23 Sep in 56 days CARDIFF Evening Meeting (6 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 63 days YORK Multi Day Seminar SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 70 days EDINBURGH Evening Meeting (4 registered) SQL Server User Group	Wed, 27 Oct in 90 days LEEDS Evening Meeting (3 registered) User group evening with Allan Mitchell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 91 days MANCHESTER Evening Meeting (7 registered) SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008	Wed, 8 Dec in 132 days LEEDS Evening Meeting (3 registered) User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns
Thu, 9 Dec in 133 days MANCHESTER Evening Meeting (6 registered) User group evening - Agenda to be confirmed	Wed, 19 Jan in 174 days LEEDS Evening Meeting (3 registered) User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O'Neill

Past Events

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
6 Apr 2010 MANCHESTER Evening Meeting (8 registered) Loading a datawarehouse using SQL Server Integration Services (SSIS) Chris Testa-O'Neill, Database Design: Normalisation/Denormalisation and using Surrogate Keys Tony Rogerson; Group discussion on topics brought by the audience.	30 Mar 2010 MANCHESTER Evening Meeting (9 registered) Introduction to Database Maintenance and Development 101.
25 Mar 2010 EDINBURGH Evening Meeting (12 registered) SQL Server 2008 Reporting Services Scalability and Performance

Member Chat

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

tonyrogerson Wed 1:32PM

Do most developers talk Oddle Poddle? #sqlfaq

glhotz Tue 9:46AM

RT @tonyrogerson: "Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory

tonyrogerson Mon 2:36PM

"Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory

gavinpayneuk Mon 8:09AM

Trying #oracle as a #sqlserver user for the first time, why and how in Part 1 of my new blog series http://bit.ly/a8KVbL #sqlfaq

tonyrogerson Mon 5:31AM

Celko advocating 100's of params http://bit.ly/aYvo2K when passing a "set" of values rather than CSV or TVP - he just doesn't get it #sqlfaq

tonyrogerson Fri 9:51AM

26th-28th July - Live Video of KDD-2010 Conference (data mining) Keynotes http://bit.ly/9PIA9C #sqlfaq