January 2018 Meetup – Ipswich

Session 1 – SQL Server on Linux

We’ve all joked about running SQL Server on Linux, but now you can. In this session David will cover the Microsoft journey of making SQL Server work on Linux, getting started and the those all important limitations and gotchas of running SQL Server on Linux.

Eventbrite - SQLEA Jan Meetup - Ipswich

Speaker – David Williams

davidDavid Williams is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both local/central government and private customers, include a Fortune 50 investment bank. Certifications include MCSE Data Platform/Data Management and Analytics as well as certifications in all the other products.

David is also an IBM Champion and has started his own company Blue Rose Quantum Consulting.

Twitter: @smooth1x1

Session 2 – Introduction to Azure Analysis Services

A basic introduction into Azure Analysis Services covering what it is, how you buy/cost it, when it should be used and when it shouldn’t.

Eventbrite - SQLEA Jan Meetup - Ipswich

Speaker – Chris Webb

chris_2_400x400Chris 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 blog.crossjoin.co.uk

Twitter: @cwebb_bi

Agenda

6.15 – Registration and pizza
6.45 – Session 1
7.45 – Break
7:50 – Session 2
8.50 – Close

Where

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

When

Monday 22nd January 2018 – 6.15pm til 8.50pm

Eventbrite - SQLEA Jan Meetup - Ipswich

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.

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.