SQL Server Social

June 2018 – Augmented Analytics

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2018/06/06 From 5:45pm – 8:15pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker will receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Julian Tintinger – Augmented Analytics

Julian Tintinger
Julian Tintinger

Julian is a Principle Consultant at Triatin. He has 32 Years experience in Information technology, 20 in Business Intelligence and Data Warehousing. Drafted to Marines after high school before being trained in Cobol programming by IBM.

He used this experience in Retail applications for 10 years, after which he started in Data Warehousing on MS Access, Oracle and SQL server. He founded Triatin 11 years ago.

He is passionate about data, numbers, and helping people experience as many “Aha!” moments as he can.

Gartner calls it “The next disruption in Analytics and BI”. It has also been called “The future of BI”. Augmented Analytics is here and as a paradigm is changing the architecture and model in corporate Business Intelligence around the world.

Julian has been working on Augmented BI with Triatin’s SQL Server based ABBIE product, developing a way to augment existing data warehouses by quickly bringing predictive analytics, metric reporting and whole world views to business intelligence consumers.

This session will provide an overview of Augmented Analytics and the ABBIE platform.

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Quest:

At Quest, our purpose is to solve complex problems with simple solutions. We accomplish this with a philosophy focused on great products, great service and an overall goal of being simple to do business with. Our vision is to deliver technology that eliminates the need to choose between efficiency and effectiveness, which means you and your organization can spend less time on IT administration and more time on business innovation.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

Advertisements

May 2018 – R and Python Showcase

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2018/05/02 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker will receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Helen Gross – R and Python Showcase

Helen GrossHelen Gross has 10+ years in the SQL/BI space mostly focusing on Microsoft BI stack (SSIS, SSAS and SSRS) with some PowerBI and more recently some ML.

She has worked across Health, Finance, Energy and Transport.

In SQL Server 2017, using Machine Learning Services we can now run both R and Python in the database.

In this session, Helen will demonstrate how this is done and focus on some use cases for each using some mind-blowing datasets.

So be prepared for a wild ride!

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

April 2018 – SQL Auditing & SumoLogic

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2018/03/04 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker will receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Alicia Horner – SQL Auditing & SumoLogic

Alicia HornerAlicia Horner Twitter_Logo_Bluehas worked with SQL Server as a DBA for 8 years in both Australia and the UK.

She is currently working as the SQL Technical Lead for a Top 15 ASX company and has previously worked in Managed Services and supporting a UK airline eCommerce system.

She is certified as an “MCSE – Data Platform”.

In this session, Alicia will be asking how do you keep your auditors happy? Are you using SQL Auditing on your SQL Instances and if you are, is it a case of set and forget?

SQL Server provides SQL auditing that is easy to enable, but what do you do with that data?

Alicia will show how with SQL Audits and Sumologic (a log analytics and metrics platform that can ingest logs which for further review and analysis), you can use dashboards for visualisations and to schedule queries that can review and alert on logged events.

Lets keep those pesky Auditors at bay with some pretty graphs!

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

October 2017 – DBOps – The Old New Thing

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2017/10/11 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker wiil receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Sudarshan Narasimhan – DBOps – The Old New Thing

Sudarshan NarasimhanSudarshan Narasimhan is a SQL professional formerly from Microsoft CSS and has worked in various roles including Tech Lead, Database Architect, Engineer and is currently a DBA by trade.

He has authored several KB articles, MSDN blogs and you can find his SQL server musings at TheSQLDude.com. In recent times, he has been working on AWS and other relational databases with a focus on database Infrastructure as Code (IAC).

This session will be interactive and is Sudarshan’s take on the changes occurring in the world of a traditional DBA/DB Developer and what skills are now a must have in the new world and how some skills will never go away.

This is DevOps meets DBA, and what he likes to call “DBOps” – a fusion of DevOps and a Database professional.

Come along and let’s talk about Automation, PowerShell, Deployments and of course SQL scripts 😊

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

July 2017 – Is Cloud a Threat to the Traditional Database Professional

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2017/07/05 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker wiil receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Manohar Punna – Is Cloud a Threat to the Traditional Database Professional?

Manu PunnaManohar Punna is an SQL Geek and President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various SQL Server Day events and user groups, SQL Saturday Melbourne and Sydney, SQLBits XIV conference and SSGAS conferences.

He has authored over 150 blogs and has written a One DMV a Day series which is a longest one day series on any topic on SQL Server till date.

Manu’s session will focus on the paradigm shift of databases to cloud, and are the services of a traditional database professional needed in the future? What are the challenges and how to overcome them? How can you keep up with the tide? Manu will try and answer these questions and any others you have about cloud databases.

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

March 2017 – Power BI Q&A with Marco Russo

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2017/03/01 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker wiil receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Marco Russo – Power Bi : Q&A Session

Marco RussoMarco Russo is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design. He has spoken at international conferences such as Ignite, PASS Summit, SQLRally, and SQLBits. Marco is also the author of several books about Analysis Services, Power Pivot, and DAX.

Marco’s session will be very interactive and take some direction from the audience to help get answers to your Power BI questions. As Power BI is so big, we’ll focus on the data models and relationships to get things going – however if you have something specific you’d like to ask Marco then please email us in advance so that he can get some opportunity to prepare.

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!

SQL Social No. 45 – Entity Attribute Value (EAV) SQL anti-patterns

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2016/08/10 From 5:45pm – 7:45pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Australia

Cost: Free!

Food & Drinks will be provided.

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).

Networking

This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker wiil receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Igor Rozenberg – Entity Attribute Value (EAV) SQL anti-patterns

Igor RozenbergIgor is a Senior Consultant  at UXC. He graduated in Robotics and Computing in Moscow USSR before arriving in Australia in 1992.  His first experience with relational databases was with Microsoft Access and has worked with Microsoft SQL Server (since version 6.5 to Azure SQLDB). He does toy with other RDBMS such as DB/2, Oracle and Sybase. His hobbies include Space exploration, and he is a member of the Space Association of Australia.

 

This session is dedicated to revealing “The god, the bad and the ugly” sides of EAV (Entity Attribute Values) modelling that is based on the mathematical notion of a sparse matrix.

First we’ll show what could be wrong with a brute force approach to implementing EAV and compare side-by-side traditional row-based entity implementation with EAV implementation.

Then we will show a pragmatic implementation of and EAV model build on top of a RDBMS (like SQL Server) based on experience with two-way synchronization challenges between a centralized server database and local databases on occasionally connected tablet devices.

.

Our Sponsors:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Pluralsight - Hardcore Developer Training

Pluralsight:

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!