SQL-Bristol Evening Session (April 2017)

Apr 25, 2017 · Temple Quay, United Kingdom

For our third evening session, we are very pleased to have two excellent speakers lined up.  This time round, the meeting is being held at the offices of Ovo Energy who have generously agreed to host us.

Terry McCann

Why TSQL was language of the year! (Database Developer/Administrator)

TSQL was voted best programming language in 2013, let’s explore why! In this session we will explore what make SQL such a fascinating language. We will do this through looking at a few real life problems and common design challenges.  What in particular will we look at? Well… Tally tables, CURSORS, hidden CURSORS, CTEs, Recursive CTE, Manual Pivot, TSQL Pivot, CROSS JOIN, CROSS APPLY, CORRELATED QUERIES, STUFF(), RANK(),GO, DENSE_RANK(),LAG(), LEAD(), ROW_NUMBER(), XML PATH, MOD %,  STRING_AGG(), DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE, STATISTICS IO & TIME.  (A bit of TSQL)

Bio:

Data warehouse/Big data/Data science consultant for Adatis consulting limited a Microsoft Data & Analytics consultancy. Passion for advanced analytics and automation. Specialising in Microsoft BI architecture. Frequent speaker at SQL Saturdays in the UK and Europe. Organiser of the Data Science user group in Exeter and previous co-organiser of SQL Saturday Exeter. 

Simon Whiteley

Azure SQL DataWarehouse Reflections (Cloud Services)

Azure SQL DataWarehouse is here and being pushed as the answer to huge structured data stores in the cloud, but what does that mean to you? Reflecting on a large-scale Azure SQLDW project, this session gathers together learnings, successes, failures and general opinions into a crash course in using Azure SQL DataWarehouse “properly”.

We'll start by quickly putting the technology in context, so you know WHEN to use it, WHERE its appropriate and WHY it works the way it does.

• Introducing the SQLDW technology

• Explaining distributions & performance

• Explaining polybase

We will then dive into HOW to use it, looking at some real-life design patterns, best practice and some “tales from the trenches” from a recent large Azure SQLDW project.

• Performance tips & tricks (designing for minimal data movement, managing distribution skew, CTAS, Resource classes and more)

• ETL Patterns (Surrogate keys & Orchestration)

• Common Mistakes & Pitfalls

• Conclusions & Recommendations

Bio:

Simon is a principal consultant with Adatis Consulting, a Microsoft Data & Analytics consultancy. Emerging from a world of traditional BI structures, Simon is now obsessed with utilising cloud technologies to revolutionise these traditions. He’ll dive into any interesting BI problem, whether it’s ETL patterns, analysis models, lakes, custom 3D visualisations or dabbling in cloud new architectures.

Event organizers
  • SQL Bristol

    SQL Bristol has been formed to offer knowledge sharing and networking opportunities for data professionals, techies, researchers or simply those with an interest in data applications and technologies. We aim to have an open, friendly and informal setting for meetings covering a wide range of topics with a predominant, but not exclusive, focus on the SQL Server platform.  Events generally cover the following subject areas: - • Business Intelligence • Database Administrator • Database Developer • Advanced An

    Recent Events
    More

Are you organizing SQL-Bristol Evening Session (April 2017)?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews