SSIS, Clustering, Cloud, Extended Events and more (MSSQLTips 08/22/2019)

Free SQL Server Resources [High Performance SANLess SQL Server Failover Clusters]( [White Paper] 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 approaches... [How to Stop a SSIS Package Execution from Code]( In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately. [SQL Server High Availability & Disaster Recovery in the Public Cloud]( [Webcast] Planning to move your SQL Server instances to any of the major public cloud platforms requires considerations for both high availability and disaster recovery. Attend this webinar to learn about the differences and similarities between AWS, Azure and Google Cloud Platform. [Cost Savings - SQL Server Licensing and SAN Storage]( [White Paper] Learn how a #SANLess cluster can cut licensing costs and eliminate SAN storage costs while delivering complete high availability and disaster protection for SQL Server. [SQL Server Extended Events Tutorial]( Learn about SQL Server Extended Events including the architecture, numerous ways to setup new sessions, templates, editor tips, creating or altering sessions, associated DMVs and more. [Survival of the Fittest: Melissa's Matching Approaches for Golden Record Management]( [Webcast] There is no debate - duplicate data is unwanted data. But, issues behind duplicate data detection persist, such as sound-alike matches, misspellings, abbreviations, nicknames and other variants of fuzzy matching records. So how do you overcome those challenges? [SQL Server Profiler Tutorial]( SQL Profiler provides you with an easy to use interface that allows you to select the events you want to monitor and where you want the output to be saved without having to know all the system stored procedures that are a part of SQL Trace. Without this tool you would have to go through the tedious process of manually setting up each event and filter with individual stored procedure calls for every event you want configured in your trace. 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}