Previous Events

Tuesday 9th July 2013 Speakers to include Alex Whittles and John Martin

Alex Whittles – Data Modeling for Analysis Services Cubes
Abstract: Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.

In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data to optimise it for cubes and MDX. We’ll see how adding functionality into the ETL layer can have a dramatic effect on the functionality and simplicity of the cube.
Level 200

John Martin – SQL Server, the DBA and Compliance
Abstract: Compliance is something that we are all having to deal with and this is only going to increase with heightened privacy concerns and due diligence requirements in business. This session will cover three of the main areas that you are likely to have to deal with; Payment Card Industry – Data Security Standard (PCI-DSS), Sarbanes Oxley Act (SOX) and the UK Data Protection Act 1998 (DPA). I will look at what these standards are for and how they sometimes conflict. Information Heavy and Demo Light, this session will help you identify what you need to keep an eye on and I will show a couple of options on how to monitor who is doing what with your data.

———————————————————————————————————

 

Tuesday 11th June 2013 Speakers to include Chris Webb and Dave Morrison

Chris Webb will be presenting the following:

DAXMD: SSAS Multidimensional meets DAX and Power View

This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View. It will show how Multidimensional models are mapped to Tabular concepts, what works and what doesn’t work in DAX, how Power View works with Multidimensional models and what other benefits there are to using DAX with a Multidimensional model.

Dave Morrison will be presenting the following:

Myth Busters! Busting Common TSQL Myths

In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have.

———————————————————————————————————

Tuesday 9th April 2013 Speakers to include Jamie Thompson and Richard Douglas.

Jamie’s session will be around SQL Server Data Tools.

The Day After Tomorrow, whay you need to baseline – Richard Douglas

Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best-possible performance, you need to make sure you’re monitoring the right things. But how do you know if the figures you’re seeing are good or bad? Baseline comparisons can help, and in this educational session, SQL Server expert Richard Douglas will show you how to get the most from them. Richard will explain what a baseline is, why and when you need to take one, and how you can create one. You’ll also learn about a number of native Windows and SQL Server tools that will allow you to do just that.

———————————————————————————————————

Tuesday 12th March 2013 Speakers to include Tobiasz Koprowski and Richard Douglas.

High Availability of SQL in the context of SLA – Tobiasz

If SQL Server is heart of our environment, his health should be very important, right? If SQL Server is important, his availability for our businesses (internal and external) is important to. For our customers doesn’t matter where data are stored, how are stored and what we do with those data. Especially for our managers. The data must be available on demand, on time, at he moment of request. High Availability is our responsibility. How we can prepare our environment for HA? How HA is connected for with SLA? And why Service Level Agreement are important for us? In this session I want to discuss about HA options for SQL Server (2008, 2012), about our different customers, and about Service Level Agreement (formal or not).

Natural Born Killers, performance issues to avoid – Richard Douglas 

Join Richard, where you’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.

You’ll also learn how to take corrective action when:
•The optimizer isn’t using all available processors
•The database engine fails to report all the resources a query has used
•The optimizer uses the wrong plan
•Database tables cause memory issues

———————————————————————————————————

Tuesday 9th April 2013 Speakers to include Jaime Thomson and Richard Douglas.

Jamie will be speaking on the topic of SSDT.

Richard will be presenting his session “The Day After Tomorrow: Why you need to baseline”

———————————————————————————————————

Tuesday 12th February 2013 Speakers to include Annette and Jonathan Allen

LogParser-quicker than SSIS, easier than BCP – Jonathan

This session will introduce people to a free tool from Microsoft that will speed up adhoc data import processes and file parsing among other data manipulation uses. LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.
SSIS Basics – Getting SSIS to move and process data – Annette
In this session I will show you how to get started with SSIS, using task and data flow components to transfer data into and out of databases. Loosely based on the articles I have written for Simple Talk attendees will see how to get started with SSIS to solve simple ETL tasks.
———————————————————————————————————

Thursday 17th January – This event was been rearranged from December 2012.

Speakers to include Andrew Fryer and Neil Hambly

Andrew Fryer – Windows Server 2012

 

Neil Hambly – Using Extended Events”

Extended Events in SQL Server is the new tool for event tracing inside SQL Server introduced in the 2008 release, replacing it predecessor ‘SQL Profiler’, this session will focus on the ‘HOW’ to create effective Extended Event sessions, interpreting that information gathered to understand the events that are occurring inside SQL Server and aid in solving many DBA issues

