Vote for your favorite MSSQLTips authors (MSSQLTips 12/26/2017)

[MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [Vote for your favorite MSSQLTips authors!]( [SQL Server Database Mail Health Check for all SQL Servers]( In this tip we look at a script you can use to make sure Database Mail is setup and working on all of your SQL Servers.... By Svetlana Golovko - [Learn More]( [Implement SQL Server High Availability and Disaster Recovery on Amazon EC2 - Part 4]( Read this tip to learn how to setup Always On Availability Groups for SQL Server in AWS.... By Pinakin Patel - [Learn More]( [Retaining ETL Data from Files, APIs and Data Feeds]( Data comes from various locations and sometimes there is the need to access the original dataset after it has been loaded in the database. In this tip we take a look at a few ways this can be done.... By Tim Smith - [Learn More]( [Synchronize SQL Server Schema and Data Changes]( Join this webcast to learn how SQL Comparison Toolset provides an intuitive interface to analyze and synchronize schema and data, automate such processes, and generate ready-to-use synchronization scripts. ... [Learn More]( [Create a High Performance SANLess SQL Server Cluster]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Learn More]( [Simplify Your Database Migrations and Upgrades]( You can say migrations and upgrades to a database administrator (DBA) or systems administrator, but what they usually hear is risk and downtime. This e-book shows you how to simplify the migration and upgrade process so you can avoid the risk, downti... [Learn More]( Vote for your favorite MSSQLTips Authors MSSQLTips Week In Review [Changes to CXPACKET waits in SQL Server]( In many OLTP systems, parallelism is only truly useful on a subset of queries. Most of the typical workload is comprised of quick queries that affect a small number of rows and, in turn, consume very little in terms of resources. When queries do end up us... By Aaron Bertrand - [Learn More]( [Deploy SQL Server Integration Services Projects to Multiple Environments Using C#]( Read this tip to learn how to deploy SSIS projects to many target servers (Dev, SIT, UAT and other test environments) using C#.... By Nat Sundar - [Learn More]( [Implement SQL Server High Availability and Disaster Recovery on Amazon EC2 - Part 3]( In this tip we look at how to install SQL Server 2016 in AWS to setup an AlwaysOn Availability Group.... By Pinakin Patel - [Learn More]( [Learn how to Migrate a SQL Server database to SQL Azure server]( Learn the step by step process to migrate a SQL Server database to SQL Azure server via an export and import of bacpac files.... By Vitor Montalvao - [Learn More]( [Learn SQL Server from Microsoft’s Own Code]( Learn how to capture code from SQL Server system objects in Management Studio, PowerShell and SMO to improve your skills.... By Jeffrey Yao - [Learn More]( [Overview of XEvent Profiler in SQL Server Management Studio]( Check out this tip to learn how to use the new Extended Events profiler in SSMS.... By Rajendra Gupta - [Learn More]( [PowerShell AWS Tools for Fast File Copy]( Learn how to have a fast file copy with the PowerShell AWS tools.... By Douglas Correa - [Learn More]( [Purge SQL Server MSDB Database History Tables with Partitioning]( Learn how to efficiently purge the SQL Server MSDB database without causing blocking or filling up the transaction log.... By Pablo Echeverria - [Learn More]( [Querying SQL Server Temporal Table MetaData]( Find out more about SQL Server Temporal Table MetaData with sys.tables, OBJECTPROPERTY(), sys.periods and sys.columns.... By Ameena Lalani - [Learn More]( [SQL Server Clustered Columnstore Index Examples for ETL]( Learn about when to consider using SQL Server Clustered Columnstore Index for ETL processes and when other alternatives may yield better performance.... By Tim Smith - [Learn More]( [Twitter]( [Facebook]( [LinkedIn]( [GooglePlus]( You are receiving this email as a subscriber of MSSQLTips.com. If you do not wish to continue receiving email 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}