Getting Started with Azure Data Studio, ETL Developer Interview Questions, Tuning a Data Warehouse and more (MSSQLTips 7/20/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [AWS is the cloud that runs SQL Server best - Tell me more]( [Azure Data Studio (ADS) - Download, Installation and Configuration]( [Azure Data Studio (ADS) - Download, Installation and Configuration]( In this article, we look at different ways to download and install Azure Data Studio to work with SQL Server databases.... [ETL Interview Questions for the Microsoft Data Platform – Part 1]( [ETL Interview Questions for the Microsoft Data Platform – Part 1]( Check out this article about possible interview questions you might have if you are seeking a position as an ETL developer using the Microsoft Data Platform.... [Migrate and modernize SQL Server with AWS]( ) [Migrate and modernize SQL Server with AWS]( ) Make SQL Server end of support the start of your AWS cloud journey. Run with the best.... [How to Get Current Date in SQL Server]( [How to Get Current Date in SQL Server]( In this article we will explore the different options for getting the current date from SQL Server and understand when to use one option over the other.... [T-SQL Best Practices and Tuning for the BI/DWH Developer]( [T-SQL Best Practices and Tuning for the BI/DWH Developer]( In this webinar, we will go over some T-SQL best practices from the viewpoint of the BI developer when working in the Microsoft Data Platform stack.... [Getting Started with Snowflake Tutorial]( [Getting Started with Snowflake Tutorial]( In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors. We look at how to load and query data as well as how to use Power BI to create reports using the Snowflak... [Need SQL Server High Availability?]( [Need SQL Server High Availability?]( If you need to migrate to Azure at end of support (EOS), and you require HA for SQL Server 2008/2008 R2, there is only one solution recommended by Microsoft: SIOS DataKeeper. SIOS DataKeeper enables clustering in the cloud, including the creation of ... [Searching and finding a string value in all columns in a SQL Server table]( [Searching and finding a string value in all columns in a SQL Server table]( Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.... [Application Performance Monitoring for all of IT]( [Application Performance Monitoring for all of IT]( We need to understand the performance issues in the environment at a high level, prioritize our findings then drill into the root cause in order to correct the issues. Ideally, we would like to have a single monitoring tool for the DBA, Development a... [By Manvendra Singh - ]( [How to read the SQL Server Database Transaction Log]( In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.... [By Chad Churchwell - ]( [Concatenate SQL Server Columns into a String with CONCAT()]( In this tip we look at different ways to concatenate SQL Server string data and how to deal with NULL values when concatenating strings.... [By Nisarg Upadhyay - ]( [Export SQL Server Data to Multiple Excel Worksheets using SQL Server Integration Services]( In this tip we look at how to write an SSIS package to export data from different SQL Server tables to different worksheets in the same Excel file.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}