Wayne McCrum talks about Microsoft Premier Support’s Risk Assessment Program

The next SQL Server Ireland User Group meeting is on Microsoft Premier Support’s “Risk Assessment Program” on Tuesday, September 10th, 2013 in the Microsoft Atrium building, in Sandyford.

Wayne will discuss the program and discuss some of the common misconfigurations seen in the field.

When: September 10th, 2013 at 18.30

Where: Microsoft Atrium, Carmanhall Road, Sandyford, Dublin 18. A limited amount of underground parking is available via the rear of the building.

Cost: FREE Community Event

Registration: http://ssiug130903.eventbrite.ie/

Wayne McCrum has been working with SQL Server since 2004 in a variety of SQL orientated roles. He currently works as a SQL Server Field Engineer for Microsoft assisting customers within Western Europe on both proactive and reactive engagements around the SQL Server product.

Ian Meade on Flexible Data Modelling with EAV & other technologies

Ian Meade, from Ergo, will present on “Flexible Data Modelling with EAV & other technologies” in the Auditorium on the Ground Floor of the Microsoft Atrium on Tuesday, August 6th, 2013 at 18:30

The event is free and details can be found at http://www.mtug.ie/UserGroups/sqlserver/Lists/Calendar/DispForm.aspx?ID=7

The MTUG (www.mtug.ie) website has been updated with the details of all forthcoming SQL Server Ireland User Group meetings for 2014.

Sharepoint User Group Ireland – Making SharePoint work for Records Management & Social Features in SharePoint 2013

Making SharePoint work for Records Management.

SharePoint has had record management since version 2007 but has struggled in real world implementations due to design limitations and user unfriendliness . SharePoint 2010 added improvements such as document sets and in-place record management. In this talk Tony Ogilivie will bring real world experience in how to make SharePoint work for Records Management

Presenter: Tony Ogilvie – Automated Intelligence Tony brings many years of experience delivering high value and very successful deployments for a number of global organisations. Prior to joining Automated Intelligence Tony was a senior consultant with Parity and before that Autonomy. Tony is an expert in Microsoft SharePoint and is often engaged by customers and partners alike to design and implement their information architecture.

Social Features in SharePoint 2013.

SharePoint 2013 has added a major set of new features for based around Facebook and Twitter style collaboration. We’ll walk through Microblogging, User Feeds, Communities for both on Premise and Office 365. The usual Live Demo and Presentation mix plus a video clip of Steve Jobs, why? come and find out.

Presenter: Colin Byrne Colin is a SharePoint architect working in Ireland and the Uk. He is currently implementing a SharePoint solution for one of the worlds largest Aircraft Lessors.

Registraton : https://tito.io/tcube/sharepoint-user-group-ireland-june-meetup-2013

Location : TCube, 32-34 Castle Street, Dublin 2

Date & Time : June 20th, 2013 @18:30

Event is free & all are welcome.

Winners of the competition to attend Kevin Kline’s “From Good to Great: Productivity and Influence Skills for the IT Professional” pre-conference event

Last month, the SQL Saturday committee and SQL Server Ireland User Group held a competition to win a free place at the SQL Saturday 229 pre-conference – Kevin Kline’s “From Good to Great: Productivity and Influence Skills for the IT Professional”.

Kevin has been an awesome ambassador to Ireland in the SQL community and we wanted to celebrate that fact.

So the question was “How many times has Kevin Kline visited Ireland as a SQL speaker prior to this?”

Only one person, David Henley, got the correct answer of 3 visits :  Dublin, Cork, Galway & Belfast user group roadshow in 2007, a Dublin user group in 2011, & the Dublin SQL Saturday in 2012.

A second entrant, Yibo Hu, answered 6 times which is the correct number of events that he attended.

We decided to award a free entry to the event to both entrants.

Congratulations to David & Yibo.

