Analyze SQL Server Results in Excel with Conditional Formatting, Business Intelligence Automation and more (MSSQLTips 2/24/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Indexing Tutorial - Start Learning Today]( [Analyze SQL Server Results in Excel with Conditional Formatting]( Learn how to format your SQL Server results in Excel using conditional formatting to quickly identify patterns and issues.... [SQL Server Business Intelligence Automation]( You may have heard the phrase "Data is the new Oil." Digital data is everywhere, and organizations are striving to leverage these large datasets called big data for their competitive advantage. Attend this webinar to learn how to efficiently leverage... [Using COPY INTO command to load Azure Synapse Analytics from Azure Data Lake Storage Gen2]( In this article we take a look at the Azure Synapse new COPY INTO command to load data into an Azure Synapse Table.... [SQL Server Disaster Recovery Options]( This presentation covers disaster recovery options for SQL Server like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise. Attend this free webinar to be prepared for any SQL Server dis... [SQL Server Backups Tutorial]( One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. Become an expert on SQL Server Backups.... [Data Quality Solutions for SSIS]( Melissa also understands how to seamlessly integrate their solution into key business processes with minimal code changes for organizations to quickly recognize the benefits. For organizations that rely on the SQL Server Data Platform, Melissas solu... [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [Do you need a faster 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... MSSQLTips Week In Review [Encrypting SQL Server Backups for Legacy Systems]( In this article we look at how to encrypt SQL Server backup files for systems where SQL Server does not support backup encryption.... [Logging Azure Data Factory Pipeline Audit Data]( In this article we look at how to implement a process to track the log activity for ADF pipelines that run and persist the data.... [MSSQLTips.com Author and Rookie of 2019]( Check out the MSSQLTips.com Author and Rookie of 2019. Congrats to all of the authors that completed for this award!... [Split Delimited String into Columns in SQL Server with PARSENAME]( In this tip we look at how to parse or split SQL Server data from one column into multiple columns using the parsename and other T-SQL functions.... [SQL Server Agent Service Won't Start Due to Access Denied]( In this article we look at the SQL Server error failed to initialize SQL Agent log (reason: Access is denied) and how this can be solved.... [SQL Server Checkpoint Monitoring with Extended Events]( In this article we look at how to use SQL Server Extended Events to monitor performance of checkpoints for databases not using indirect checkpoints.... [SQL Server Integration Services Power Query Source]( In this article we look at how to use a Power Query source when building a SQL Server Integration Services package.... [SQL Server Maintenance Plans History Cleanup Task]( In this article we look at how to configure the SQL Server Maintenance Plan History Cleanup task and why you should be using it.... [Using COPY INTO command to load Azure Synapse Analytics from Azure Data Lake Storage Gen2]( In this article we take a look at the Azure Synapse new COPY INTO command to load data into an Azure Synapse Table.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}