Data Vault Modeling and Certification

Data Vault Modeling and Certification

Certified Data Vault Data Modeler Course in Brisbane

WARDY IT Solutions is proud to be hosting the Certified Data Vault Data Modeler course in our award winning training facilities in Brisbane on the 21st and 22nd of July 2016.

This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your Data Warehouse and Business Intelligence projects. This course includes loading paradigms, architecture and how to develop an effective overall data vault data warehouse process. Successful completion of this course will result in a designation of Certified Data Vault Data Modeler – CDVDM.

Find out more and book on this course here – http://geneseeacademy.com/course-schedule?view=item&sid=352.

Data Vault modeling is rapidly becoming the standard modeling approach for the data warehouse and WARDY IT Solutions is one of the leading practitioners of this methodology.

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!

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 Server 2016 Hotlap Workshop in Darwin

SQL Server 2016 Hot Lap

WARDY IT Solutions is proud to announce that they will be delivering the first SQL Server 2016 workshops in Australia.

The workshops will be conducted as a free 2 hour Hot Lap.

A Hot Lap is a quick and concise way of finding out:

  • what’s new in SQL Server 2016
  • how these changes will improve database operations & developer efficiency and
  • enable self-service Business Intelligence and Data Analytics solutions.

Location:

Vibe Hotel Darwin Waterfront
7 Kitchener Drive, Darwin, NT

Date:

Tuesday 22nd March 2016

Times:

08:30: Arrival coffee/tea
09:00-10:30: SQL Server 2016 Hotlap
10:30-11:00: morning tea

Cost:

Free

To register for this free event:

Register Online Now

Benefits of Getting Up-to-Speed on SQL Server 2016:

SQL Server 2016 is going to be a game-changer:

  • Industry Leader – For the first time, Microsoft is the industry leader in Operational DBMS
  • Built-In Advanced Analytics – SQL Server 2016 is shipping with ground-breaking advanced analytics that provide the scalability and performance benefits of building and running advanced analytics algorithms directly in the core SQL Server transactional database.
  • Industry leading Performance – SQL Server continue to own the top 3 TPC-H benchmarks
  • Most Secure Database – SQL Server continues to be the most secure database on the planet for the 6th year in a row and has added new Always Encrypted technology that protects data at rest and in motion, on premise or on the cloud.
  • End to End Mobile BI on *any* device – SQL Server 2016 provide the best value for self-service BI with the broadest cross platform mobile support with native apps for Windows, IOS and Android.
Register Online Now

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

Temporal Databases Meeting

Upcoming SQL Server User Group Meeting in Melbourne

Introducing Temporal Databases in SQL Server 2016 with Amit Arora

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:

Microsoft Melbourne Office (Level 5, Building 4, Freshwater Place, Southbank, Melbourne)

Date & Time:

Tuesday, 15 March 2016, 5:30PM – 7:30PM

Please register here to let us know you are coming.

February 2016 QLD SQL Server User Group

Maintain SQL Server Performance Baseline w/ PowerShell

Maintain SQL Server Performance Baseline w/ PowerShell

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

About the Speaker

Allen White is the Business Development Manager for SQL Sentry. He’s been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server.  Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT.  Allen has been awarded Microsoft’s MVP Award for the last nine years.

Click here to register for the February 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)
On: Thursday, 25th February 2016

RSVP: to contact@wardyit.com to help with catering

 

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

Dashboard in A Day

Dashboard in A Day

Dashboard in A Day

Dashboard in A Day includes all the Data, (over 1 GB) and step-by-step courseware along with all the Visualizations and real-world use-cases – everything you need to confidently deliver a meaningful engagement with LoB users and Analysts.

A web conference on this was held recently and the download for DIAD has been made available.

Watch the Dashboard in a Day session

Download the Dashboard in a Day assets

Click here to request details about Dashboard in a Day

Location:

WARDY IT Solutions
Level 1, 164 Wharf St
Spring Hill, Queensland 4000
Australia

Date & time:

TBA

Cost:

$99  ex GST per person

December 2015 QLD SQL Server User Group

WARDY IT QLD SQL Server User Group

December QLD SQL Server User Group

Introducing Temporal Databases in SQL Server 2016

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.

Click here to register for the December 2015 User Group.

Location:

Microsoft Brisbane
Level 28, 400 George Street
Brisbane, Queensland 4000
Australia

Date & time:

Thursday, December 17, 2015 from 5:30 PM to 7:00 PM (AEST)

Cost:

Free

Click here to register for the December 2015 User Group