SQL Server Performance Tuning Tricks, Five Costly Myths About High Availability and SSRS Mobile Tutorial (MSSQLTips 12/13/2019)

Free SQL Server Resources [Five Costly Myths About High Availability in Cloud]( [Whitepaper] While the benefits of the cloud may be clear for applications that can tolerate brief periods of downtime, it is not as clear for business critical applications, such as SQL Server, Oracle, and SAP that require high availability and disaster recovery protection. Separating the facts and myths of HA and DR in cloud deployments can help you save money and reduce risk of downtime and data loss. [Replace Model SQL Server Database with a User Database]( Database Configurations | System Databases | Disaster Recovery - In this tip we look at what happens if we replace the SQL Server model database with a regular user database. [SQL Server Performance Tuning Hints and Tricks]( [Webcast] The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common SQL Server performance issues you'll encounter. [DAX in SQL Server Tutorial and Example]( In this tutorial we are going to learn to create DAX formulas to get desired information from a Tabular Model ranging from getting a simple calculation to solving a slightly complex analytical problem. We are going to run DAX formulas against a deployed tabular model to find out different type of facts based on different requirements. This tutorial is primarily focused on the technique to create simple DAX queries and then moving forward to create slightly complex DAX queries step by step. [SQL Server Maintenance Plans Rebuild Index Task]( SQL Server Maintenance Plans | Step by Step | Index Rebuild - In this article we look at how to create a SQL Server Maintenance Plan to rebuild indexes. [SQL Server Reporting Services Mobile Reporting Tutorial]( SQL Server Reporting Services (SSRS) 2016 introduced Mobile Report Publisher which is intended to develop reports for mobile devices, tablets as well as desktops. It ships with 30 different visualizations that can be used to develop rich mobile dashboards. Built-in simulators can be used to test reports for different layouts, which eliminates the need for external third-party device specific simulators. Integration of the Power BI application with SSRS addresses the complexity of rendering reports on a variety of devices and platforms. [Controlling Cloud Costs without Sacrificing Availability or Performance]( [Whitepaper] Shortly after contracting with a cloud service provider, a bill arrives that causes sticker shock. There are unexpected and seemingly excessive charges, and those responsible seem unable to explain how this could have happened. The situation is critical because the amount threatens to bust the budget unless cost-saving changes are made immediately. More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}