Tag Archives: Meetup

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.

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