February 2017 QLD SQL Server User Group

February 2017 QSSUG

Azure Machine Learning Test Drive

Wouldn’t it be beneficial if a hospital could identify patients who are at high risk of readmission, or predict wait times based on staff levels, patient data and emergency room size?

Machine learning tries to provide the answers. Azure Machine Learning makes it supremely easy to build machine learning experiments that train, score and evaluate ML models and publish as web service.

In this session, Ram will cover how to easily build, test and deploy machine learning models using Azure Machine Learning.

The session will be demo based and will inspire you to further extend Azure Machine Learning capabilities.

About the Presenter

Ram Katepally is a Data Analytics Consultant for WARDY IT Solutions. He is MCSE for both Data Platform & Data Analytics, with a passion for analytics and visualizations. In his free time he is a avid player of chess.

Click here to register for the February 2017 QLD SQL Server User Group

Location:

Microsoft Brisbane – Level 28, 400 George Street, Brisbane

Date & Time:

Thursday, 23rd February 2017
Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)

Register now!

December 2016 QLD SQL Server User Group

StretchDB – Deep Dive QSSUG

StretchDB – Deep Dive

Stretch Database migrates your cold data transparently and securely to the Microsoft Azure cloud. Stretch Database targets transactional databases with large amounts of cold data, typically stored in a small number of tables. It enables organisations to save costs, save data for longer periods of time without having to worry about storage, and maintenance costs. It’s a great feature in SQL Server 2016 and will be enhanced further in future SQL Server versions.

This presentation will introduce industry experts to the technology, what it can offer and how it can meet your business requirements. The presentation will include a demo.

About the Presenter

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 11 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

Click here to register for the December 2016 QLD SQL Server User Group

Location:

Microsoft Brisbane – Level 28, 400 George Street, Brisbane

Date & Time:

Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
Thursday, 15th December 2016

Click here to register

October 2016 Canberra SQL Server User Group

Managing Your SQL Server Infrastructure

Operational Excellence in Managing Your SQL Server Infrastructure

Invariably the database solutions hosted on your SQL Server infrastructure represent line-of-business or other mission-critical applications. Consequently it is important to ensure that your SQL Server infrastructure is being managed according to established best practice. With more databases and a shortage of database administrators the industry has seen a decline in operational excellence with SQL Server management.

This user group session will cover operational best practices in areas such as configuration, storage, backups, monitoring and patching. Whether you have 5 or 500 SQL server instances under management, this session will help ensure they are reliable, robust and optimal. This session will have plenty of practical advice and takeaways that you can immediately implement within your organisation.

About the Speaker

Victor Isakov (MCA, MCM, MCT, MVP) is a Microsoft Certified Architect on the Data Platform who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and regularly presents at various international events and conferences. He’s authored a number of books on SQL Server and developed Microsoft certification/courseware. Victor is one of only three non-Microsoft MCAs globally.

Click here to register for the October 2016 Canberra SQL Server User Group

Location

Microsoft Canberra Branch – Level 4, 6 National Circuit, Barton

Date & Time:

4:30 PM to 6:00 PM
Tuesday, 4 October 2016

Click here to register for the October 2016 Canberra SQL Server User Group

Accessing Encrypted Data Using SQL Server and 2016 Always Encrypted

Accessing Encrypted Data Using SQL Server

Using SQL Server and 2016 Always Encrypted to Access Encrypted Data

Protecting sensitive data using encryption is not new, but functionality in .Net 4.6 and SQL Server 2016 allows this without ever revealing the keys to the SQL server. This talk will be a brief review of existing encryption development methods and a taste of the new functionality.

About the speaker

Duncan Greaves is a Business Intelligence architect based in Adelaide. He has over 20 years’ experience in secure and accessible systems development, mainly in the areas of banking, utilities and healthcare. Duncan’s special interest areas are in security architecture and privacy.

Location:

Venue: Microsoft Brisbane – Level 28, 400 George Street, Brisbane

Date & Time:

Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 26th May 2016

RSVP: to contact@wardyit.com to help with catering
To Register: http://www.meetup.com/QLD-SQL-Server-User-Group/events/231090925/

Register now!

Canberra – Microsoft Business Intelligence Roadmap

Canberra SQL Server User Group

Microsoft Business Intelligence Roadmap

In the session you will gain an understanding of the Microsoft Business Intelligence roadmap and where Power BI fits and how it can be leveraged to present stunning data visualizations.

About The Presenter

Peter Ward is the Managing Director for WARDY IT Solutions (www.wardyit.com), a consulting and training company specialising in Microsoft SQL Server solutions which he founded in 2004.  With a proven track record of implementing SQL Server solutions ranging from Architecture and Design Consulting to Database Development and Business Intelligence, Peter have grown WARDY IT Solutions to be Australia’s leading SQL Server consultants, trainers and Business Intelligence specialists.

