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

Feb 2016 Microsoft Certification Update – SQL Server 2014

Microsoft Learning

Microsoft Learning is pleased to announce that they are refreshing their SQL Server related exams and certifications to have continued relevance for database professionals working with either SQL Server 2012 and 2014.

As of February 18, 2016, Exams 461 through 467 will include content covering both SQL Server 2012 and 2014. In January, a link to a document describing the corresponding changes in the exam was added to the Skills Measured section of each exam web page.

To reflect the inclusion of SQL Server 2014 content in Exams 461, 462463, Microsoft Learning is also rebranding the MCSA certification to MCSA: SQL Server 2012/2014. As changes to each individual exam are modest in size and SQL Server 2012 skills remain relevant, all current certification MCSA: SQL Server 2012 certification holders will have their transcripts updated accordingly to reflect the new credential name.

As the MCSE certifications already do not reference product version, no changes in the titles of either MCSE: Data Platform or MCSE: Business Intelligence credentials will take place (see also the FAQs here).

via: https://borntolearn.mslearn.net/b/weblog/archive/2016/02/17/feb-2016-certification-update-sql-server-2014

The full range of WARDY IT SQL Server 2012/2014 Exam Training Courses is available here.

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.

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.

RACT Insurance Hones Their Business Intelligence by Collaborating with WARDY IT Solutions

RACT Insurance Case Study

Overview

Understanding the relationships between data sets and applying actuarial science across this information is critical for a risk based industry like insurance. Bottom line profitably is attributable to how effectively risk versus reward ratios are managed. RACT Insurance’s existing software was dated and an ad-hoc approach to reporting made comparative assessment between business divisions complex and time consuming. The Business Intelligence (BI) team at RACT Insurance utilised the opportunity of a business systems upgrade to design a new analytical system that could provide a competitive advantage to the business. RACT Insurance worked with WARDY IT Solutions to design and build a new BI Solution that would meet the business’ reporting and analytics requirements. Project delivery was aligned to a wider IT project of legacy system replacement. By centralising data models and creating a single source of truth, a more disciplined method of creating structured and uniform reports was achieved. RACT Insurance business units now deliver more intuitive reporting that offers actionable insights. This helps the organisation rapidly adapt to changing market conditions that could adversely affect business profitability.

WARDY IT Solutions helped by:

  • Reducing operational risk by removing dependence on legacy software and a marketplace skills deficit
  • Replacing an inflexible system that could not easily integrate with other analytical business tools
  • Applying best practice guidelines to ensure a more disciplined and consistent approach to reporting across the entire business
  • Constructing a new BI framework with widely available skills built on industry standard Microsoft tools and applications
  • Creating an environment that achieves rapid ROI and can easily adapt to RACT Insurance’s future needs

WARDY IT Solutions added value integrating and optimising the solution for RACT Insurance and helped the company avoid common pitfalls that could have impeded the progress of delivering a successful project outcome.

Read the full case study here.

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