Welcome to the London PASS Chapter

We are an established PASS Chapter covering London. 

We look forward to meeting you! To contact us, please visit the About Us page. 

Please find details of the next meeting below.

Registration for the event via following links

http://www.meetup.com/London-SQL-Server-User-Group/

SQL London PASS Chapter Team

Next Meeting

Tuesday,

June

14

INSIDE-SQL Conference

  • In-Person @ CodeNode (Skillsmatter) London, Greater London, United Kingdom (map)
  • 08:30 - 18:30 UTC
  • Language: English

14th June 2016 is a date your want to save in your calendar to attend our 1-day SQL Server advanced training.

London PASS Chapter proudly presents their advanced level conference covering the Data Platform “INSIDE-SQL”

Visit our event website for all the details of tracks & presenters we have for this event
http://insidesql.co.uk   

Tickets Now Available

PASS London chapter members who attend our events in 2016 can use a discount code for £15 off a ticket
Please use discount code: PASSLDN

With everybody from those just starting out thier careers through to those with a ton of experience, all of us need to continue to learn and the majority of sessions in conference are 60 minutes or less, with only a handful covering advanced level material.

We wanted to provide a 1 day conference that was dedicated to providing Deep-Dives on topics, we felt it was missing and needed, so prior experience is a requirement but one that’s essential as we skip straight to tackling the advanced topic material (level 300-500) this is often only found for a handful of sessions even at larger conferences, in our advanced sessions we deliver at INSIDE-SQL we also allow more time those need with a full 90 minutes to really go deep on the topics.

Each session is followed by a lengthy breaks before the next session commences, no more running from session to session, giving you the time to ask those questions during and even after the session without missing the next session, take some time to network with your peers, colleagues & friends, maybe discuss that previous session or the troublesome work issue you working on, grab yourself a refreshment and give yourself a quick ‘Brain Breather’ before the next session 
{something tells me you’ll going to need them}.

We’ll have different sessions and presenters for you to Deep-Dive with in the DBA / DEV / BI-Azure tracks, of course you choose which session to attend, knowing that the recordings are there to watch later for those you missed.

What will these sessions be on? We have built a range of sessions for the 3 tracks and those details are on the website.

If you can’t attend the whole day of sessions, we understand your predicament and it is not a problem, just attend those sessions you can in one of the newest and best conference venues in London, and watch those sessions you missed on the recordings that will be available on USB following the conference.

Costs: We have made this a really LOW COST one to attend and we think you will find this more than an affordable price and definetely worth the low admission costs

Tickets are now available  So take advantage of the early bird pricing today, as that ends on 14th May

We have an amazing line-up of MCM’s, MVP’s, PHD’s and International Presenters to bring you deep dive content you will not want to miss.

Featured Presentation:

Responding to Extended Events in Near Real Time

Gianluca Sartori, DBA sqlconsulting.it

Extended Events provide deep insight into SQL Server's behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking. In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions.

About Gianluca:
Gianluca Sartori is a SQL Server MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.

Powerful T-SQL Improvements that Reduce Query Complexity

Hugo Kornelis, Database Consultant JuTi Holding BV

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!

About Hugo:
Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was a SQL Server MVP from January 2006 to December 2016. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.

Revolution R models in SQL 2016 Reporting Services

Dr Subramani Paramasivam, Principal Consultant DAGEOP Ltd

We have seen SSRS getting better and better in every single release and SQL 2016 is a mind blowing upgrade of whatever we have seen thus far from Microsoft. With this SQL 2016 new features, we can easily embed R statistical models within SSRS. As we have always seen a steady growth in SSRS since 2005, we now have much more advanced brand new features in 2016 SQL Server Reporting Services, beyond our imagination. Sit tight and buckle up for an amazing roller coaster ride, to not only briefly see the advanced SSRS killer features but also some of the R statistical charts within SSRS 2016 and the new user interface of Report Builder.

About Dr Subramani :
Dr.SubraMANI Paramasivam is a Microsoft Certified Trainer and Principal Consultant at DAGEOP Ltd having 18+ years of DB & BI experience. He likes to enlighten the education & data and started his own FREE data awareness programme (www.dataap.org) in remote areas who are in need. He speaks a lot about Performance Tuning, Analytics, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.

