Previous Events – 2013

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

Leave a Reply