Click here to register for Microsoft Business Intelligence Roadmap in Canberra

Location:

Microsoft Canberra Branch
Level 4, 6 National Circuit, Barton (map)

Date & Time:

4:30 PM to 6:30 PM
Tuesday, May 3, 2016

Click here to register for Microsoft Business Intelligence Roadmap in Canberra

Reminder: 12 April 2016 – Sydney SQL Server User Group – Introducing Temporal Databases in SQL Server 2016

Temporal Databases in SQL Server 2016

Introducing Temporal Databases in SQL Server 2016 – Sydney

More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.

Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.

This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.

About the Speaker

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

Location:

Mechanics School of Arts, Level 1, 280 Pitt St, Sydney

Date & Time:

Tuesday, 12 April 2016, 5:30PM – 7:30PM

Please register here to let us know you are coming.

A Lap Around Columnstore – Brisbane

Person delivering a speach.

A Lap around Columnstore Event

Columnstore indexing was first introduced in SQL Server 2012, however it was not widely adopted.

SQL Server 2014 added additional functionality to columnstore which resulted in a marginally higher uptake.

The initial versions required some creative thinking to get all of the promised performance gains out of the technology.

Now, SQL Server 2016 enhances this functionality greatly and it’s all set to become mainstream.

Columnstore promises significant performance gains for datawarehouses along with operational analytics.

This presentation will look at many of the new features in columnstore as well as briefly look at some of the internals and give the audience some insight into how they can leverage its potential.

About the Presenter

Martin Catherall is a RockSolid SQL consultant, a SQL Server MVP, PASS Regional Mentor for the Asia Pacific (APAC) region and until recently leader of the Christchurch, New Zealand SQL Server User Group. Now based in Melbourne, he’s getting to know the Australian SQL community.

He has been using SQL Server in various roles since 2000. In addition to anything data related be enjoys playing the guitar and having fun with his family.

Location:

Microsoft Brisbane
Level 28, 400 George Street, Brisbane (map)

Date:

Thursday 24th March 2016

Time:

05:30 PM

Click here to RSVP for the event

Microsoft Azure for the SQL Server DBA – Canberra

Microsoft Azure for the SQL Server DBA

Microsoft Azure for the SQL Server DBA

SQL Server has shipped with features that integrate Azure since 2008 R2. Fast forward to 2016 and we have seen plenty of development from Microsoft in the cloud arena. As our IT landscape evolves in support of cloud-based computing, this technology will slowly but surely become more integrated into the life of a DBA. In this session we explore what Azure means for your applications, how to identify good candidates for the cloud, and how to build your Azure knowledge FAST.

About the Presenter

Michael van Halderen is an independent SQL Server professional who has been working in the IT industry for over 14 years. He has worked exclusively with SQL server for more than 8 years in both DBA and DB Developer roles in Australia and the UK. Michael has contributed to SQL Server exam development in Redmond and holds an MCSE: Data Platform certification.

Location:

Microsoft Canberra Branch
Level 4, 6 National Circuit, Barton (map)

Date & Time:

Tuesday, 05 April 2016, 5:00PM

Please register here to let us know you are coming.

SQL Social No. 41 – Windows and SQL Server Memory Concepts

Food and 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

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

Amit Arora – Windows and SQL Server memory concepts

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

SQL Server as an application leverages Memory resources from the base operating system, therefore, it’s important for DBA’s to understand both, Windows and SQL memory fundamentals. This session will aim to deep dive into some Windows and SQL Server memory management concepts along with a few important tips for some known SQL Server issues around memory.

Some of the concepts covered in the session will be VAS (Virtual Address Space), Virtual Address Translation, Buffer Pool, MTL, Memory Objects, Memory nodes etc.

This talk will aim to draw an image of memory reservation and allocation operations for SQL Server in particular.

Time and Date:

Wednesday, March 2, 2016
5:45 PM to 8:00 PM

Location:

The Royal Melbourne Hotel
629 Bourke Street, Melbourne

Click here to RSVP for the event

Introducing Temporal Databases in SQL Server 2016 | Amit Arora

Temporal Databases in SQL Server 2016

Introducing Temporal Databases in SQL Server 2016 – Sydney

More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.

Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.

This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.

About the Speaker

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

Location:

Mechanics School of Arts, Level 1, 280 Pitt St, Sydney

Date & Time:

Tuesday, 12 April 2016, 5:30PM – 7:30PM

Please register here to let us know you are coming.