SQL Server Database Mirroring Status Check and Manual Failover Scripts (MSSQLTips 02/06/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [StarWind VSAN = High Performance + High Availability with Minimal Resources]( [SQL Server Database Mirroring Status Check and Manual Failover PowerShell Scripts]( In this tip we have a PowerShell script that can be used to check the status of SQL Server database mirroring as well as generate the code need for a failover of the databases.... [Continuous SQL Server Database Integration with Visual Studio and Azure DevOps]( In this tip we learn about how we can do continuous SQL Server Database integration using Visual Studio and Azure DevOps.... [SQL Server Auditing Webinar]( Attend this free webinar to see what built-in SQL Server auditing tools are available and begin or improve your current SQL Server auditing procedures.... [Secrets to High Availability for SQL Server on AWS]( Many companies rely on key applications such as SQL Server for their important business functions. Because downtime for these applications can be devastating to their business, IT typically has to meet strict service level requirements/agreements (SL... [Tutorial - Machine Learning with SQL Server 2017 and R]( In this tutorial, we will learn the basics of machine learning where we will learn the necessary data science to examine data in relevance to machine learning model development. We will be using R in SQL Server 2017 to apply machine learning related ... StarWind Virtual SAN – More than just a software-defined storage solution What do an awesome software-defined storage solution and Falcon 9 have in common? Both are fast, innovative, and have a lower price tag than their competitors. Well, as you know, we do not build rockets, but we've built StarWind Virtual SAN. Here are 6 points why you should consider StarWind Virtual SAN: A robust set of features - This solution makes enterprise-grade hyperconvergence available & affordable for businesses of any scale. Innovative - VSAN is the first software-defined storage bringing NVMe-oF to all hypervisors. Full-throttle your flash drives! Support - Make your IT life easier with [StarWind ProActive Support]( – the service that conjoins AI-driven metrics analysis engine & StarWind’s support team for preventing issues across your entire environment instead of dealing with their consequences. 4x smarter CPU utilization - Be it a converged environment or a hyperconverged one, with VSAN in place, you can always fine-tune CPU resource consumption to make your application performance ace. Performance - Get 80 % of the underlying storage performance on spindles. Squeeze 100 % IOPS out of NVMe drives. Free version for POC - Start your virtualization experience with StarWind for free with [StarWind Virtual SAN FREE](. [Find out more about the solution](. [Script to Manage SQL Server Rebuilds and Reorganize for Index Fragmentation]( Check out the script in this tip on how to manage SQL Server index fragmentation for either rebuilding or reorganizing indexes. The script also handles databases that are part of AlwaysOn Availability Groups.... [Stored procedure to generate HTML tables for SQL Server query output]( The requirement is to create an easy way to generate an HTML table as output for a SELECT query. With this tool you can create quick and simple HTML reports. ... [SQL Server Reporting Services Bookmarks and Document Maps]( What are the SQL Server Reporting Services Document Map and Bookmark properties? How can they be used? Do they work for all rendering formats? Can you show me any examples?... [Twitter]( [Facebook]( [LinkedIn]( [Google+]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, 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: {EMAIL}