[EN] SQL Relay Autumn Tour – Day Four

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Fourth day in Caerdydd. Last day of first week of tour. Wales. Cymru. Cardiff. Caerdydd. I have been in Wales once, one year ago I just back from SQL Saturday Dublin to United Kingdom via ferry and Holy Head. And I have been in Cardiff once, when I changed my train. But this time I travel on different route via super great three miles long The Second Severn Crossing (Welsh: Ail Groesfan Hafren LINK). Really amazing.

IMG_8009

We park our bus on big mall car park, and moved for pint of local beer and next green curry. In Cardiff I spend two nights in really great citi center located hostel in good bunk bed room, and friendly stuff. And just to three minutes from St Davis Hall (Welsh: Neuadd Dewi Sant). Very interesting, multi cultural place and we got three levels: level two with speakers room, level three for reception desk, dba sessions, alttech sessions keynote and lunch, and finally level five for bi sessions. And here we had another great agenda:

Keynote | Microsoft
Sponsor Sessions by Microsoft & Acorn

SQL Server / DBA
Help, my table’s too big! | James Skipwith
Designing, Implementing and Running SQL Server Always On Availability Groups | Daniel Sol
High Performance and Highly Available SANLess Clustering | Mark Round
SQL Server Query Performance Tuning: A 12 step process | Scott Klein
Maintenance Plans for Beginners | Tobiasz Koprowski

Business Intelligence
Ad-Hoc SSIS for Business Analysts | Andre Kamman
Dave’s SQL Fun Time Hour | Dave Morrison
Introduction to Power BI Websites | James Boother
The News Column: ColumnStore Indexes in SQL Server 2014 | Andrew Whettam
"But SSRS Can’t Do That" – How to make it do that! | Oz Locke

Alt Tech
Continuous Delivery for Databases | James Smith
The Dark Side – Introducing some NoSQL alternatives to your RDBMS | Richard Munn
Fast and flexible data wrangling with data.table in R | Matt Dowle
Guerrilla training – implementing "Self-Service" BI | Steph Locke
Managing multi-vendor technology environments | Gavin Payne

Here I had time for attending for two sessions, and visit some streets arround venue. Absolutely fantastic luch with sandwiches and cookies, and fruits. And no limited coffee. Really good keynote by Anthony Saxby on the theatre style stage, which we used for final raffle. And really great audience on my sessions. This day we stay in Caerdydd, so after packing whole our stuff we went to speaker dinner in pure indian restaurant, where… I ordered chilli masala. And I know – this is one of my favourite indian main course. After the dinner, we (with James and Andre) discovered local pubs and micro brewery.

And I learned one more think. Even bank branch is opet till 7pm, it doesn’t mean that we can do everything there – the cash dest is open just till 5pm. 

[EN] SQL Relay Autumn Tour – Day Three

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Third day in Bristol. Arrived day before and changed my accomodation from pre-booked hostel to hotel room-mate’ing with James. Really great ‘cos we had time for dinner with Alex Whittles, Stephanie Locke, Alex Yates, James Skipwith, and guys from Pyramid Analytics. Great dinner, nice beer and very interesting talks.

Next morning we grab our stuff for SQL Relay attendees and  start for preparation. Two exhibition areas, reception desk and two rooms – one for bi/dev and one for dba/dev. This time I had time for attending for some sessions – and attending was very easy. I just occupied one of the “blogger’s table” in BDA/DEV room and attended for (almost) three sesions: SQL Server 2014 in-Memory OLTP Deep Dive and The Dark Side – Introducing some NoSQL Alternatives to your  RDBMS and finally Building an Automated Database Deployment. Really great sessions – very good from Scott and interesting from Richard. Alex presented session in interesting form and this session was good too. Full agenda, splitted for two rooms was really great:

Keynote | Microsoft
Sponsor Sessions by Microsoft & Pyramid Analytics

