Gartner Magic Quadrant for Advanced Analytics Platforms
Predictive analytics and other types of advanced analytics technology are becoming major factors in the analytics market. This Magic Quadrant evaluates 16 leading providers of advanced analytics platforms that are used to build solutions from scratch. Find out more about how Microsoft is a visionary in this area here.
Allan Hirt Mission Critical Deep Dive
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
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.
Running R Scripts in Power BI
With just a few steps in Power BI Desktop you can run R scripts and create a data model, from which you can create reports, and share them on the Power BI service. Find out more about how you can use R with Power BI, click here.
Analyze Data History Using Temporal Tables
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.
Power BI Mobile App
The Power BI Mobile App provides access to all of your data from both SQL Server Reporting Services 2016 on-premises and Power BI in the cloud. You can download and find out more this rich visualization experience for mobile devices here.
