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!

Advertisements

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!

SQL Social No. 32 – Change Data Capture

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/04/01 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

Jim McLeod – Auditing with Change Data Capture, Change Tracking, and SQL Audit

jim
Jim McLeod is a Melbourne-based SQL Server consultant/database administrator with CGI. Coming from a software development background, Jim chose to specialise in SQL Server in 2005, with a particular focus on database performance. Since then, Jim has worked with most aspects of SQL Server on databases of all sizes across a large number of industries, along with a recent venture into Oracle administration.

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 a specialist SQL Server consultancy. Founded in 2008 we specialise in Data Platform and Business Intelligence including Data Warehousing and Reporting technologies. We can turn your data into information. LobsterPot Solutions also has a strong focus on training with most of our consultants being Microsoft Certified Trainers who regularly present at local and international events. This combination allows us to offer advice, mentoring and customised training as part of our standard service offering.

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. 31 – Cloudy with a chance of BI

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/03/04 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

Luke Hayler – Cloudy with a chance of BI. A SQL Saturday Recap

Luke Hayler

Luke Hayler is a BI Consultant with over 10 years of experience in Business Intelligence and Data Warehousing. Having worked across a range of industries (Insurance, finance, every, telecoms and Healthcare) and in several countries (UK, South Africa, US, Australia), Luke is now working at Telstra delivering BI solutions.

Luke will be delivering a short presentation about his experiences and takeaways at SQL Saturday #365. Specifically taking a look at Azure Machine Learning and Power BI Designer.

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 a SQL Server and Business Intelligence consultancy with staff in the United States and Australia, offering consultancy and training services. LobsterPot Solutions specializes in SQL Server, including performance tuning, Business Intelligence, and more.
We can turn your data into information.

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 employ three Australian SQL MVPs, the first company in the whole Asian region 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. 29 – Creating a Test Environment in AWS using CloudFormation

Posted on Updated on

SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2014/10/08 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

Andrej Hribernik – Creating a Test Environment in AWS using CloudFormation

Andrej HribernikAndrej Hribernik is a Solutions Architect at Education Services Australia. He has cross sector industry experience (Education, Finance, Real Estate, Telecommunications, Agribusiness) delivering diverse software projects on a variety of platforms. He has been designing software systems that utilise SQL Server and it’s technologies since 2002, most recently implementing HA solutions utilising DQS and Service Broker.

Andrej will be demonstrating how to set up a cost effective test environment for your SQL Server dependant application in minutes using AWS CloudFormation.

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, Canberra and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

InfoReady

InfoReady:

InfoReady is a pure-play information management, business intelligence, marketing intelligence and consulting firm, recognised as one of the leading niche solution and services firms in Australia and recipient of many industry awards. The InfoReady team are all experts with many years experience in their respective IM/BI domains across a wide variety of industry sectors. InfoReady provides solutions and consulting services to our clients that focus on transforming information into actionable intelligence through the application of people, process and technology.

Our services include strategy, architecture, solution design, delivery, training, and delivery capability centres that span: Business Intelligence, Data / Information Management and Enterprise Marketing Management Solutions

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!

Our new website layout

Posted on Updated on

We’ve changed!!

So, how do you like our new look? We’ve added some tighter integration with Eventbrite (where we manage all our events from) so that we don’t need to keep doubling up on the posts.

You’ll now see the events listed over on the right hand side or on the Events Calendar and you’ll be able to register directly on there.

For September, we have Matthew Signor presenting on Programmatic SSIS.

SQL Social No. 27 – Automated Test Driven Development with Microsoft SSAS

Posted on

SQL Social: Australia’s Premier Data Networking Event!

 

Register Here!

 

When:        2014/08/13   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.

This Month’s Speaker and Topic

Callum Sneddon – Automated MS SSAS Testing

Callum SneddonCallum Sneddon is a Managing Consultant with InfoReady. Callum has been working with databases for more than 14 years, the last 9 of which focusing on data warehousing and business intelligence with emphasis on Kimball, Agile and the Microsoft BI Stack. Callum has contributed to the implementation of many large scale data warehouse and reporting solutions using a range of technologies and is currently the business intelligence lead in an Agile team.

Callum will be demonstrating Test Driven Development of Microsoft SQL Server Analysis Server (SSAS) models using the Cucumber language to test metadata and data quality.

 

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, Canberra and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

InfoReady

InfoReady:

InfoReady is a pure-play information management, business intelligence, marketing intelligence and consulting firm, recognised as one of the leading niche solution and services firms in Australia and recipient of many industry awards. The InfoReady team are all experts with many years experience in their respective IM/BI domains across a wide variety of industry sectors. InfoReady provides solutions and consulting services to our clients that focus on transforming information into actionable intelligence through the application of people, process and technology.

Our services include strategy, architecture, solution design, delivery, training, and delivery capability centres that span: Business Intelligence, Data / Information Management and Enterprise Marketing Management Solutions

 

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!