Welcome to the SQL London Chapter
We hold regular meetings which are usually every 4-6 weeks and these are spread around different venues in London, Each event registration has the full details on the venue hosting the event.
We try to ensure the content presented is always relevant to our members, and we welcome your suggestions on topics you would like us to cover, unless otherwise noted the schedule for our meetings follow this usual format.
18:00 - 18:20 - Welcome & Registration - SQL Nuggets & other Announcements
18:15 - 19:15 - 1st Presentation
19:15 - 19:45 - Host Presentation (somtimes)
19:45 - 20:00 - Refreshments & Networking
20:00 - 20:50 - 2nd Presentation
19:50 - 21:00 - Wrap-up, Question & Answer session
If you experience difficulty finding the locations, please feel free to ask for directions
Phone: 07557016028 (Neil Hambly) or via Twitter: Neil_Hambly
|
|
|
April 2013
|
Topic:
|
|
|
Date:
|
Thursday, April 25th 2013 6PM – 9PM
|
|
Speakers:
|
6:00 - 6:20pm Registration and networking
Meet and greet.
We brings you news of latest from the world of SQL Server & upcoming events
Neil Hambly (Confio Software)
This is the Conference Session Neil is presenting @ the PASS Business Analytics 2013 Conference (Chicago)
Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.
High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.
7:30 – 8:00pm Break: Light refreshments & Networking
More time to network, ask questions and eat dinner..
8:00 – 8:30pm Partitioned Table Spinlocks
Christian Bracchi (IMGROUP)
This Session will cover resolving bottlenecks when loading Partitioned tables with clustered indexes using xperf which is part of the windows Performance toolkit.
8:30pm – 8.50pm Q & A Roundtable (Everyone)
Join in and perhaps win prizes from Redgate {Top Questions}
Bring you tough SQL Questions for answering
Venue directions: http://www.imgroup.com/Documents/Contact_us/Directions.pdf
|
|
Location:
|
IMGROUP, Harmsworth House, 13-15 Bouverie Street, London, EC4Y 8DP |
|
Overview:
|
Partitioned Table spinlocks, MDS, DQS
|
|
Sponsor:
|
PASS, IMGroup
|
May 2013
|
Topic:
|
|
|
Date:
|
Thursday, May 7th 2013 6PM – 9PM
|
|
Speakers:
|
6:00 - 6:20pm Registration and networking
Meet and greet. (Time to bring you upto date with the latest in the world of SQL Server events)
6:20 – 7:20pm Kevin Kline (MVP)
End-to-End Troubleshooting for SQL Server
Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
In this session, attendees will follow a problem situation on SQL Server, through use of the native tools that help SQL Server remain problem free and at peak performance. This session demonstrates the tools and techniques to make difficult troubleshooting scenarios much faster and easier. We’ll cover:
- Performance Monitor (PerfMon)
- SQL Profiler/Server-side Trace
- Correlating PerfMon and Profiler results
- Using Dynamic Management Views (DMVs)
- Advanced Diagnostics Using Wait Stats
- Graphic Execution Plan and Transact-SQL Showplan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
7:20 – 7:50pm Break: Light refreshments & Networking
More time to network, ask questions and eat dinner..
7:50 – 8:50pm Speaker #2
Abstract of session to be posted soon
Registration link http://sqlserverfaq.com/?eid=525
Venue directions: http://www.microsoft.com/en-gb/about/offices/london.aspx
|
|
Location:
|
http://www.microsoft.com/en-gb/about/offices/london.aspx |
|
Overview:
|
These presentations will be on
|
|
Sponsor:
|
PASS, Confio
|
|
|
|
Other Events Neil Hambly is presenting @ in the UK/international in the near future
PASS Business Analytics Conference (10th -12th April, Chicago)
Also be attending and presenting @ the PASS Business Analytics 2013 Conference in Chicago {10th - 12th April)
Visit the website for more detials http://passbaconference.com/
Cardiff SQL UG - 28th March
I'll be doing my session on Extended Events {one of my favorite ones I have}
PASS SQLSaturdays
I'll be presenting @ the Madison #206 & Chicago #211 events that are the weekend either side of the PASS BA Conference
I'll be presenting also @ the Boulder (16th April) & Denver (18th April) UG whilst I'm in the US
SQLBits XI
SQLBits XI is gettign closer and I believe is now FULL, I will presenting my SQL Server Memory Management session http://sqlbits.com/Sessions/Event11/SQL_Server_2012_Memory_Management
SQLRelay 2013
we have the annual upcoming series of events , with the last one being London on 27th June - full details of the events will be posted on the www.SQLRELAY.co.uk web site - stay tuned for the exciting information
|
|
|
DataArch Virtual Chapter Dec Presentation
| |
| Subject: |
Introduction to Microsoft’s Master Data Services (MDS) |
| Start Time: |
Wednesday, Dec 20th, 2012 1:00 PM US Eastern Time |
| End Time: |
Wednesday, Dec 20th, 2012 2:00 PM US Eastern Time |
| Presenter: |
James Serra |
| Live Meeting Link: |
https://www.livemeeting.com/cc/usergroups/join?id=4HQDRK&role=attend&pw=p%7E%29%7B%22X%2B4h
|
Introduction to Microsoft’s Master Data Services (MDS)
Speaker: James Serra, BI/Data Warehouse/MDM Architect and Developer Serra Consulting Services
Summary: Companies struggle with consolidating the same set of data from multiple systems to accurately report on critical business information. For example, having customer lists in multiple systems that often have the same customer in more than one list, sometimes with a different spelling. Master Data Services is bundled with SQL Server 2012 to help resolve many of the Master Data Management issues that companies are faced with when integrating data. In this session, James will show an overview of Master Data Services 2012, including the out of the box Web UI, the highly developed Excel Add-in, and how to get started with loading MDS with your data.
About James: James is currently a Data Warehouse/Business Intelligence/MDM architect and developer with over 25 years of IT experience. James started as a software developer, and then was a DBA for 12 years, and for the last six years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant and contractor. James is a noted speaker, blogger, and contributing editor for SQL Server Pro magazine.
|
|
|
|
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.
PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
|
|