SQL Server Social
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 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.
SQL Social No.18 – In the bag
What a fantastic evening!
By my reckoning SQL Social No. 18 has to be the best social event that we have hosted this year. With a +80% turnout, an excellent speaker and attendees that were engaged and willing to get deep into discussion, this event ranks highly on my list.
What made this event work? Well, for me, there are a number of factors that I believe contributed to the success of the event:
- The weather played ball (it was warm and dry!)
- We have a core attendance established through our (ever growing) contact list
- A great speaker with an interesting topic
- Attendees that are engaged and willing to participate
- Sponsors to make it all happen

Thanks must also go to our speaker, Tara Shanka Jana, a Microsoft Premier Field Engineer who presented on the topic of Extreme Transaction Processing (XTP). Tara’s presentation generated a number of good questions and subsequent discussion, keeping the focus for nearly an hour. It was great to see the attendees really engaged and learning a thing or two about Hekaton.



I had a lot of good feedback at the end of the evening, with some attendees commenting that this has been the best SQL Social yet. These are the things that I like to hear!
Our next event is penciled in for Wednesday, October 9th. So keep your calendars clear and keep an eye out for invites and registration in a couple of weeks time.
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) 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, Sponsorship, SQL Server Social and tagged sql pass, SQL Server Social, sql sever 2014, sql social, tara shankar jana.
Kalen Delaney Coming to Melbourne in March
March 2013 is almost upon us and I for one cannot quite believe where this year is going. But another month brings with it another SQL Server Social, and for our next meeting we are hoping to have world leading expert in SQL Server Kalen Delaney join us for the evening.
Kalen Delaney will be coming to Melbourne to conduct one of her extremely sought after Deep Dive courses; this one in particular is about SQL Server 2012 Query Tuning Internals. For details about the course and to register, please click here.
Kalen has agreed to spend a couple of hours at the next SQL Server Social, which is currently planned for Thursday, 21st March 2013 (NOTE the change of day and week for this one). So if you would like to come along and pick Kalen’s brain about the internals of SQL Server then this is a golden opportunity. The registration for the next event is not yet open, but keep an eye out for it in the coming days.
Here is an excerpt about the course;
Kalen Delaney – SQL Server 2012 Query Tuning Internals
This is a four day advanced course designed for advanced Microsoft SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2012 and cover features specific to that version, but most of the information is relevant to SQL Server 2008 and some is relevant to SQL Server 2005.
Kalen Delaney is considered to be the world’s leading expert in SQL Server Internals. Kalen’s courses and seminars on SQL Server Internals have been delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world.
Canberra: Tue 12 – Fri 15 March 2013
Melbourne: Mon 18 – Thu 21 March 2013
This entry was posted in Events, News, Special Guests, SQL Server Social and tagged Events, kalen delaney, SQL Server Social.
SQL Server Social No. 9 – New Format!
SQL Server Social No. 9 is just around the corner, if you haven’t already you should go and register right now. This month we are introducing a new format to the event: Ask The Experts.
Ask The Experts
Our Ask The Experts format incorporates the best bits of any networking event: keeping it social, relatively unstructured but with the bonus of having industry experts on hand to answer YOUR questions. These industry experts have kindly agreed to be at the event for your benefit. So do your homework, and come prepared with some good questions.
This Month the focus is on Business Intelligence. Our experts are three of the best. Boyan Penev, Darrren Gosbell and Simon Selves will be at hand to answer your questions and provide advice on the vast topic of SQL Server Business Intelligence and GIS.
Boyan Penev
Boyan is a SQL Server MVP who specialises in all components of the Microsoft SQL Server Business Intelligence stack.
Boyan’s topics of conversation will include Microsoft SQL Server BI Stack, Microsoft Office and the future roadmap of these products, their current capabilities and features, as well as Business Intelligence and Data Warehouse Best Practices and concepts.
..
.
Darren Gosbell
Darren Gosbell has over ten 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. Darren contributes to a number of open source projects including BIDS Helper, AS Stored Procedures, PowerSSAS and Dax Studio. Last year he was accredited as one of the first 11 Analysis Services Maestros...
Simon Selves
Simon is a GIS Masters Graduate with 14 years of Spatial Industry experience in both the UK and Australia, with strong expertise in the use of MapInfo and ESRI systems.
Simon specialises in Spatial Data Warehouse design and implementation using MS SQL Server 2008 R2 technology, Retail Network planning and analysis, Socio-demographic modelling and analysis for targeted marketing campaigns.
.
.
So come to SQL Server Social next week and meet our experts as well as other Melbourne data professionals. And don’t forget that this is a sponsored event, so we will have food and drinks available for registered attendees.
SQL Server Social No. 9 Event Details
When: 2012/08/08 From 6:00pm onwards
Where: The Bull & Bear Tavern, 347 Flinder’s Lane, Melbourne
How much?: Free!
Duration: ’til late!
See you there!
This entry was posted in Events, News, SQL Server Social and tagged Boyan Penev, Darren Gosbell, Melbourne, microsoft, Simon Selves, sql pass, sql server, SQL Server Social, sql social.
Lucky 7
Yes, SQL Server Social No 7 is on the horizon.
What’s more, we have a new helper – Vivek Pradhan has volunteered to assist with the organisation of the SQL Server Social starting with the next one on Wednesday, 6th June. We’ve asked Vivek to organise some events on the night (which might involve the free pool tables), so hopefully we can add something more to your evening. Watch this blog for more details.
Once again we are going to the The Bull & Bear Tavern, 347 Flinders Lane, Melbourne.
Please click here to register for the event.
This entry was posted in Events, News, SQL Server Social and tagged Bull & Bear, Melbourne, networking, sql server, SQL Server Social.
SQL Server Social May Event
It’s great to have another sponsor on board to make sure that you keep getting some food and drinks at the event.
Just in case you missed the bit at the bottom of the Avanade announcement, we do have another event this week.
On Wednesday, May 2nd at 6p.m., we are once again going to The Bull & Bear Tavern on 347 Flinders Lane, Melbourne.
Please remember to click here to register for the next event as we base our food and drink based on the number of people registered.
This entry was posted in Events, SQL Server Social and tagged Bull and Bear, Events, Melbourne, networking, SQL Server Social.
SQL Server Social 2012
Happy New Year everyone!!
2012 is here and it promises to be a big year for the SQL Server community – yes, that’s right, SQL Server Social is back and ready for its first full year of events.
Our normal slot for this month unfortunately clashes with Australia Day so we have decided to push it back by 1 week and it will now be held on Wednesday, 1st February. I think we’re still going to count this as a January event so keep an eye out for further announcements.
This month we are also trialling a new venue, the Bull and Bear at 347 Flinders Lane, Melbourne. The downstairs Tavern Bar is ours for the evening and is equipped with 2 pool tables (which will be on free-play for most of the evening), a pinball machine, darts and a guest appearance of a Wii console!
We’ll be there from around 5:30pm right through until 10pm (or later if you feel like it).
As usual the generous sponsorship of BizData and LobsterPot will be providing for some food and drinks specials.
Look out for the invitation via Eventbrite hitting your in-boxes in the next couple of days and we’ll see you there.
Martin
This entry was posted in Events, SQL Server Social and tagged BizData, Bull and Bear, Events, Lobsterpot Solutions, Melbourne, networking, PASS, sql server, SQL Server Social.