Welcome to the January 2016 newsletter from Australia's leading SQL Server Consultants, Trainers and Business Intelligence specialists.
Organisations are always looking for new and innovative ways that they can ensure continual business improvement and maximize the investments in their Data Assets. WARDY IT Solutions continues to be a thought-leader in assisting organisations deliver Business Intelligence and Advanced Analytics solutions that deliver this vision. Recently WARDY IT Solutions has assisted A2 Milk Company improve sales ROI with analytics that reveal deep insights into international sales performance. You can find out more in this recent case-study that showcases this solution.
WARDY IT Solutions is also proud to have founded the QLD Power BI User Group with the inaugural meeting on Thursday 11 February 2016 (full details here). If you want to know more about Power BI and how it can assist in unlocking business insights then contact the proven Power BI Experts, WARDY IT Solutions.
Whether your business hours are 9 to 5 or 24x7x365, your systems need to be up when the business requires them. This advanced 4-day workshop, designed for SQL Server professionals and IT administrators alike, will not only teach you the technical and non-technical things you need to have for solid high availability and disaster recovery solutions, but also show you demonstrations and hands-on labs with multiple versions of SQL Server. Planning, implementing, and administering of the solutions will be covered, and will be taught by Cluster MVP, author, and SQL Server high availability expert Allan Hirt. There are limited places on these workshop so register here today.
Query Store is a new feature in SQL Server 2016, and Azure SQL Database V12. It’s designed to help you with query performance troubleshooting. As your database grows in size it is not unusual to experience performance regressions. Without the ability to see all the changes in the query plans it’s difficult to figure out why regressions happen and what you can do to prevent them in the future. Query store is designed to simply to this troubleshooting by providing the equivalent of a black box flight recorder. To find out more about this feature refer to here.
Backing up DocumentDB Databases
Backing up is a basic building block of a Business Continuity and Disaster Recover (BCDR) plan, and something you absolutely cannot afford to get wrong. Through engagement with customers Microsoft has devloped and verified backup strategies to enable all customers to build a successful BCDR plan. To find out more about these back strategies refer to here.
SQL Server Security
Security is unquestionably a major priority for Microsoft. A recent news story reported that Microsoft is spending over $1 billion a year to make Microsoft products more secure. The Microsoft data platform, including SQL Server and Azure SQL Database, is at the top of the list of products investing in security. To find out more about SQL Server Security refer to the Security Center for SQL Server Database Engine and Azure SQL Database.
Temporal Tables are a new feature in SQL Server 2016 that provides insights from historical data. Temporal Tables allow you to track the full history of changes without additional code and lets you focus your data analysis on a specific point in time in a very simple and efficient way. Find out more about Temporal Tables refer to here.