Master SQL Server Database Restores, Get MrbMiner Malware Protection and Restore TDE Enabled Azure SQL DB (MSSQLTips 9/21/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Get Immediate Protection from MrbMiner Malware]( [Restore TDE Enabled Azure SQL DB to On-Premises Server]( Learn how to take an TDE enabled database and restore it to another server or an Azure SQL database without using the encryption keys.... [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... [Protection from MrbMiner Malware]( DBDefence introduces new security layers not available natively in SQL Server. Without any code changes, DBDefence will encrypt your data, lock down the SA login, permit database access only via configured applications, protect your backups and enabl... [End to End Tutorial - SQL Server Database Restores]( What good is a backup if you do not know to restore the backup? In this tutorial we will look at what restore options are available and which options are only accessible using T-SQL commands.... [SQL Server Virtualization Challenges for DBAs (Webinar)]( Virtualization poses many challenges to DBAs - many of which are virtualization administrators and the tools that don't understand the specialized needs of database servers. If you have ever had a sysadmin ask... [Get to SQL Server Storage Performance Problems Quickly]( My organization has multiple storage solutions with different models for the same vendor, and different models across different vendors. Each product has its own set of tools for monitoring and managing. However, this is a headache because we have to... [SQL Server Encryption - No application changes + High Performance]( Learn about the options for SQL Server Database Encryption for GDPR Compliance including DbDefence.... MSSQLTips Week In Review [Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project]( In this article we demonstrate an end-to-end solution to deploy a database from Visual Studio to Azure SQL Database through GitHub and then deploy by an Azure DevOps Build and Release Azure pipeline.... [Capture Executions of Stored Procedures in SQL Server]( In this article we look at how to setup an Extended Events session in SQL Server using SSMS to capture stored procedure executions.... [Configure Log Shipping for SQL Server on Linux]( In this article we walk through the steps on how to implement SQL Server log shipping for SQL Server running on Linux systems.... [Create a Self-Service Framework for SQL Server DBA Tasks]( In this article we look at how to create a self-service framework to deploy database changes to non-production environments with minimal effort from the DBA.... [Execute SSIS Package in Azure with DTEXEC Utility]( In this article we look at how you can execute an Integration Services project deployed to Azure Data Factory from an on-premises machine with Azure enabled DTEXEC.... [Explore Your Data Lake Data Easily with Azure Synapse Analytics]( In this article we look at how to load data from Azure Data Lake Storage Gen2 and chart the data using Azure Synapse Analytics.... [Recursive Programming Techniques using Python]( In this article we discuss recursive programming techniques using Python.... [Weather Data Warehouse in SQL Server - Create and Populate]( In this article we look at how to build a SQL Server data warehouse structure to store historical weather data.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}