Dev / DBA Track
The Big Backup Theory | Richard Douglas
SQL Server 2014 in-Memory OLTP Deep Dive | Scott Klein
The Dark Side – Introducing some NoSQL Alternatives to your  RDBMS | Richard Munn
Building an Automated Database Deployment | Alex Yates
SQL Azure from Plan, to Backup, to Cloud | Tobias Koprowski
         
BI / Dev Track
Using PowerPivot and DAX to Predict and Win Fantasy F1 | Alex Whittles
Automate your SSIS Development with BIMLAndre Kamman
Microsoft Azure Machine Learning – The Next Step in the Microsoft | Jamilu Abubakar
Introduction to SQL Server Analysis Services Tabular Model | Andrew Whettam
Dave’s SQL Fun Time HourDavid Morrison

I wrote that I have been on almost three sessions, because in the middle of Scott’s session we went for Costa Coffee Cafeteria for coffee. Nine coffe for coffee lovers! I was very, very impressed for full proffesional service from master’s barista at this coffee spot. We grab nine different cups and back to the venue:

WP_20141015_058

I’m really glad to attending for some sessions and as a final point presenting my session about Plan, Backup and CLoud for SQL Azure. Session will be available on my SlideShare {box} soon and I updating picture album on Facebook {SQL Relay UK 2014 – Week One} each day. After final raffle and packing process – as always not very easy and not very short, we moved to another location. Destination: Caerdydd, Cymru.

[EN] SQL Relay Autumn Tour – Day Two

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Second day in Southampton. Arrived on Monday evening and after spending half an hour to find 51 Archers Road (where my hatel was) with Mr Neil Hambly, we sit down for a pint of Guinness. Old style british small hotel, not very functional (with many tiny stairs) but with nice service, gave me everything what I need.

IMG_7933Early morning, after two hours of working in the lobby/breakfast/pub area – where some gusts have not been satisfied for british breakfast – went for business meeting, across the city centre. Meeting was succesfull, so ater it, I went to SQLRelay venue. And after almost two hours of trip: from meeting to rail station – next to another city – next walking from rail station to venue I can say:

Even SQL Relay Southampton was not exactly in Southampton but in Worchester; the SQLSrelay in Winchester was not exactly in WInchester, but after crossing Strawberry Hill.

I just arrived after luch so some snacks, and kiw was only available, but unlimiteg hot chocolate and coffee makes me happy. I just prepared my session and delivered Maintenance Plans for Beginners in small room for about fifteen attendees. Full agenda for this event are below:

Keynote | Microsoft
Sponsor Sessions by Spectrum IT & Pyramid Analytics

Room: Emperor
Transaction Logs: A Primer | Stuart Moore      
AlwaysON for multi-site & multi-SubnetJohn Q Martin
Introduction to Azure SQL Database | James Boother          
Understanding Parallelism | Christian Bolton
Automate your SSIS Development with BIM | Andre Kamman
              
Room: Monarch
Using PowerPivot & DAX to predict and win Fantasy F1 | Alex Whittles
Help, my table is getting too big!James Skipwith
SQL Server Query Tuning: A 12-step process | Scott Klein
The Big Backup Theory | Richard Douglas
Daves Fun Time Hour | Dave Morrison
 
Room: Peacock
MDS & DQS – Beyond the TLAs to Data Quality | Neil Hambly
Intro to R | Steph Locke
Building an automated database deployment pipeline | Alex Yates
Transitioning from "Reporting" to BI Solutions | Eric Lawson
Maintenance Plans for Beginners | Tobiasz Koprowski

I have no chance/time for attending of any sessions (I’m sorry Richard for your Big Backup Theory), but Tueasday in Southampton was really hard and busy for me. Session will be available on my SlideShare {box} soon and I updating picture album on Facebook {SQL Relay UK 2014 – Week One} each day.

IMG_7967

After closing ceremony, raffles and more we just packing our stuff and with James as driver and with Stephanie Lockie, Scott Klein and Andre Makan (who replace Mr Neil Hambly) by SQL Relay Funny Bus we went to Bristol. And it was rainy again…