October Meetup – Ipswich

RESCHEDULED

APOLOGIES BUT DUE TO UNFORESEEN DIFFICULTIES WE HAVE BEEN FORCED TO RESCHEDULE THIS MEETING IN THE NEAR FUTURE. WE WOULD LIKE TO THANK MARK FOR HIS UNDERSTANDING AND FLEXIBILITY.

Lockless in Seattle: Using In-Memory OLTP for Transaction Processing

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.

Agenda

6.45 – Registration and pizza
7.15 – Session
8.15 – Close

Speaker

Mark Broadbent is a SQL Server MCM and Microsoft Data Platform MVP and has worked with SQL Server since 1997. He is the lead to UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, Hybrid Virtual Chapter and SQLEA User Group.

Twitter: @retracement

Where

Room W416
University Campus Suffolk (UCS) Waterfront Building
Long Street
IP3 8AH Ipswich
United Kingdom

When

Thursday 20th October 2016 – 6.45pm til 8.15pm

Eventbrite - SQLEA October Meetup - Ipswich

May Meetup – Norwich

RESCHEDULED

APOLOGIES BUT DUE TO UNFORESEEN DIFFICULTIES WE HAVE BEEN FORCED TO RESCHEDULE THIS MEETING IN THE NEAR FUTURE. WE WOULD LIKE TO THANK DAVE FOR HIS UNDERSTANDING AND FLEXIBILITY.

SessionDave Ballantyne

An Introduction to Execution Plans and The Query Optimizer.

One of the most complex areas of SQL Server is the Query Optimizer.
It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan.

This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine.
Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.

Agenda

6.45 – Registration and pizza
7.15 – Session
8.15 – Close

Speaker

    Dave Ballantyne

Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England. He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query. He has also created an open sourced add-in for SQL Server data tools (SSDT) called “TSQL Smells”. This detects and reports on ‘suspect’ code within a project and can be found at https://github.com/davebally/TSQL-Smells . Outside of work he is husband, father of 3 and exasperated archer

Twitter: @davebally

Where
Jarrold Training
St James’ Mill
Whitefriars
Norwich
Norfolk
NR3 1SH

When

Tuesday 24 May 2016 – 6.45pm til 8.15pm

 

April Meetup – Ipswich

Power BI: Is It Any Good?chris_2_400x400

You’ve heard all the hype about Power BI. You’ve seen that Microsoft is a leader in the latest Gartner Magic Quadrant and read all the blog posts about cool new functionality. Things are certainly changing fast in the world of Power BI, but the big question is: is it any good? Can I use it? How is it different from the ‘old’, Excel-centric Power BI? How does this fit with what’s planned for BI in SQL Server 2016? In this session you’ll find answers to all of these questions, see some demos of the new Power BI, and by the end be able to make your mind up about whether Power BI is for you or not.

Agenda

6.45 – Registration and pizza
7.15 – Session
8.15 – Close

Speaker

Chris Webb is an independent consultant specialising in Analysis Services, MDX, Power BI, Power Pivot and Power Query. He is the author of “Power Query for Power BI and Excel” and a co-author of “SQL Server Analysis Services 2012: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”. He blogs at http://blog.crossjoin.co.uk

Twitter: @technitrain

Where

University Campus Suffolk (UCS) Waterfront Building
Long Street
IP3 8AH Ipswich
United Kingdom

When

Tuesday 26 April 2016 – 6.45pm til 8.15pm

Eventbrite - SQLEA April Meetup - Ipswich

January Meetup – Ipswich

Prathy KamasaniWhat’s new in SQL Server 2016 for a BI Professional

Finally, the wait is almost over. After few years of silence, Microsoft has finally made exciting announcements about SQL Server on premises enhancements.

In this session, I will cover top new features in SQL Server 2016 from a BI professional perspective. You will get an up to date overview of key improvements of MDS, SSIS, SSRS, SSAS as well as PowerBI and R.

Agenda

6.45 – Registration and pizza
7.15 – Session
8.15 – Close

Speaker

Prathy Kamasani is an independent Microsoft BI contractor in London. She is active in the SQL Server community as a volunteer and a speaker.

Twitter: @pkamasani

Where

University Campus Suffolk (UCS) Waterfront Building
Long Street
IP3 8AH Ipswich
United Kingdom

When

Thursday 28th January

Eventbrite - SQLEA January Meetup - Ipswich

The SQLCambs Yuletide Meetup

I’m delighted to announce a special Yuletide Edition of the Cambridgeshire SQL Server User Group on Tuesday 9th December 2014 from 6:00 PM to 9:00 PM. We are delighted to have Tony Davis giving his first ever presentation for the User Group and Mark Broadbent will be giving his first for us in over 2 years. The agenda will be as follows:

  • 18:00 – Registration
  • 18:15 – Session 1 – Tony Davis presenting on “You did WHAT to my transaction log?!?!”
  • 19:15 – Break
  • 19:30 – Session 2 – Mark Broadbent (MCM) presenting on “Ye Olde Cluster Curiosity Shoppe – Clustering Tips, tricks and oddities”
  • 20:30 – Close!

To register for this meetup, please head over here.


Session 1: Tony Davis – You did WHAT to my transaction log?!?!

You won’t believe what people will do to the transaction log when they get into trouble. The log is full! The application is experiencing strange errors! Do something! In this session, I will apply commonly suggested advice from internet search results and various forums, in search of a fast remedy for explosive log growth. How bad could it be?

Fortunately, once you understand what the transaction log looks like, how SQL Server uses it to guarantee database consistency, and the factors that can prevent reuse of log space, the dangers of ‘quick fix’ advice will become readily apparent, as will the right way to diagnose and fix a full log file.

Note: no production servers will be harmed during this presentation.

Tony Davis is the editor of Simple-Talk.com and SQLServerCentral.com websites and newsletters, with a combined audience of over 1.5 million subscribers.  Tony specializes in databases, and especially SQL Server. As the editor behind most of the SQL Server books published by Red Gate, he spends much of his time helping others express what they know about SQL Server. He is also the lead author of the book, SQL Server Transaction Log Management. In his spare time, he enjoys running, football, contemporary fiction and real ale.

Session 2: Mark Broadbent – Ye Olde Cluster Curiosity Shoppe – Clustering Tips, tricks and oddities

Welcome to the strange and mysterious world of SQL Server Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting SQL Clusters. Roll-up, roll-up! Come and see :- The horrifying “Shrunken Head” The stomach turning “Bearded Lady” The incredible “Many-Headed Cluster” The mystifying “Marie Celeste” The unbelievable “Zombie” The doom ridden “Installation of Death” The nightmare inducing “Bodysnatcher” The malevolent “Montezuma’s Revenge” …and many more freakish exhibits and top tips from the field of SQL Server Failover Clustering!

Mark Broadbent is a SQL Server Microsoft Certified Master and event lead to SQLSaturday Cambridge, the UKs first ever SQLSaturday. A frequent speaker at international events, User Group and Virtual Chapter leader and current PASS UK Regional Mentor, Mark is always looking to support and grow the global Community.

Registration will start from 6.00pm. Nibbles and refreshments will be provided.