What we're about

The SQL Server Ireland User Group was founded in 2006 to foster & grow the Irish SQL Server community while providing networking opportunities & sharing experiences using the Microsoft Data Platform via free events and meetups.

This group is a local affiliated with "Azure Data Tech Groups" sponsored by Microsoft.

Meetings are held most months, usually in the evening of the first Tuesday of the month. We do collaborate with others to support larger conference events from time to time; including the highly successful SQL Saturday Dublin Event.

Over 1,000 members across DBA's, Developer's, Architects, BI Professionals and IT Pros.

we have a strict code of conduct for events and meetings which can be found here:

https://developer.microsoft.com/en-gb/azure-tech-groups/code-of-conduct

Follow us on:

- Email: ssiug@live.ie

- Blog: https://ssiug.wordpress.com

- Eventbrite: http://ssiug.eventbrite.com/

- Twitter: @sqlireland

Upcoming events (4+)

Integrating Power BI with Azure Synapse Analytics Serverless SQL Pools

Link visible for attendees

  • Online Session* Click link to join at 19:00

With the power of Azure Synapse Analytics Server less SQL Pools we are able to connect to and process data stored in Azure Storage, Azure Data Lake Gen1 and 2, and Cosmos DB using familiar SQL commands.

How do we report on and visualize this data using Power BI? Are there optimization techniques we can use?

In this session we'll be covering the following:

  1. Creating an Azure Synapse Analytics environment
  2. Creating a Server less SQL Pools database
  3. Connecting to CSV and Parquet data stored in Azure Data Lake Gen 2 using Server less SQL Pools
  4. Using Power BI to connect to Server less SQL Pools to visualize this data in real-time.
  5. Optimization techniques to improve performance and reduce cost
    About Jason Horner - Global Thought Leader and International Man of Leisure

-Andy Cutler-
I am an Azure Data Platform professional working predominantly with Azure Synapse Analytics (SQL Pools), Data Factory, SQL Server and Power BI. I hold an MSc in Business Intelligence and Data Mining.

Query store in an Hour- On-prem and in Cloud

Link visible for attendees

  • Online Session* Click link to join at 19:00

Do you face performance problems with queries generating multiple query plans? Identifying the
optimal plan for these queries becomes difficult if you only depend on the plan cache. You need a
history of the query plans over time to identify performance degradation, and this is where Query Store
can help!
If you are not familiar with Query Store and its benefits, this session is right for you! You will learn about
Query Store fundamentals, monitoring performance using Query Store, how to manually force and
unforce plans, automatic plan correction, things to remember while using Query Store, and the new
query hint feature added recently to Azure SQL Database and available for preview.
The demos will show you how to readily test and implement Query Store and take advantage of this
amazing feature SQL Server has to offer!

About Deepthi Goguri - SQL Database Administrator

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is an Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.

Data Science in Power BI Desktop

Link visible for attendees

  • Online Session* Click link to join at 19:00

Two of the most popular modern topics are data science and Power BI. The nice thing is that you can easily combine both of them by including data science analyses in Power BI. You can do this in numerous ways. Many Power BI visualizations already include the Analytics tab with plethora of intermediate-level analytical functions available. For example, you can add a trend line and many other lines to the Scatter chart. You can use R and / or Python script sources. You can do the whole analysis in R or Python, and then visualize the results in Power BI. You can also use the good old SSAS Multidimensional Data Mining as the source. You can include Azure ML predictions in a Power BI model. With R and Python visuals, you can add the impressive visualizations from these two languages in a Power BI report and dashboard. You can also use R and Python in Power Query for advanced data manipulation. There are also many custom visuals that include data science analyses. This session introduces all of the mentioned options and shows some really advanced reports done inside Power BI.

About Dejan Sarka- MVP, MCT

Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of nineteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Radacad, Microsoft, SolidQ, and Pluralsight.

Handle Azure SQL Auditing with Ease

Link visible for attendees

  • Online Session* Click link to join at 19:00

Are you tired of not knowing who's changing what in your Azure SQL databases?

To audit Azure SQL Database, you can use the built-in functionality in the Azure portal; to audit Azure SQL Managed Instance, you can use SQL Server Audit or Extended Events. With auditing, you can track changes, report on usage to auditors, or change user permissions/passwords without breaking functionality.

In this session, you will get a quick overview; the pros and cons; and some use cases. You can be an auditing pro in no time!

About Josephine Bush - DBA, MBA, Author

Josephine Bush has over 10 years of experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using SQL Server, MySQL, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics. She is the author of Learn SQL Database Programming published by Packt in May 2020. She blogs on sqlkitty.com and you can reach her on Twitter @hellosqlkitty.

Past events (91)

Administering SQL Server with PowerShell using dbatools

This event has passed

Photos (150)

Find us also at