Adelaide SQL Server User Group


Welcome to the Adelaide PASS group - covering SQL Server and every aspect of the Microsoft Data Platform and Data Analytics space. You can find us on the 3rd Wednesday of each month at the Microsoft offices, Level 12, 147 Pirie St.

There's a link below to get on the mailing list. This is a mailchimp list, rather than the one that PASS handles.

We use EventBrite for meeting registrations - please look at for a list of our meetings.

Many years ago, we used, and you can see an archive of events on that site - but the Adelaide mailing list from there hasn't been used for some time.

Now, a quick word about privacy...

The details of event registrations are held with EventBrite, and I use that to update my EventBrite contacts, which is then used to update a mailchimp list for sending emails about the group. If you ever want to be removed from either my EventBrite contact list or the mailchimp list, please just let me know (rob at I do this for you and will do my best to keep your privacy private.


Get on our mailing list by clicking here!

Our next event

Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at

Our next meeting is: Wed, Jun 15 2016 12:00 to 14:00 in Adelaide.

ElasticSearch - Oh my search!
This abstract describes some goals of the project. First of all, it is example of end to end solution for specific problem in specific scope. The problem is how to find valuable info in the heap of (un)structured in fast, secure and reliable manner with minimum resources and efforts. The scope is typical corporate windows environment with common resources: shared files with predefined extension (pdf, MS Office documents and emails, images, etc.), Active Directory domain security, SQL Server databases, etc. Also, solution should be free of charge (or low cost). The main architectural factors are: Containerisation. All modules are isolated and independent with Customizable API and powerful front ends Simple and scalable with clustering; easy to maintain and monitor Open source and reliable search engine with reach API In general, solution contains of 2 parts: Back end. Elastic Search v5 was chosen as search engine for the solution. PowerShell scripts and ElasticSearch configurations were set up as examples for integration, automation and monitoring. Front end. ASP.Net Core was chosen as best fitted for that kind of tasks. It covers all typical front end requirements

Speaker: Andrew Butenko
Andrew Butenko is a practitioner with 20+ years’ experience in the industry focusing on the Microsoft stack of products. He has worked with Microsoft SQL Server since v6.5 and is certified as MCSE, MCTS, MCSA, MCITP, and MCDBA. Andrew is passionate about online education and is credited by Microsoft Virtual Academy as a Founders Club membership (top 1 Australia, top 50 World). Also he has recently enrolled in a postgraduate program in computer science at Adelaide Uni, and he works as a software developer at Nova Systems. You can contact Andrew via his blog at


There is always stuff going on in the PASS community. For more information about these events, please contact the group leader, Rob Farley (try emailing through

PASS provides the Adelaide Data & Analytics User Group with this website and other miscellaneous resources. The Adelaide SQL Server User Group is an official PASS Chapter. Microsoft provides the Adelaide Data & Analytics User Group with a venue in which to meet! LobsterPot Solutions provides the Adelaide Data & Analytics User Group with the catering, the services of Rob Farley and others for hosting and finding presenters, and all the necessary admin effort.




Back to Top