SQL Server Social

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!

Advertisements

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!

SQL Social No. 44 – Tabular Models for Better Power BI

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2016/07/13 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

Kelly Broekstra – Tabular Models for Better Power BI

Kelly Broekstra
LobsterPot Solutions’ newest consultant, Kelly Broekstra, has over ten years’ SQL Server database and data warehouse development experience and a passion for understanding a client’s need to create the most fit for purpose solution achievable. Kelly has considerable practice utilising and adapting the Agile principles to extensive BI and data warehousing projects.
Are you like most companies, your data is in multiple sources and the business rules are complicated? You want your business to be able to use self-service BI tools like Power BI but the business people aren’t ready to combine and apply rules to the complicated data themselves.

SQL Server Analysis Services Tabular models allow for flexible data preparation and blending, centrally managed security, application of business rules and are one way to you can connect to a live data source from Power BI. With Tabular models you can easily build robust, reusable models over your data to provide consistency across reporting and analysis in your organization.

The good news is that Tabular models are quick and simple to create. Join us for a demo of the basics and get a model working for business driven self-service BI in less than an hour.

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!