Build Really Fast SQL Server VMs (MSSQLTips 08/17/2018)

[logo]( Free SQL Server Resources [Delivering Microsoft SQL Server High Availability on AWS]( [tip image]( You can use AWS services like Amazon EC2 and Amazon RDS to quickly build, deploy, scale and manage your SQL Server databases, which helps you build more agile applications. This webinar will cover best practices for running SQL Server business-critical applications on AWS. [How to restore a SQL Server database to another server after disabling TDE]( [tip image]( We need to restore a database using a backup from a different SQL Server where TDE is enabled for that database. On disabling TDE and then performing a backup, the database backup was copied on to the new SQL Server instance and then restored. The restore failed even though TDE was disabled before performing the database backup on the source server. Is there a way by which we can still perform the restore successfully on the new SQL Server instance? [10 Ways to Save Money and Provide High Availability for SQL Server]( [tip image]( Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in this informative white paper. [Optimizing Type 2 Slowly Changing Dimensions in Integration Services]( [tip image]( In the [first part]( we introduced the reasoning behind type 2 slowly changing dimensions. We also discussed different implementation options in Integration Services (SSIS). Finally, we started with an implementation in the data flow using out-of-the-box transformations only, so we can build an optimized data flow for loading a type 2 dimension. In this tip, we’ll continue the implementation. [Build Really Fast SQL Server VMs]( [tip image]( Virtualization and SQL Server are both mature technologies and have advanced well together. While many large workloads still favor physical hardware, it is possible to build virtual machines that match physical performance, but they come at tradeoff. [Automate SQL Server and Systems Monitoring]( [tip image]( First, let’s get something out of the way: monitoring is not a ticket, or a page, or a screen. Monitoring is nothing more than the ongoing, consistent collection of metrics from and about a set of devices. Everything else–reports, alerts, tickets, and automation–are a happy by-product of the first part. More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. If you do not wish to continue receiving emails from MSSQLTips.com, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}