UK SQL Server User Group Events Feed

Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill

05/08/2010

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

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

6:00pm – 6:30pm 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.30pm – 7:30 Introduction to the Service Broker - Anthony Brown

Service broker is a technology available in all versions of SQL Server since SQL 2005 that provides a message based communication framework from within the database. This allows you to easily design distributed applications and to use asynchronous programming techniques for a scalable solution. The presentation is an introduction to this exciting technology and assumes no previous knowledge of service broker.

Anthony has been a sql server DBA since 1998 and have worked with all versions of SQL server since 6.5. Since 2001 he has worked at John Lewis on their website designing a highly scalable and resilient architecture for it. He has experience in many areas of sql server including service broker, replication and visual studio database projects.

7:30pm – 8:00 BREAK: Light refreshments
More time to network and ask questions...

8:00pm – 9.00pm Creating compelling reports with SQL Server 2008 R2 Reporting Services

This session will focus on the new features and walk through the authoring, management and delivery of reports, focusing on the new features of Reporting Services 2008 R2, creating a report in the new report designer and raising the awareness of report management options and the delivery mechanisms to deliver reports.

This session will focus on...

Report Designer Controls

An exploration of the report designer controls that are available that provides greater flexibility for creating reports from within SQL Server 2008 R2.

· New Data Source support

· Pagination

· Data Synchronisation

Data Visualisation

An increased range of data visualisation will enable you to compelling reports that enables business users to interpret reports in an easier manner. Data visualisation improvements will cover...

· Spark lines

· Data bars

· Indicators

· Maps

Report Builder 3

Improve end users experience of creating as hoc reports with Report Builder 3, exploring new data regions and ways to browse and connect to data including...

· Data Visualisation

· Report Galleries

Extended Expression Support

Explore the extended expression support that provides greater flexibility adding custom components to the reports that you build including

· Aggregation changes

· Multiple data source

· Conditional rendering

· Group page numbering

Report Management

Explore the new features that provides expanded browser support and management functionality that makes it easier to administer and manage reports, including...

· Report Manager changes

· Report Viewer improvements

· Improved security changes

Chris Testa-O'Neill is a Practise Consultant at EMC Consulting. He specialises in SQL Server Business Intelligence Solutions in the SQL 2005 and 2008 product range. Chris is also a technical author is currently working on E-Learning courses for SQL Server 2008 and SQL Server 2008 R2 with Microsoft Learning. He also runs the Manchester and Leeds SQL Server User Group and is a SQLBits Organiser. Chris is a SQL Server MVP and MCT and has Microsoft qualifications in MCDBA, MCTS and MCITP in SQL Server 2000, 2005 and 2008 as well as an MCSE in Windows Server 2000 and 2003

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.

15/09/2010

Meet and greet.

6.30pm – 7:30 XML Data in SQL Server - Anthony Brown

The xml datatype was introduced in sql 2005 and allows you to store xml nativly within the database. Working with it can be a bit confusing to start with, and this talk will show you how to query the xml datatype and the different methods of creating it.

7:30pm – 8:00 BREAK: Light refreshments
More time to network and ask questions...

8:00pm – 9.00pm Managing SQL Server in a global economic meltdown. - Iain Kick - Quest Software

IT departments don't make money, they spend it. As times are tough it's important we all find ways to spend less yet still do an effective job. After 5 years as a DBA and then 5 years spent meeting with hundreds of DBA's, Sysadmins, Developers, Managers and general IT people working with SQL Server I have identified some of the common tasks they could undertake to improve the performance, security and configuration pf their environments with little or no cost to the business.

User group evening with Tony Rogerson, Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown

16/09/2010

6.30pm – 7:30 TBC
TBC

TBC

7:30pm – 8:00 BREAK: Light refreshments
More time to network and ask questions...

8:00pm – 9.00pm Managing SQL Server in a global economic meltdown. - Iain Kick - Quest Software

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

23/09/2010

Agenda

18:30 - 18:45 - Introduction, Networking and Food

18:45 - 19:45 – Creating a cube with SSAS

Chris Testa O'Neill

This session will provide an overview of the steps required to create a cube in SQL Server Analysis Services. Exploring the use of Data Sources and data source views to define the source data that the cube will use. Understanding the importance of Dimensions and how hierarchies can be added to improve the user experience of browsing a dimensional data . To bringing the cube together with measures that will hold the business metrics that intersect each dimension in a cube.

Take this tour that will show you how to build a cube from the ground up, providng you with the ability to create you very own cubes so that you can query your data far more effectively

19:45 - 20:00 – Break

20:00 - 21:00 – Attunity CDC Product Demonstration

Ian Archibald

Description to follow shortly

UK SQL Server User Group Events Feed

Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill

Report Designer Controls

Data Visualisation

Report Builder 3

Extended Expression Support

Report Management

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.

User group evening with Tony Rogerson, Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown

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**

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