Week in Review + Search all String Columns in a SQL Server Database, Deploy Failover Cluster on AWS and RELATED vs LOOKUPVALUE in DAX (MSSQLTips 5/9/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [Easily Deploy SQL Server Failover Cluster Instance on AWS]( [Easily Deploy SQL Server Failover Cluster Instance on AWS]( In this article we learn how to build a SQL Server Failover Cluster on AWS along with the steps to deploy using the AWS Launch Wizard.... [Search all String Columns in all SQL Server Tables or Views]( [Search all String Columns in all SQL Server Tables or Views]( In this article we look at T-SQL script you can use to search for a string in every table and view in every database or in a specific database.... [Learn about SQL Server 2022 with Bob Ward]( [Learn about SQL Server 2022 with Bob Ward]( [Webcast] Introduced last November SQL Server 2022 is the most cloud enabled version Microsoft has ever released. But the excitement does not stop there, continued performance, features and security innovations continue to be released as they move cl... [SQL DATE Functions]( [SQL DATE Functions]( In this article we will explore several SQL Server Date Functions and show many examples of the date functions usage.... [SQL Server DBAs Eyes into VMware]( [SQL Server DBAs Eyes into VMware]( We have a large SQL Server environment supported by physical servers, VMware and cloud infrastructure. Unfortunately, we are facing a number of performance challenges. We have frequent situations where the end user experience degrades.... [Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks]( [Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks]( This article will explore the different ways to read existing data in your Azure Data Lake Storage Gen 2 data lake and how to write transformed data back to it.... [Confidently Slash Downtime with Fast SQL Server Backup and Restores]( [Confidently Slash Downtime with Fast SQL Server Backup and Restores]( Learn how to slash downtime for SQL Server backup and restores with FlashBlade backup terabyte databases in minutes, make database restores your first choice for disaster recovery and protect your databases from ransomware.... [SQL Server RETURN and OUTPUT Clause in Stored Procedures]( [SQL Server RETURN and OUTPUT Clause in Stored Procedures]( In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.... [SQL Server Data Accuracy Survey - Share Your Perspective]( [SQL Server Data Accuracy Survey - Share Your Perspective]( [Survey] With the proliferation of data across the globe, data quality, accuracy and management present significant challenges for data professionals in the SQL Server community. Share your experiences.... MSSQLTips Week In Review [Azure Databricks Version Control for Notebooks]( [Azure Databricks Version Control for Notebooks]( Learn about how to setup and configure source control when using Azure Databricks notebooks in this article we look at how this can be done with GitHub.... [Configure and Query Change Data Capture (CDC) data for Azure SQL Database]( [Configure and Query Change Data Capture (CDC) data for Azure SQL Database]( Learn how to setup and use Change Data Capture for Azure SQL Database including steps to enable and query the data from the CDC tables.... [Getting started with SQL MAX Function with Use Cases]( [Getting started with SQL MAX Function with Use Cases]( In this article we look at how to use the SQL MAX() function in SQL Server to find the maximum values in a result set along with several examples of using SQL MAX().... [Getting Started with Statistics using Python]( [Getting Started with Statistics using Python]( In this article we look at how to use Python to get statistical data for mean, median, mode, min, max, range, variance, standard deviation and correlation.... [Overview of ETL Tools in the Microsoft Data Platform – Part 1]( [Overview of ETL Tools in the Microsoft Data Platform – Part 1]( In this article we look at various ETL tools to help with importing data into SQL Server such as Integration Services, Azure Data Factory and Azure Logic Apps.... [PowerShell for the DBA - Basic Functions]( [PowerShell for the DBA - Basic Functions]( In this article we look at how to get started writing functions in PowerShell along with several basic examples to get you started.... [RELATED vs LOOKUPVALUE in DAX: How and when to use them in Power BI]( [RELATED vs LOOKUPVALUE in DAX: How and when to use them in Power BI]( In this article we cover how and when to use the DAX functions RELATED and LOOKUPVALUE in Power BI to perform similar VLOOKUP capabilities in Excel.... [SSIS Bad Habits: Wrong OLE DB components configuration]( [SSIS Bad Habits: Wrong OLE DB components configuration]( In this article learn about best practices for using the OLE DB components in SQL Server Integration Services (SSIS) packages.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}