Neil Hambly is a Senior DBA @ Confio Software, prior SQL Server roles during the last 14 years @ market leading companies (Accenture, ABN AMRO, BBC, MDSL).He has considerable experience in SQL Server starting with version 6.5 through to the latest 2012 release A regular International speaker @ SQL conferences & User Group, Leader of the SQL London PASS Chapter (UK) Frequently found studying the inner workings of SQL Server, as well as an avid Tweeter @Neil_Hambly

———————————————————————————————————

Tuesday 9th October
Speakers to include Chris Testa-O’Neill and Richard Douglas

Increasing Business and IT collaboration with SQL Server 2012 – Chris Testa-O’Neill

SQL Server 2012 provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case as used by a Coeo customer to present a business case for using SQL Server 2012 within your business.

Speaker Bio: Chris Testa-O’Neill Chris Testa-O’Neill is a SQL Server Microsoft Most Valuable Professional(MVP) and a Senior Consultant at Coeo specialising in SQL Server Business Intelligence. He is also a technical author, working on courses for SQL Server 2008 R2 with Microsoft Learning and advising on the SQL Server 2012 curriculum. Chris runs the Manchester SQL Server User Group and is an organiser for SQLBits. Chris has spoken at a range of events including user groups in the UK and Adelaide, Australia, SQLBits, the MCT Conference and this years SQLPASS. Chris is a Microsoft Certified Trainer (MCT), MCDBA, MCTS and MCITP in SQL Server.

Understanding Indices – Richard Douglas

When it comes to boosting SQL Server performance, few things can have as much impact as indexing. Join Richard Douglas as he provides unique insight about the value of indexing and shed light on SQL Server’s index architectures.    By the end of this session, you’ll know how to:

  • Find missing and unused indexes
  • Resolve fragmentation issues
  • Make the right indexing choices

———————————————————————————————————

Tuesday 14th August – MCM Night

Join Microsoft SQL Server Certified Masters Christian Bolton and Gavin Payne

Seeing double with SQL Server replication
SQL Server’s replication features have been around for a while now and don’t receive marketing coverage like some of the other features; however, they’re still commonly deployed in environments that need to move data between servers and for some requirements they’re the only feasible option. The first part of this session reviews the components that are unique to SQL Server replication, their limitations, and their benefits, and focuses on the transactional and merge replication technologies. The majority of the session time looks at some real-world replication architectures I work with; the design requirements they had, and the technology solutions which met them. Finally, some replication performance tuning recommendations end the session.

 

Tuesday 10th April
18:00 – 18:30 – Registration, Intro, Round Table discussion, Nuggets etc.
18:30 –  21:00 – Chris Webb + Chris Adkin

———————————————————————————————————

Tuesday 27th March – SQLBits special
Join us as we welcome two SQL Server MVP’s just a few days before the technical launch of SQL Server 2012 in the UK.
Jen Stirrup – Business Intelligence and Data Visualisation in SQL Server 2012
Kevin Kline – Ten Things Every Developer Should Know

———————————————————————————————————

Maidenhead SQL Server User Group – Tuesday 6th December

18:00 – 18:30 – Registration, Intro, Round Table discussion, Nuggets etc.

18:30 – 19:20 – Session 1 – David Morrison: The Dark Arts-a.k.a Performance Tuning, indexing and query plans.

 

In this session, rather than a traditional look at “query tuning” I will challenge some of the common misconceptions around tuning queries. It will also go into some detail around why sometimes the query optimiser chooses “odd” plans which perform poorly and how to help the optimiser choose a better plan. It will also take a brief look at SARGability, indexing and “inverse predicates” The session will mainly be held in management studio.19:20 – 19:40 – Sponsor session19:40 – 20:10 – Break20:10 – 21:00 – Session 2 – Chris Webb: Common SSAS Design Mistakes And How To Avoid Them

———————————————————————————————————

Inagural Meeting of the Maidenhead SQL Server User Group – Tuesday 4th October

Come along to see the birth!

Agenda

18:00 – 18:30 – Introduction and Networking

18:30 – 19:30 – Chirag Roy presenting “Troubleshooting Transactional Replication in the Wild!”

19:30 – 19:50 – Break
More time to Network and Food

19:50 – 20:50 – Justin Langford talking about the latest release of SQL Server (Denali)

20:50 – 21:00 – Feedback and Close