SQL Social No. 29 – Creating a Test Environment in AWS using CloudFormation
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 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 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 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: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!
This entry was posted in SQL Server Social.
Our new website layout
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.
This entry was posted in SQL Server Social.
SQL Social No. 27 – Automated Test Driven Development with Microsoft SSAS
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 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 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 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: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!
This entry was posted in SQL Server Social.
SQL Social No. 26 – Chris Benson and the Tale of the SSIS Project Deployment Model
Our July Event is just hours away and this month we have Chris Benson back to talk to us about the SSIS Project Deployment Model.
Chris is a Managing Consultant with C3 Solutions, who are also sponsoring tonight’s event (Thank you!). Chris specialises in data warehouse and business intelligence applications, business process management, office development and general software development.
C3 Business Solutions is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for their clients. We are grateful for C3’s support of our community event and hope to have them onboard for future events as well.
If you haven’t yet registered for tonight’s social event, then please go here to sign up.
Looking forward to seeing you all there.
LH
This entry was posted in Events, Sponsorship, SQL Server Social.
SQL Social No 22 – 7 May 2014
We hope you all had the chance to get along to the recent SQL Saturday event and enjoyed a great day of free learning and networking with other SQL heads.
For those of you who were at the last SQL Social event, you would have heard us mention that we wanted to use SQL Social’s lightning talk style presentations as a development environment for new speakers or those just wanting to build-up to a full-blown User Group or Conference session. Well, this month we will have a new speaker on the block doing just that. Remember, as a reward we have 1 month Pluralsight subscriptions to give away to the presenter.
This Month’s Speaker
Lucas Ferguson
Lucas is an Analyst Programmer with the global property management organisation, Knight Frank. He has 8 years of experience in the SQL Server stack, mostly with T-SQL and Reporting Services with a smattering of SSIS and SSAS.
Lucas will be presenting on how Knight Frank made use of SQL Server Service Broker to keep two databases with very different data structures in sync.
As usual, food and drinks are provided courtesy of our sponsors.
Registrations are open, so please use the link below to let us know that you will be attending
https://www.eventbrite.com.au/e/sql-social-no-24-tickets-11327531953
This entry was posted in Events, SQL Server Social and tagged Events, Knight Frank, Lucas Ferguson, Melbourne, networking, PASS, royal melbourne hotel.
SQL Social No. 21 – The MVP Edition
The next SQL Social event is this week, Wednesday 11th December in fact. As usual we will be at the Governor’s Lounge at the Royal Melbourne Hotel, 629 Bourke Street, Melbourne.
This month we are spoiled by having 2 SQL Server MVP’s (one from our generous sponsors) giving us a few words of wisdom from their experiences.
This Month’s Speakers
Peter Myers
Peter Myers has worked with Microsoft database and development products since 1997. Today, he specializes in all Microsoft BI products and provides mentoring, technical training, and training course content authoring for SQL Server, Office, and SharePoint.
Peter has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He has been an MVP since 2007.
Peter will be presenting on Power BI, and specifically Excel’s Power Query. This talk will include some demos.
Rob Farley
Rob Farley is the Owner and Principal Consultant of LobsterPot Solutions Pty Ltd. He has been consulting in database technologies since completing a Computer Science degree with first class honours in 1997. He is a regular conference presenter both around Australia and overseas, heads up the Adelaide SQL Server User Group and holds several Microsoft certifications including Microsoft Certified Master in SQL Server. He is a Microsoft Certified Trainer, a recipient of the Microsoft MVP Award for SQL Server every year since 2006, and a past Branch Executive Committee member of the Australian Computer Society. Rob is director of the PASS organisation, and is a published author, his books including Professional SQL Server 2012 Internals and Troubleshooting, SQL Server MVP Deep Dives and SQL Server MVP Deep Dives 2.
Rob will provide some tips on query parameters – passing parameters into queries, functions and stored procedures is a thing we all do, but if you’re not careful about the data types, you could find performance becoming a problem, even if you’re just getting the length of a string wrong. This quick tip will give you ammo to take back to your developers to make sure they code it right the first time.
As usual, food and drinks are provided courtesy of our sponsors.
Registrations are open, so please use the link below to let us know that you will be attending
http://www.eventbrite.com.au/e/sql-social-no-21-tickets-9519528165?aff=eorg
We’ll also have some giveaways of one month Pluralsight subscriptions …. so something maybe for best networker of the evening, best questions or even just if you wear something Christmassy.
This entry was posted in SQL Server Social and tagged Excel, Lobsterpot Solutions, MVP, PASS, Peter Myers, Pluralsight, POwer BI, Power Query, Query Parameters, Rob Farley, SQL Server Social, sql social.
SQL Social No. 20 – Myths, Misconceptions and Must-See Conferences
Another very successful night for SQL Social with 29 people getting together at the Royal Melbourne Hotel. Chris Benson’s talk on Agile Data Warehouse project Myths & misconceptions sparked some lively debate and Martin Cairney’s review of PASS Summit 2013 looks to have planted the seed for a number of people to see how they can get to next year’s Summit Conference. A big thank you to our two speakers this evening, who managed to draw the crowds despite the inclement weather!
As promised, the slide deck to go with Martin’s talk is included here: PASS Summit 2013
We’ve also added a poll question about PASS – it would be interesting to see how many members there are here and how many more have signed up to find out more about PASS Summit.
And for those of you not yet signed up for PASS (the Professional Association for SQL Server), then you can do so here. And let’s not forget our local SQL Server User Group while we are at it.
It was pleasure to welcome C3 Business Solutions to the SQL Social fold this month . We are always very grateful for the support of our sponsors and look forward to lasting relationships.
This entry was posted in Events, News, SQL Server Social and tagged Agile, BI, C3 Business Solutions, Chris Benson, Data Warehousing, Lobsterpot Solutions, Martin Cairney, PASS, SQL Server Social, sql social, Summit 2013.
C3 Business Solutions – New SQL Social Sponsor!
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.
“According to a client survey conducted last year, compared to other IM consultants our clients say we’re more collaborative, better at stakeholder management, have a ‘can-do’ attitude and are flexible, and we’re focused on quality.”
C3 Business Solutions will be sponsoring our next event, to be held on November 13th at the Royal Melbourne Hotel. Chris Benson will be speaking on their behalf about the Myths & Misconceptions of Agile Data Warehouse Projects. This promises to be a great talk and I am sure will lead to a hearty discussion. As a BI Consultant working on one the largest Agile Data Warehouse implementations in Melbourne (that I am aware of) I am thoroughly looking forward to this talk.
Chris Benson
Chris Benson is a Managing Consultant with C3 Business Solutions. Chris specialises in data warehouse and business intelligence applications, business process management, office development and general software development for Business Intelligence and Data Warehousing applications.
Chris is a Certified SCRUM Master, Microsoft Certified Trainer, and is also certified in a range of Business Intelligence tools and platforms on the Microsoft platform, and has authored white papers on security planning and strategy in the industry and has presented on Business Analytics at major conferences in South Africa.
Chris can be contacted via LinkedIn.
Details for SQL Social No. 20 can be found on the Eventbrite & MeetUp websites. Please register if you plan on attending the event.
See you next week!
This entry was posted in Events, News, Special Guests, Sponsorship, SQL Server Social and tagged Agile, BI, C3 Business Solutions, Chris Benson, Data Warehousing, Sponsorship, SQL Server Social, sql social.
SQL Social No. 20!
The next SQL Social event is just round the corner, in fact it is less than 2 weeks away!
- Date – 2013-11-13
- Venue – The Governor’s Lounge, The Royal Melbourne Hotel, 629 Bourke Street, Melbourne
- Speaker – Martin Cairney will be speaking about his recent trip to the week-long SQL PASS conference held in Charlotte, North Carolina
- Food & Drinks will be available (free of course!)
This entry was posted in Events, SQL Server Social and tagged Martin Cairney.
SQL Server Social No. 19 – The forecast is cloud
So, as we predicted back at SQL Social No 17, we have become expects in predicting the weather. We can confidently say that Wednesday, 9th October will have Cloud!
How do we know this, well SQL Server Social No 19 will feature Microsoft PFE Balaji Navaneethan talking about Microsoft’s Cloud offerings – Office 365 and Power BI.
There is also the usual opportunity to network and learn more about data & information management in a relaxed atmosphere with plenty of food and drinks for the evening (thanks to our fantastic sponsors).
Register at http://sqlsocial19.eventbrite.com/
Want to speak at one of our events?
As always, we on the look out for new speakers. If you haven’t had the opportunity to speak before then this event is the perfect platform to get started. We operate in a relaxed, informal atmosphere that encourages discussion. We want you to present on just about anything data related, whether that’s DBA hot tips, Business Intelligence best practices, data visualisation, T-SQL performance tuning, SharePoint, Data Career paths, Certifications, etc. You name it, we want to hear about it. And if you do speak at SQL Social, you won’t go away empty handed. You will receive a one-month subscription to Pluralsight – Hardcore Developer Training. Pluralsight is an amazing resource for online learning, covering just about every developer topic under the sun; including SharePoint, Business Intelligence, SQL Server, PowerShell, Android, iOS, Windows Phone, Virtualisation. The list goes on.
So get in touch with us (luke.hayler at mopani.com.au / sqlsocial at outlook.com / martin.cairney at lobsterpot.com.au) or on twitter @lukehayler , @martin_cairney or @jim_mcleod and we can set a date for you to speak at one of our SQL Social events.
This entry was posted in Events, Special Guests, SQL Server Social and tagged Balaji Navaneethan, Office 365, POwer BI, SQL Server Social.