To learn more about the event, visit the SQL Saturday 229 (http://www.sqlsaturday.com/229/) website for details.

SQL Saturday Dublin 2013 – One Month To Go

The SQL Saturday is now only a month away tomorrow and the committee has been very busy.

The biggest news is that the session builder is now available to all those registered for SQL Saturday 229 (http://www.sqlsaturday.com/229/). Whether you have already booked or have yet to book, please help us to plan room sizes by letting us know what sessions you will be attending.

SQL Saturday was oversubscribed last year so book quickly to ensure your place.

In other good news, we have extended the early bird on the pre-conferences until the end of May. There are still places left for each of the pre-conferences.

If you wish to attend any of the pre-conferences, the details for these can be found at:

Kevin Kline’s “From Good to Great: Productivity and Influence Skills for the IT Professional” http://www.prodata.ie/Events/SqlSat229/Precon1.aspx

Chris Webb’s “Self-Service BI and Office 2013” http://www.prodata.ie/Events/SqlSat229/Precon2.aspx

Matt Masson’s “A Day of Enterprise Information Management – SSIS, MDS and DQS” http://www.prodata.ie/Events/SqlSat229/Precon3.aspx

Win a free place at Kevin Kline’s “From Good to Great: Productivity and Influence Skills for the IT Professional” pre-conference

The SQL Saturday Dublin committee has completed the session schedule for SQL Saturday 229. In addition, we have extended the early bird on the pre-conferences until the end of May.

So what more could we do? We decided to hold a competition to win a free place at the SQL Saturday 229 pre-conference – Kevin Kline’s “From Good to Great: Productivity and Influence Skills for the IT Professional”.

Kevin has been an awesome ambassador to Ireland in the SQL community and we wanted to celebrate that fact.

So the question is “How many times has Kevin Kline visited Ireland as a SQL speaker prior to this?”

All you have to do is email “ssiug at live.ie” with “Competition” in the subject and let us know the answer.

We will complete the draw on the last day of May.

Niall Flanagan revisits Indexing

The next SQL Server Ireland User Group meeting is “Niall Flanagan revisits Indexing” on Tuesday, April 30th, 2013 at the usual location in Auditorium, on the Ground Floor of the Microsoft Atrium building, in Sandyford.

This topic will cover the performance benefits and important considerations of good indexing design in SQL Server including

  • Considerations, Benefits & Concepts
  • Statistics
  • Table/Index Design
  • Clustered, Non-clustered, & Heap
  • Fragmentation
  • Why cheap hardware is not always the answer

When:             April 30th,  2013 at 18.30

Where:            Microsoft Atrium, Carmanhall Road, Sandyford, Dublin 18. A limited amount of underground parking is available via the rear of the building.

Cost:               FREE Community Event

Registration:    Not required. Contact ssiug at live.ie for more details or visit the Microsoft Technology User Groups site (www.mtug.ie )

Niall Flanagan leads a team that manages production Oracle, Sybase and SQL Server databases in a large Irish retail bank. Niall founded the SQL Server Ireland User Group in early 2006 and continues to lead it. In addition, he presents on SQL Server to various user groups and conferences throughout Ireland. Niall is a Microsoft SQL Server Most Valued Professional (MVP) since October 2006.

SQL 2012 Always On Deep Dive and Windows Azure for SQL Folk in Belfast

Our very own SQL Server MVP ( as well as MCA, MCM & now Analysis Services “Maestro” certified) , Bob Duffy is heading North to present at the 3rd Belfast SQL Server User Group on April 11th at the LIT offices.

Bob currently is the lead database architect at the Prodata SQL Centre of Excellence in Dublin, Ireland where he helps enterprise customers with design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.

SQL 2012 Always On Deep Dive (Beginner/Intermediate)

Always On Availability Groups offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.

During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.

This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.

Windows Azure for SQL Folk (Beginner)

So what is this cloud stuff and how does it affect database professionals?

In this session we aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you have when developing applications in the cloud.

This sessions is Ideally suited to anyone who wants to understand more behind how Azure works, what it offers and what is probably just hype.

Date: Thursday 11th April 2013
Time: 5:45pm-8:45pm
Venue: Liberty IT, Adelaide Exchange, 24-26 Adelaide St, Belfast.

Registration is at http://www.eventbrite.com/event/5705276636#

Core Features and Benefits of Self Service Business Intelligence (Dublin)

Spanish Point’s CTO, John Corley, presented this last November to the SQL Server Belfast User Group and has kindly agreed to present it to the SQL Server Ireland User Group on Tuesday, March 12th, 2013 at our usual location in Auditorium, on the Ground Floor of the Microsoft Atrium building, in Sandyford.

John will demonstrate the core features and benefits of Self Service Business Intelligence using the Microsoft platform including:

•The ability to access and integrate data from virtually any source.

•Create compelling reports and analytical applications.

•Visualize and interact with data in bold new ways.

•Easily collaborate and share insights using familiar tools in Microsoft Excel and Microsoft SharePoint

The presentation will cover the latest features of SQL Server 2012 including PowerView and the BI Sematic Model.

For more information about Self Service Business Intelligence, please contact Spanish Point Technologies at info@spanishpoint.ie or +353 16522000.

When:                 March 12th,  2013 at 18.30

Where:                Microsoft Atrium, Carmanhall Road, Sandyford, Dublin 18. A limited amount of underground parking is available via the rear of the building.

Cost:                    FREE Community Event

Registration:      Not required. Contact ssiug at live.ie for more details or visit the Microsoft Technology User Groups site (www.mtug.ie )

Speaker Bio

John Corley is the Chief Technology Officer and co-founder of Spanish Point Technologies. Spanish Point Technologies is an Irish based innovative software company working with Microsoft technologies to provide business systems which remove complexity, increase productivity and connect users to critical business information. Employing technologies such as SharePoint, Microsoft Office, BizTalk, SQL Server  and to build compelling solutions.

Spanish Point Technologies is a Microsoft Partner with four Gold competencies and two silver competencies. Spanish Point also was awarded a Microsoft Worldwide Partner of the Year award in 2007 and this year Spanish Point won Irish Information Worker Solutions Partner of the Year.

At Spanish Point, John designed LookupPoint, a productivity tool enabling users to access line-of-business data from within their familiar Microsoft Office environment. He has led many significant ICT projects including the OSi eBusiness Suite Project, the Irish Music Rights Organisation Distribution System for which Spanish Point was awarded Microsoft World Wide Partner of Year Award in 2007 and the Royalty Distribution System for The Canadian Musical Reproduction Rights Agency.

Previously, as head of software development for Mentec International Ltd, he headed a team of over 20 software developers and delivered numerous multi-million Euro software development ICT projects.

John is a member of the Microsoft Software Architects council and is frequently invited to speak at various Microsoft events both in Ireland and abroad. John has worked with the core Microsoft Office and SharePoint product team in Microsoft Corporation headquarters in Seattle for the past two years, appeared on Microsoft TV (Channel 9) and been interviewed for Microsoft Visual Studio Magazine in June 2010.

Simon Sabin in Dublin to talk about how SQL Server joins tables together

Simon Sabin, a UK SQL Server MVP & a regular speaker here in Ireland, is in Dublin this week and will present to the SQL Server Ireland User Group on “Find out what most people don’t understand. How SQL Server joins tables together. Its not magic”.

Almost all queries have to do two things, get data and join it together. In this session we will look at the aspects of these that most people think they know but in reality don’t.

It will be held at the SQL Server Ireland’s usual venue in the Microsoft Atrium from 18:30, this Thursday, November 22nd.

Registration is free at http://www.mtug.ie/UserGroups/SQLServer/tabid/82/ctl/Details/Mid/413/ItemID/110/Default.aspx?ContainerSrc=[G]Containers/_default/No+Container

All are welcome.

%d bloggers like this: