December 2017 Roundup

December 2017 SQL Server Roundup

On behalf of the WARDY IT Solutions team, I would like to thank all of our customers and partners for their support in 2017. I wish everyone a fabulous Festive Season and all the best for the New Year!

For those of you planning to take the Christmas period off, our Virtual DBA Service operates 24x7x365 so if you have any issues with your SQL Servers during the Christmas break, please don’t hesitate to get in touch.

Scroll down to read my top picks for the last month of 2017.

World-class SQL Sever support at a fraction of the cost

Spinal Life Australia are one of Queensland’s leading providers of advocacy, therapy and support for people with spinal cord damage. Being a not-for-profit, their focus is on delivering support to their clients. In this short video, Matthew Linscott, CIO, explains how the Virtual DBA service allows them to tap into a team of highly skilled DBAs that they could never afford themselves, on demand, 24×7.

Preview: SQL Operations Studio

SQL Operations Studio is a free, light-weight tool by Microsoft for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines. You can get your hand on it right away, consider it an early Christmas present from Microsoft. Download Preview here.

Graph Database Processing with SQL Server 2017 and Azure SQL Database

With graph extensions in SQL Server 2017 and Azure SQL Database, you can get the best of both relational and graph databases in a single product, including the ability to query across all data using a single platform. Users can also benefit from other cutting-edge technologies already available in SQL Server, such as columnstore indexes, advanced analytics using SQL Server R Services, high availability, and more. Learn more about it here.

Move on-premise SQL Servers to Azure with near-zero downtime

The Azure Database Migration Service is in public preview! It’s a fully managed migration service designed to work together with tools like Data Migration Assistant, Database Experimentation Assistant, and SQL Server Migration Assistant The new service uses a guided, easy-to-implement process to streamline tasks and regular operations can continue as normal during the migration. Learn more and download.