UK SQL Server User Group

Organiser

Martin Bell, SQL Server MVP

my blog | hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

A non-yielding issue may cause a database mirroring failover in SQL Server 2005 and in SQL Server 2008.
FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008.
Cumulative update package 9 for SQL Server 2008.
High CPU utilization may occur with your queries on SQL Server 2005 and SQL Sever 2008 servers compared to SQL Server 2000.
OS Errors 1450 and 665 are reported for database data files.
Log Reader Agent reports “The process could not execute 'sp_replcmds' on '%s'” on a partitioned table with more than 92 partitions.
Error code when you use Windows Update or Microsoft Update to install updates: "0x737D".
FIX: Even though the Distribution Agent successfully reapplies a batch of failed commands, you still receive error message 20046 that indicates that the Distribution Agent failed in a SQL Server 2005 transactional replication.
FIX: The -R parameter is ignored when you use the BCP.exe utility together with the -R parameter and the -F parameter in SQL Server 2005.
FIX: An access violation occurs when you run the SET FMTONLY statement to set the value of the FMTONLY option to ON and the SQL Server 2005 server is under memory pressure.
FIX: Error message when you run a query that uses a common table expression to shred XML data in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan".
FIX: Assertion failures occur in SQL Server 2005 when a Distributed Transaction Coordinator (DTC) transaction is rolled back while that transaction is being commited by the DTC.
FIX: An access violation occurs when you run a query on a table that has a partitioned nonclustered index in SQL Server 2005.
FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: “Cannot create the subscription because the subscription already exists in the subscription database”.
FIX: An insert operation for a temporary table that has a foreigh key constraint fails when the execution plan for the INSERT statement contains a merge join operation in SQL Server 2005.

Microsoft 2008 KB's

Evening Meeting on Wed Jun 10, 2009 in READING

Back to Events List

SQL 2008 R2 and Gemini; From Data Modelling to Information Architecture and Attribute Relationships, Aggregations and using MDX Studio to its best

LiveMeeting Attendee URL	Click here to join Meeting
Cost	Free
Organiser	UK SQL Server User Group
Address	Building 3, Microsoft Campus, Thames Valley Park, Reading, RG6 1WG
	Directions to Event
Tags

Join us for another UK SQL Server User Group meeting, this will meeting will focus around Business Intelligence.

This meeting will be broadcast and recorded using LiveMeeting from 18:15; the attendee url is:
https://www.livemeeting.com/cc/mvp/join?id=Z8G5HH&role=attend

The meeting is sponsored by Microsoft and Sybase.

Sybase are offering a free trial copy of "PowerDesigner Data Architect Enterprise", to receive the trial please click here.

Agenda

5.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits.

Meet and greet.

6:00pm – 6:15pm Round Table discussion and Nuggets - ALL

Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.

It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip.

6.15pm – 7:00pm Andrew Fryer, Microsoft

SQL Server 2008 R2 and Gemini
SQL Server 2008 R2 will be the release with Gemini in it. Gemini is about trying to marry self service BI for end users with proper control of that data for the IT Professional. The beta program has only been recently announced and so it’s still early days but if you want to know what to expect then this is your first real opportunity in the UK. So join Andrew Fryer for an hour of peering into what 2010 BI looks like

7:00pm - 7:45pm Ruairi Prendiville, Sybase

From Data Modeling to Information Architecture
It used to be about doing the thing right: a tactical approach for data modelling was necessary, because all the data was contained within the same domain. Now it’s about doing the right thing. Management demands information that is strategic and which helps them make business decisions. This information is more complex, housed in multiple domains, created in different languages, and used by different areas of the organisation for opposing purposes. Adding to the complexity is the critical need for it to be timely, accurate and comprehensive.
In this 45-minute session, Andrew de Rozairo and Alex Pratt of Sybase will impart the secrets of successfully building a foundation for a comprehensive and successful information architecture. You’ll learn how to take a new approach to modelling: combining the business view, information view and the technology view to achieve a strategic vision.

7:45pm – 8pm BREAK: Light refreshments

More time to network and ask questions...

8pm - 8:15pm Vincent Rainardi

Nugget (demo) on SSAS

8:15pm – 9.00pm Ashwani Roy

Attribute Relationships, Aggregations and using MDX Studio to its best
Setting proper relationships for the attributes of a dimension is essential from a query performance point of view. It is one of the most important things while dimensional modelling.
Aggregations are pre calculated summaries of cube data that help enable Microsoft SQL Server 2005 Analysis Services (SSAS) to provide rapid query responses. Aggregations are like fact table data grouped and aggregated to a higher level in the Hierarchy. Building the correct aggregations can greatly enhance query performance.
MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships. MDX Studio provides unique visualization representation of MDX expression and allows the user to interact with different stages of MDX execution. It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.

Speaker Bio's

Andrew Fryer

Microsoft Evangelist specialising in Business Intelligence.

