Week in Review + Managing Schema Drift, SQL Functions, New SQL Server 2022 Webcast, Snowflake Tutorial and more (MSSQLTips 1/24/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]( [Managing schema drift within the ADF copy activity]( [Managing schema drift within the ADF copy activity]( In this article we look at an approach in Azure Data Factory to handle unexpected schema changes without the data flow breaking and creating runtime issues.... [Get to SQL Server Storage Performance Problems Quickly]( [Get to SQL Server Storage Performance Problems Quickly]( My organization has multiple storage solutions with different models for the same vendor, and different models across different vendors. Each product has its own set of tools for monitoring and managing. However, this is a headache because we have to... [SQL Server Functions Tutorial]( [SQL Server Functions Tutorial]( In this tutorial / reference guide we cover several SQL Server functions that are related to strings such as LEN, TRIM, SUBSTRING, LOWER, UPPER and many more. Each function also includes several examples of the usage and the syntax.... [SQL Server Data Warehouse Cleansing, Verification and Matching]( [SQL Server Data Warehouse Cleansing, Verification and Matching]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?... [SQL Server DATEPART Function]( [SQL Server DATEPART Function]( The DATEPART function returns an integer value for the specified part of the date or time. It can be a year (yy, yyyy), quarter (qq, q), month (mm, m), dayofyear(dy, y), day (dd, d), week (wk, ww), weekday (dw, w), hour (hh), minute (mi, n), second (... [New SQL Server 2022 backup and restore options]( [New SQL Server 2022 backup and restore options]( SQL Server backup and restore are the life blood of a production DBA. Doing it fast and doing it well are as important as ever, in today's data climate. In this webinar Microsoft PM Melony Qin, will explain and demonstrate the new S3 object store fea... [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... [Build a Secure SQL Server REST API in Minutes]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.... MSSQLTips Week In Review [Add Last Step to SQL Agent Jobs for Failure Notification]( [Add Last Step to SQL Agent Jobs for Failure Notification]( In this article we look at how to automatically add a final custom notification step to all existing SQL Agent jobs using PowerShell by reading and adjusting jobs steps as needed.... [C# Application for Azure SQL Database]( [C# Application for Azure SQL Database]( In this article we look at how to create a simple C# application to retrieve data from Azure SQL Database.... [Enterprise SQL Server Performance Tuning and Management with dbWatch]( [Enterprise SQL Server Performance Tuning and Management with dbWatch]( We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an effi... [How to use Factless Fact Tables in a Data Warehouse Business Intelligence Solution]( [How to use Factless Fact Tables in a Data Warehouse Business Intelligence Solution]( Learn about factless fact tables and how to use them to enhance the data in your data warehouse to build better business intelligence solutions.... [How to Use the SSIS Profiling Output File to Generate SQL Server Sparse Columns Script]( [How to Use the SSIS Profiling Output File to Generate SQL Server Sparse Columns Script]( In this article we look at how to identify columns that are candidates to be SQL Server sparse columns as well as automatically generating the scripts to make the change.... [Implement Dimension Denormalization Using Synapse Mapping Data Flow]( [Implement Dimension Denormalization Using Synapse Mapping Data Flow]( In this tip we are going to discuss dimensional denormalization when working with Azure Synapse Analytics to reduce joins and improve performance.... [Model and Log Trend Reversals for Time Series Data in SQL Server]( [Model and Log Trend Reversals for Time Series Data in SQL Server]( This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well a... [More Reasons to Enable SQL Server Indirect Checkpoints]( [More Reasons to Enable SQL Server Indirect Checkpoints]( In this article we look at indirect checkpoints for SQL Server databases and why you should enable this setting for your SQL Server databases.... [SQL Convert Function Examples and Alternatives]( [SQL Convert Function Examples and Alternatives]( In this article we take an in depth look at the SQL Server CONVERT function as well as discuss possible alternatives to convert to different datatypes.... [Use MACD to Predict When to Buy and Sell Securities with T-SQL]( [Use MACD to Predict When to Buy and Sell Securities with T-SQL]( In this article we look at using TSQL to create MACD moving average convergence/divergence indicators to predict buy and sell indicators for stocks.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}