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!

SQL Social No. 42 – MDS The under utilised feature of SQL Server Enterprise Edition.

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2016/04/13 From 5:45pm – 7:45pm

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

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

Wilud Elok – MDS The under utilised feature of SQL Server Enterprise Edition

Wilud Elok
Wilud Elok is a BI consultant with Oakton. Wilud has 4 years of experience working with SQL Server across multiple projects in Microsoft BI Stack.

 

MDS is a Master Data Management tool provided by Micorosoft that comes as a free bundle with SQL Server Entrerprise Edition and can be used to provide a quick and easy solution for many organizations for their MDM.

In this session, Wilud will share some experiences in using MDS as an MDM solution.

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. 40 – PowerBI and SQL Saturday

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2016/02/10 From 5:45pm – 8:00pm

Where: Servian Offices, Level 11, 45 William St, Melbourne VIC 3000, Melbourne

NOTE – This is not our normal venue as we are hosting in conjunction with the Power BI Community

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

Power BU User Group and SQL Saturday Melbourne Updates

SQL Sat and PBUG
There is plenty going on in the Microsoft Data Community this month. If you want to get the low-down on events, then come along and get to see some Power BI in action as well as getting an update on what is going on around SQL Saturday.

If you haven’t heard of SQL Saturday, or need to know more before committing to attending then this is the place to find out.

We’ll also have some more information about other training opportunities you might want to consider.

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 Servian for the venue, Lobsterpot Solutions, C3 Business Solutions and Pluralsight for their ongoing support of this great community event!

Servian:

Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance.

Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more.

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.

C3 Business Solutions

C3 Business Solutions:

C3 Business Solutions is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for our clients. C3 specialise in developing and deploying successful strategies end-to-end for large public & private sector organisations. While remaining vendor independent, C3 work with clients to establish current as well as future needs. Their team of top tier consultants continuously focus on delivering measurable business change.

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. 38 – Getting more out of your BI Tools with BIDS Helper

Posted on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/10/07 From 5:30pm – 8:30pm

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

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

Darren Gosbell – Getting more out of your BI Tools with BIDS Helper

Darren Gosbell
Darren Gosbell has 15 years of practical experience in building and implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Darren has been awarded as a Microsoft MVP SQL Server since 2006 in recognition of his contribution to the community specially in the areas of Analysis Services and MDX. He is the leader of the Melbourne SQL Server User Group and also contributes to a number of open source BI projects including BIDS Helper, DAX Studio and the AnalysisServicesStoredProcedure project.

In his spare time, when he can find a large open space Darren enjoys throwing boomerangs.

 

If you are looking to get the most out of Microsoft BI technologies you owe it to yourself to check out BIDS Helper which is a free add-in that enhances the Microsoft BI design tools.The tools that Microsoft provides for working with the BI services are pretty good, but there are a few rough edges. BIDS Helper is an award winning free tool which seamlessly integrates with and extends the Microsoft BI designers.

Come along and see this demo rich presentation from the one of the core project contributors.

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, C3 Business 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.

C3 Business Solutions

C3 Business Solutions:

C3 Business Solutions is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for our clients. C3 specialise in developing and deploying successful strategies end-to-end for large public & private sector organisations. While remaining vendor independent, C3 work with clients to establish current as well as future needs. Their team of top tier consultants continuously focus on delivering measurable business change.

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. 37 – Automated Testing for BI using nUnit

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/09/09 From 5:30pm – 8:30pm

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

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

Daniel de Sousa – Automated Testing for BI using nUnit

Daniel de Sousa
Daniel de Sousa is a BI Consultant for EMIS Health, a provider of solutions to help improve quality of business and clinical decision making in healthcare organisations. He has been working with SQL Server for the last 10 years, doing development, data warehousing and Reporting in the BI Space. He has worked before for three of Melbourne’s biggest Health Organisations.

Testing software is hard work. Testing BI solutions is harder still; lots of moving parts, the tools are thin and it takes a lot of time and effort. Software development uses unit testing and while this can be applied to the different parts of a BI solution, most people are more interested in the numbers the solution produces and proving that they are right.

So can you validate the numbers in your BI solution? And can you do it quickly and easily?

The session will give an introduction to an approach for automating the validation of your BI solution.

Using nUnit as a framework and some free codeplex tools, we can run a suite of tests every time we load data into our BI platform. This is not continuous integration, and it is not unit testing in the true sense either. It is, instead, “continuous validation”, and it can provide you with an awful lot of assurance for not very much extra effort

 

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, C3 Business 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.

C3 Business Solutions

C3 Business Solutions:

C3 Business Solutions is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for our clients. C3 specialise in developing and deploying successful strategies end-to-end for large public & private sector organisations. While remaining vendor independent, C3 work with clients to establish current as well as future needs. Their team of top tier consultants continuously focus on delivering measurable business change.

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 33. Machine Learning as a Service

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/05/06 From 5:30pm – 8:30pm

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

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

James Mao – Machine Learning as A Service – A VoicePrint Example

James Mao
James Mao is a Cloud Principal Consultant at DWS in responsible for the development of cloud practice.

Prior to returning to Australia last year, James worked at Microsoft as an Azure technical evangelist.

With a combination of solid IT and business background, James is able to smoothly engage with various types of stakeholders, to support them to design and build / migrate scalable solutions on cloud platforms. He has actively developed reusable IPs and best practices for the Microsoft cloud businesses in US, Singapore and China.

James Mao received a Master’s degree in BI and Knowledge Management at Monash University and a MBA from CEIBS, Shanghai China.

Azure Machine Learning as a Cloud based service can greatly accelerate the time to market of new AI based solutions. In his talk, James will use a VoicePrint example to showcase how the Machine Learning service fits into a whole solution picture

 

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, C3 Business 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.

C3 Business Solutions

C3 Business Solutions:

C3 Business Solutions is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for our clients. C3 specialise in developing and deploying successful strategies end-to-end for large public & private sector organisations. While remaining vendor independent, C3 work with clients to establish current as well as future needs. Their team of top tier consultants continuously focus on delivering measurable business change.

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!