Author Archives: retracement

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

 

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.

User Group Meetup #9 (the rescheduled meeting)

I’m delighted to announce a one-time only joint session meetup between the Cambridgeshire SQL Server User Group and the East Anglia SharePoint User Group on Tuesday 23 September 2014 from 6:30 PM to 9:00 PM, and as such we have chosen two excellent cross-platform sessions that we think will appeal to your all. We have excellent speakers in Penny Coventry and Francois Souyri who will wow you with the sessions below. The agenda will be as follows:

  • 18:30 – Registration
  • 18:45 – Session 1
  • 19:45 – Break
  • 20:00 – Session 2
  • 21:00 – Close and SharePint (or is this SQLPint)

To register for this meetup, please head over here.


Session 1: Penny Coventry – Creating and Enhancing Access Web Apps

In this session, after a brief introduction on how to use Microsoft Access 2013 to build Microsoft SharePoint apps with a full SQL Server database, she will enhance the Access app, by directly connecting to the apps SQL Server database; thereby the app can be enhanced using several methods, such as, using Business Connectivity Services (BCS), Microsoft Visio 2013 and several Business Intelligence technologies. Although this session only includes no-code demonstrations, she will be discussing techniques that Business Analysts, SharePoint and SQL Server experts tend to use and will show that once the experts have completed their configuration, power users can quickly enhance Access Web Apps. Penny will highlight any limitations between using Office 365 or an on-premises installation of Microsoft SharePoint 2013.

Session 2: Francois Souyri – BI Tools in Office 365

There has been a lot of noise about PowerBI since its beta over a year ago. Does it mean we have to developing bespoke reports soon ? What does it mean for my BI road map ?
This session will attempt to describe where Microsoft is leading us , which tools are revolutionising data acquisition and reporting and why it makes sense to follow this path.
In a live demo we will extract some data from a SharePoint site, visualise them meaningfully with PowerPivot, PowerView, PowerMap and finally publish them back to Office365 PowerBI and PowerQ&A to close the circle.

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

Usergroup meetups #8 (31st July) and #9 (28th August) announced!

In keeping with our recent attempt at “last Thursday of the Month” I am happy to announce 2 more meetup dates of SQL Server sauciness.

Speakers and presentation details are being finalized, but book now if you want to guarantee your places.

Meetup #8 is on the evening of Thursday 31st July. Registration from 6. Eventbrite - Cambridgeshire SQL Server User Group #8

The first presentation of the evening is by Dave Ballantyne (web|twitter) who will talk on Estimation, Statistics : The basis of query optimization

Dave a data architect work for Win Technologies part of the Betway group.  He is a regular speaker at UK events such as SQL Bits and user groups and founder of the SQLLunch/SQLSupper User Groups.

Abstract
At the heart of SQL Server is the cost based optimizer.  Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken.  How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t.  It estimates!
How does it estimate ? That is statistics.

This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.

Our second speaker of the night is Alex Yates who will be teaching us about Building an automated database deployment pipeline

Alex has worked with database change management tools for four years, collaborating closely with users and dev teams along the way. As a pre-sales engineer, he gets to see a huge variety of server and dev environments, and helps folks solve their database development and delivery problems in whatever way works well for them. Ever the sharer, he also blogs about the lessons he learns: www.workingwithdevs.com

Abstract
The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.

Thank you as always to our kind sponsors Redgate for providing the venue and nibbles!


Meetup #9 will be on the evening of Thursday 28th August. Registration and frolicks from 6. Eventbrite - SQLCambs User Group Meetup #9

User Group Meetup #7 on 29th May with Grant Frichey!

Yes we are (finally) back for another exciting SQLCambs User Group Meetup and what better way to kick off proceedings than a double bill by the most magnificent Grant Frichey (blog|twitter), the Scary DBA. If you are not already aware, Grant is one of the leading experts on the SQL Server Query Engine and internals and is the author of several excellent books on the subject and related areas. Grant is a SQL Server MVP with over 20 years experience in IT including time spent in support and development and has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java and volunteers at PASS with the Editorial Committee and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011.
Eventbrite - SQLCambs User Group Meetup #7 with Grant Frichey!

Session 1: Getting Started Reading Execution Plans

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what’s important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You’ll learn where to start, what to look for first, and you’ll be better prepared to tune your queries. We’ll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.

Session 2: Building a Database Deployment Pipeline

The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.

Redgate Golden Nugget

(Bigdata/ Hadoop lightning talk)

Registration will start from 6pm. Food and drink will be provided thanks to the generosity of our user group sponsor Redgate