Ashwani Roy

Ashwani Roy is a Business Intelligence Consultant with IMGROUP with 5+ Years of experience in RDBMS and OLAP. He specialises in Database engine, SSIS and SSAS, C#, Design Patterns.
Ashwani is MCTS & MCITP in SQL Server 2005 and also has 2 patents in Business Intelligence domain.
Ashwani is also frequent blogger on www.sqlkit.com and http://ashwaniroy.spaces.live.com and one of the authors of Server 2008 MCP exams 451 (database solutions). He is also regular responder on Microsoft Forums

Ruairi Prendiville

A professional Services Consultant, Ruairi Prendiville brings a rich background of Business Management intertwined with Application Design. Since joining Sybase 8 years ago, he has provided specialist consulting engagements for clients which combine 20+ years of experience in application architecture, database systems and data accessibility, between systems and to the end user via web, mobile and application.

Coming Events

Thu, 25 Feb in 16 days
CARDIFF
Evening Meeting (7 registered)

BI Fundamentals: Building an Enterprise ETL Framework in SSIS, SQL Server Upgrade strategies & considerations

Thu, 25 Feb in 16 days
EDINBURGH
Evening Meeting (0 registered)

SQL Server User Group

Past Events

20 Jan 2010 DUNDEE Evening Meeting (6 registered) Allan Mitchell - Intro to SQL Server Integration Services 2008; Tony Rogerson - Intro to SQL Server tools both flavours - DBA and Developer. Usual Nuggets, Usual SQL LiveLock; Q & A; Advice etc..	17 Dec 2009 MANCHESTER Evening Meeting (9 registered) Manchester SQL Server User group - Round the table talks, SQL Nuggets, Informal talk and out for a drink and a chance to win a Copy of Windows 7 and SQL Server 2008
10 Dec 2009 LEEDS Evening Meeting (9 registered) An evening of Service Broker and Powershell	26 Nov 2009 EDINBURGH Evening Meeting (8 registered) Cancelled SQL Server Nuggets and a look into the Newsgroups
26 Nov 2009 LONDON Evening Meeting (57 registered) SQL Server internals and best practice for Absolute Beginners (Tony Rogerson); Nuggest from Dave Ballantyne on Ranking, UDF's; MS Business Intelligence Project Boosters (Siddharth Mehta) - an Introduction to the Power of Policies (Martin Cairney), BakBone product demonstration and the first LiveLock Discussion	18 Nov 2009 LONDON Evening Meeting SQL Azure and what is new in SQL Server 2008 R2
11 Nov 2009 READING Evening Meeting (36 registered) High Availability (Partitioning, File Groups (use of, backup/restore)) and an Introduction to SQL Server architecture - Tony Rogerson; Virtualising SQL Server (why, design, how, issues, solutions, troubleshooting) - Justin Langford	29 Oct 2009 LONDON Evening Meeting (42 registered) Deploying SSRS reports using msbuild (Jamie Thomson); BI 2.0 (Andrew Sadler); Data Warehouse Development Workbench for SQL Server (Steve Hitchman)
28 Oct 2009 DUNDEE Evening Meeting SQL Injection Attacks and Tips on How to Prevent Them	15 Oct 2009 MANCHESTER Evening Meeting (17 registered) Reporting Services evening. Hosted by Chris Testa-O'Neill
14 Oct 2009 READING Evening Meeting (33 registered) Focus: Developer/DBA; Tony Rogerson on TSQL Hints and Tips (CTE Recursion,Case,Partitioning,Sub-Queries,Normalisation/DeNormalisation) and Colin Leversuch-Roberts "How are my servers Today?" - real time monitoring dashboards	8 Oct 2009 CARDIFF Evening Meeting (18 registered) South Wales User Group first meeting - Ensuring Business Continuity (Backups, Mirroring and Monitoring) - Tony Rogerson; SQL 2008 Integration Services - some of the things that make it better - Allan Mitchell.
8 Oct 2009 EDINBURGH Evening Meeting (11 registered) SQL Server Performance Analysis Tools and Powershell	1 Oct 2009 LEEDS Evening Meeting (10 registered) SQL Server Reporting Services and Analysis Services with Chris Testa-O'Neill
28 Sep 2009 BRACKNELL Evening Meeting SQL Server with Colin Leversuch-Roberts

Member Chat

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

tonyrogerson Tue 7:44AM

Martin Bell blogs the SQL 2008 R2 Update for Developers Training kit http://bit.ly/bywIrz has been released - looks good and is free #sqlfaq

Chris Testa-O'Neill Tue 7:27PM

Manchester SQL Server content being finalised and should appear on SQLFAQ at the weekend. dates will be added to each event soon after. #sqlfaq

Chris Testa-O'Neill Tue 7:26PM

Manchester SQL Server content being finalised and should appear on SQLFAQ at the weekend. dates will be added to each event soon after