Configure Log Shipping for SQL Server on Linux, Solve SQL Server Performance Issues and Working with SQL Server Dates (MSSQLTips 9/14/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Find Performance Bottlenecks Quickly with SQLGrease]( [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.... [SQLGrease Performance Monitoring Software]( Performance problems can be difficult to track down especially when they occur when no one is looking. SQLGrease captures historical query workload and gives you visibility to your performance bottlenecks. ... [Update only Year, Month or Day in a SQL Server Date]( We have an automated process to load exchange rates into a SQL Server database using a backend process. We found that it loaded almost all of the records perfectly except for a few records, for which it chose some random years when loading the data i... [Solving SQL Server Duplicate Data]( Does this sound familiar? You just removed the duplicate data from your SQL Server database. You are ready to add real-time or scheduled inserts, but you do not want to go through the hassle of re-processing every record. Now, you do not have to with... [Connecting to Integration Services Access is Denied in SQL Server]( After installing SQL Server 2017 or SQL Server 2016, a user tries to connect to SQL Server Integration Services (SSIS) for the first-time using SQL Server Management Studio (SSMS), most likely the connection attempt will fail. The received error me... [Faster SQL Server Clustering]( 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... MSSQLTips Week In Review [Auto Scaling Azure SQL DB using Automation runbooks]( Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.... [Azure Synapse Analytics Overview]( Azure Synapse Analytics is a platform as a service, designed to unite analytics, data integration and visualization experiences for users. This article is an overview of this service.... [Improve Power BI Performance with Horizontal Filtering]( In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance.... [Managing Azure Blueprints with PowerShell]( Learn about the Azure PowerShell cmdlet for Azure Blueprints in Azure Resource Manager framework and how to export, import, publish, and assign Azure Blueprints with PowerShell cmdlets.... [SQL Server High CPU Query Use Monitoring with PowerShell]( In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.... [SQL Server Reporting Services Reusable Code Blocks]( In this article we look at SSRS code you can use in all of your reports to handle divide by zero issues, setting color schemes, using special characters, automatic exports and more.... [Using SQL Server ROLL UP to Get Similar Results of COMPUTE BY]( In this article we take a look at how to get similar result sets when using ROLLUP versus COMPUTE BY in SQL Server queries.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}