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

SQLCambs User Group Meeting #6 with Jen Stirrup, Peter Baddeley and Stephanie Herr

6.15 pm – Stephanie Herr – Source control, unit testing, and continuous integration for database development

This session focuses on why you should source control your database and shows how easy it is to do within SSMS using Red Gate’s SQL Source Control.  Once your database is in source control, it can be brought into your continuous integration environment so that it can be built and tested alongside your application changes.
7.00 pm – Jen Stirrup – Big Data Overview for the Microsoft Business Intelligence Professional
Big Data is the latest buzzword, and we will demystify the Microsoft offering of Big Data technology in an overview, aimed at SQL Server Business Intelligence professionals. Microsoft have partnered with HortonWorks to bring Big Data into the hands of business users via their favourite Business Intelligence tools – Power View, PowerPivot and Excel.
We will review the Microsoft distribution of Hadoop, covering a range of technologies such as HDInsight, Hive, Azure right through to Excel, PowerPivot and Power View.
The first half of the session will be dedicated to the ‘what’ and ‘how’ of Hadoop, using HDInsight. Now that we have our Big Data, how are we going to serve it to business users in order to derive value for the enterprise? The second half of the session is dedicated to the ‘why’ of Big Data. We will visualise Big Data in our favourite Business Intelligence tools – Excel, PowerPivot and Power View.
Business Intelligence professionals will need to know about Big Data, and come to this session to learn about implementing Big Data for your enterprise.
8.00 pm – Peter Baddeley – I work with SQL why should I care about SharePoint
SQL is fundamental to every deployment of SharePoint, and increasingly many organisations have or are planning some form of SharePoint deployment. As a SQL Professional you can’t ignore SharePoint, and instead you should be actively engaged in its implementation to be to better support the solution.  This session will be an introduction to some of the key considerations around SQL for SharePoint including different database, sizing, naming and a few common issues encountered. It will also introduce the SharePoint integration to Reporting Services which has been enhanced in SQL 2012.  The session will be relevant to you regardless of your version of SharePoint, and will also introduce considerations for SharePoint 2013.  Finally it will make the case that you how and why you should get actively in your organisations SharePoint deployment.

The SQLCambs Meeting #3

Register for SQLCambs User Group Event #3 in Cambridge, Cambridgeshire  on Eventbrite

Arrival

18:00-18:30 Registration, Refreshments and food

The Special Redgate Sponsor Session

18:30-19:00 SQL Connect and SQL Source Control – David Simner
19:00-19:10 Break

The Warm Up

19:10-19:40 Upgrading to SQL Server 2012 – Mark Broadbent

“Sooner or later your organization is going to want to upgrade some or all of its SQL Server estate.
The question is are YOU prepared and ready?
What is your upgrade path going to be, what are your options and how are you going to perform it? More importantly how do you ensure that your migration is successful? All these questions and more will be discussed and demonstrations given for SQL Server running on Windows Server Core and coverting your Mirrored databases to AlwaysOn Availability groups.”

19:40-19:50 Break

The Main Event

19:50-20:50 Real-world virtualisation advice for the SQL Server professional – Gavin Payne

“Virtualisation seems to be around us everywhere these days, including within our SQL Server estates, yet for those without direct experience of it there can often be feelings of uncertainty or the unknown.  This session aims to cover why and how we might use SQL Server and virtualisation together successfully, along with the knowledge to help you confidently design, deploy and manage virtual SQL Server 2012 environments.”

Departure

20:50-21:00 Wrap up and Close

Places are limited so book now to avoid disappointment!

Register for SQLCambs User Group Event #3 in Cambridge, Cambridgeshire  on Eventbrite