SQLSat742_web Hello!

#SQLSATCORK is a FREE one-day training event on June 9th in UCC, Cork and you can register here.

Please also help us promote the event by telling your colleagues and friends. Forward this web site link or post on social media. Word of mouth will be great too! Let’s give this event the turnout it deserves!!

SQL Saturday Ireland User Group is taking a break from the very successful Dublin based event and is moving to Cork for 2018. This is done with full co-operation from the Dublin organisers. Thanks to Carmel, Bob and Ben on doing such a great job over the last few years! #sqlfamily

Schedule for the event is here. Registration is FREE but places are limited.

Speakers include Irish and international MVPs and is broadly divided into 4 categories (Database Administrator, Business Intelligence. Cloud and Miscellaneous), topics include:

Advanced Analysis Techniques
Analytics and Visualization
Application & Database Development
BI Information Delivery
BI Platform Architecture, Development & Administration
Cloud Application Development & Deployment
Enterprise Database Administration & Deployment
Professional Development
Strategy and Architecture

This year, SQL Server Cork User Group are running this event with sponsorship from: Microsoft, PASS, SQL Sentry, Pyramid Analytics, Spanish Point, ProData. DML Consultants and Quest. Many thanks to our sponsors without who the event would not be possible!

Microsoft_logo_2012.svg_        pass-logo-2016      download

webp-net-resizeimage-2         SP_logo_website01    Prodata_Logo

DLM_Consultants_Logo_7_WhiteBackground_RGB_small      quest-logo

Western Gateway University College Cork, Cork City, Ireland. Directions here.

This building is home to the University Computer Science department and Ignition program and has state of the art facilities for presenters and attendees alike.

University College Cork (UCC) was formed in 1845 is set in 43 acres of wooded grounds.
Home to 6000 students the university is a 10 minute stroll from the heart of Cork city. More on UCC here.

Please note this event has an Anti-Harassment Policy

Contact the organisers at sqlsaturday742@sqlsaturday.com or on Twitter @SSUGCORK

We have two pre-Cons to choose from and each is a full day event with expert speakers! ‘Move your Database to the Cloud’ and ’50 Things All SQL Developers Need to Know’ will be held on Friday June 8th at UCC, Cork.

Pre-Con #1 – ‘Move your Database to the Cloud’
Speakers: José Manuel Jurado and Roberto Cavalcanti – Support Escalation Engineers at Microsoft.
Please register here. 
Price €250 per seat

This Azure SQL Database pre-Con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts.

It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment.

After attending this pre-con, you will be able to:
Understand how Azure SQL Database works
Know the most important features to manage your Azure SQL Database
Design scalable architectures
Design Disaster Recovery plans
Manage security on your Azure SQL Database
Monitor and troubleshoot Azure SQL Database
Face a migration project.

Pre-Con #2 – ’50 Things All SQL Developers Need to Know’
Speaker: Kevin Kline MVP, founder of PASS.
Please register here.  Price €250 per seat

Summary: This session takes you through 50 of the most challenging and commonplace patterns and anti-patterns when writing SQL and Transact-SQL code and shows how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Abstract: What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

In this session, you’ll learn:
1. Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags.
2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.
3. A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.

With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance.

Prerequisites: Intermediate competence in SQL and Transact-SQL syntax, such as coding with DML, DDL, and DCL transactions, using cursors and variables, and invoking functions and procedures. Basic familiarity with reading execution plans.

Goal 1: Learn how to build credibility and influence within your IT team.
Goal 2: Discover the interpersonal and communication skills that enable you to survive and bounce back quickly from hard times.
Goal 3: Explore key organizational concepts that enable you to ensure your job is always safe.

We have blocked booked accommodation in the University Campus Accommodation located beside the venue. Room only is 40 Euro and 48 euro for room + continental breakfast. We have a limited number of rooms which will be allocated on a first come, first served basis. To book, email beds@ucc.ie and reference SQL Saturday.

If you want to stay elsewhere there is a range of options on Western Road. The three nearest hotels are:

The Kingsley
River Lee Hotel
Hayfield Manor

As well as plenty of B&B and AirBnb. https://www.booking.com or usual sites will give you plenty of options.

Friday Night: We are keeping thing informal and have reserved tables in a city centre Micro Brewery (http://www.franciscanwellbrewery.com) for Pizza and Pints on the Friday Night. If you can make it you are most welcome to join us and enjoy a Pizza and couple of drinks on us!

Saturday Post-Conference: We have reserved the bar in Cork County Cricket Club in the Mardyke. This is a few minutes’ walk from the conference venue. Join us for a BBQ and another couple of drinks on us.

Travel Info
Flights: Cork Airport is 7km from the venue and a Taxi from the airport is your best option. The destinations served by Cork Airport are listed below. More information here.

Travelling from Dublin Airport – your options to get to Cork are: Train, Car Hire or Bus

The best value is the bus with AirCoach. They depart from Terminal 1 and 2, via Dublin city centre and then direct to Cork. Car Hire is available in Dublin Airport arrivals and there is motorway all the way to Cork. Train Tickets can be booked online Please note that you will have to get from Dublin Airport to Heuston Station either by Taxi or Bus (Airlink )

Travelling from Shannon Airport:
If you fly into Shannon, then your options to get to Cork are Train, Car Hire or Bus

More information on both can be found here.

Tourism Info
If you are planning on a longer stay some useful sites are cork.ie and visitcountycork.com. Also Tripadvisor has a list of things to do and here’s what Lonely Planet has to say but guidebooks aren’t really needed in Cork – just ask a local what’s on offer.

Hope to see you there! – Seán and Mark



February 2017 UG Meeting

Tue. Feb 21st2017

If you were at SQL Saturday Dublin 2016 you would have seen some of the new features of the just released SQL Server 2016.

Come along to explore some of our favorite new features we will explore the DB Engine change such as:
• Column Store Indexes
• Live query Statistics
• Query Store
• Temporal Tables
• Backups to Azure and Strech Tables
• Polybase
• Many hidden features like performance tweaks
• New Powershell Module

Speaker: Bob Duffy
SQL Server MVP, currently working as a Database and Solution Architect in Dublin, Ireland. He has over 20 years’ experience in the database sector, with MCA, MCM and Maestro certification. Jenga Master.


Please register with Eventbrite here as this will the help organisers organise!

SimpliVity 2005 CityGate (just past Mahon Shopping Centre) which has free underground parking.
“SimpliVity – Expand your possibilities, not your data centre”

Talk starts at 19:00 sharp


SQL Server User Group – Cork
Email: mailto:cork@sql.ie
Twitter: @SSUGCORK