Loading SQL Server Data with Powershell

Sean McCown, Owner MidnightSQL Consulting

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

About Sean:
Sean McCown is a Certified Master in SQL Server 2008 and a SQL Server MVP with 20 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight.

Encryption in SQL Server in AD 2016

Tobiasz Koprowski, Independent Consultant, Trainer Shadowland Consulting

Imagine that 'Moment', when you get message from your boss at Friday late afternoon: "We will have audit next month, and if I remember well... we have some personal data which should be secured. Could You please be ready for it?". Thankfully we have few days till the audit, so... Let's look what options for encrypting our data we have. Newest SQL Server 2016 is installed on one of our servers, but we still have 2014 and some older versions. In my session I will focus on implementation of encryption methods and techniques which we can use for improve security of our data with SQL Server 2016 and Azure Cloud Services, as well comparing previous options for earlier version of SQL Server. Implementation of TDE (Transparent Data Encryption), Always Encrypted and DDM (Dynamic Data Masking) for Enterprise Architecture, symmetric or asymmetric encryption, DES, 3DES, AES and other algorithms. Finally best and worst practice for implementation. And price list for all of those stuff.

About Tobiasz:
CEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in West Bridgford (England). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, freelancer and consultant. Subject Matter Expert at CQURE. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. Member of the boards: PTI & ISSA (Poland's Chapter). Since 1st July 2010 Data Platform MVP. Former President of the Polish SQL Server USer Group. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conf

Hi there, I’m Cortana: Cortana Analytics and Power BI

Jen Stirrup, Director Data Relish

Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. In this talk, you will get an underpinning of analytical modelling, along with demos of visualizing data and getting insights via Power BI and the challenges of building a SaaS service at scale. Major features of new Power BI will be covered with demos, including natural language query, and others, in the context of Cortana Analytics. Come and learn what model to use when, and how to use data storytelling to display the results meaningfully. Deep analytics and analytics-based intelligent action is available to everyone in the form of Cortana Analytics, and visualised with Power BI. Join this session to learn about this exciting technology to obtain organisational insights from your data.

About Jen:
Jen Stirrup, MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen is a GigaOM Industry analyst and data thought leader, running a boutique analytics consultancy, delivering strategic advice to companies large and small. Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

Why are we waiting?

Gail Shaw, Technical Lead Entelect

While the waits and queues performance tuning methodology is well known, there can be some confusion still about what various waits mean and what, if anything, needs to be done about them. In this session we’ll take a dive into the SQL Server execution model and see why waits occur, and then look at some common waits and see what causes them and what they mean.

About Gail:
Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She's a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related.

Now Where Does THAT Estimate Come From?

Hugo Kornelis, Database Consultant JuTi Holding BV

The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are used to estimate row counts, and how filters and joins further influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn some ways to fix the problems and get better estimates - and hence, better performing queries.

About Hugo:
Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was a SQL Server MVP from January 2006 to December 2016. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.

How to move databases around in Azure

André Kamman, SQL Server Solutions Architect CloudDBA.io

The most mundane task of the DBA that we all thought we could do with our eyes closed has become complicated again. There is no single, simple backup/restore (or import/export) story for on-premises databases, databases in SQL Server on an Azure VM and Azure SQL Databases. In this session we will look at the various ways to archive and move databases around with the Azure (hybrid) cloud. Learn how to: Move data between SQL Server and Azure SQL Database Move data between your datacenter and Azure Create backups for long term storage to comply with your corporate data retention policy Create (automated) database copies for your developers We will discuss the various options and their respective pros and cons. This session will restore (pun intended) your confidence in your backup/restore skills.

About André:
André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland.

The Backup Tune-up

Sean McCown, Owner MidnightSQL Consulting

Have you ever gotten tired of your database taking hours to back up? Are you sick of your users breathing down your neck because the database restore is taking too long? Now you won't have to worry about that anymore. In this session I show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. You'll learn about the backup "execution plan" and how to access it. Understanding how to tune the individual portions of your backup process will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15 years to tune my backups and I’ve had great success.

About Sean:
Sean McCown is a Certified Master in SQL Server 2008 and a SQL Server MVP with 20 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight.

Advanced T-SQL Technique

Gianluca Sartori, DBA sqlconsulting.it

Writing SQL queries is not hard, but writing high performance queries is not always simple. Obviously you need to know thoroughly all the language constructs offered by T-SQL, but it is equally important to be creative and capable of thinking outside the box. In this session we will use well known and lesser known T-SQL constructs to obtain better performing code, sometimes in surprising and unexpected ways, with a look at what to expect from SQL Server 2016. We will also introduce some patterns to solve complex problems (e.g. assigning stock to orders) and the techniques to overcome them successfully.

About Gianluca:
Gianluca Sartori is a SQL Server MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.

Introduction to Data Science: Agile Analytics with AzureML

Jen Stirrup, Director Data Relish

Business analytics platforms have always been tools built for statisticians and data scientists. However, these tools are increasingly being directed at business analysts, and Gartner's rankings on its well-known "completeness of vision" and "ability to execute" axes now ride as much on "ease of use" as they do on offering advanced analytical algorithms.How does this change in landscape affect businesses? Are you new to the world of business analytics? Are you taking over an existing analytics program, or starting one from scratch? This session will help you to understand how to craft a strategy, provision the right business analytical capabilities, and move towards actionable results. We’ll identify common pitfalls to avoid as you start or reinvigorate your business analytics program. In particular, we’ll explore how companies are using self-service and data discovery techniques to deliver more agile analytics using Azure Machine Learning. We’ll identify common pitfalls to avoid as well as notes from the field, so join me for a practical session with takeaways you can start using straight away.

About Jen:
Jen Stirrup, MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen is a GigaOM Industry analyst and data thought leader, running a boutique analytics consultancy, delivering strategic advice to companies large and small. Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

Inside SQL Server indexes

Gail Shaw, Technical Lead Entelect

Ever wondered what indexes look like at the page level? Or how an index’s design affects the query optimiser’s choices of plan? Wonder no more. In this session we’ll dig into index internal structures and look at how different index design choices affect the index architecture. After that we’ll look at some uses of indexes that are a little beyond the normal use of supporting WHERE clause predicates.

About Gail:
Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She's a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related.

Getting release management right for SQL Server

Alex Yates, Director DLM Consultants

This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’ve set up some sort of automated build and regression testing process. (Or you’ve been to my continuous integration session.) However, your deployments are still expensive and risky. You find it hard to keep track of what has been deployed to each environment. You don’t have a great deal of confidence that the production database is still in line with source control. You may have heard of the automated deployment functionality in VSTS or Octopus Deploy but you haven’t tried it yet… at least not for SQL Server. In this session I’ll automate a deployment pipeline in a couple of different ways. I’ll discuss the importance of your database model as well as repeatable upgrade scripts and discuss the pros and cons of different approaches to automation. I’ll also discuss how to monitor for and protect yourself from database drift. By the end you will have a better idea about which strategy will suit your databases.

About Alex:
Alex is a Data Platform MVP who loves DevOps. Alex has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyone who researches penguins. A keen community member, he helps organise the London Continuous Delivery meetup and SQL Relay. He blogs at workingwithdevs.com, speaks wherever they'll let him and manages the DLM Digest monthly email: a report on the latest database DevOps news/tutorials. He's quite fond of nutella. And otters. (Not together

Hyperscale technology lets a DBA sleep, +30 minutes a day!

Dr Subramani Paramasivam, Principal Consultant DAGEOP Ltd

Ease of access and easy life is now possible with On-premises and hybrid cloud technology using SQL Server 2016. SQL 2016 Hyperscale technology gives us a huge relief in Backups, Disaster Recovery solutions, access resources no matter whether they are in on-premises, private or public cloud. New tools within SQL Server 2016 and Microsoft Azure has made every single DBA/Developers life much easier to scale to the cloud. This session will enable you to start working on scaling to the cloud and benefit from the SQL Server 2016's advanced new features.

About Dr Subramani :
Dr.SubraMANI Paramasivam is a Microsoft Certified Trainer and Principal Consultant at DAGEOP Ltd having 18+ years of DB & BI experience. He likes to enlighten the education & data and started his own FREE data awareness programme (www.dataap.org) in remote areas who are in need. He speaks a lot about Performance Tuning, Analytics, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.