Importance of a Good Data Model in Power BI, SFTP for Azure Blob Storage, SSRS Functions and SQL Server 2022 Window Clause (MSSQLTips 12/14/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Smart, Sharp Tools to Enhance Data Quality]( [Secure File Transfer Protocol (SFTP) support for Azure Blob Storage]( [Secure File Transfer Protocol (SFTP) support for Azure Blob Storage]( In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.... [The Importance of a Good Data Model in Power BI Desktop]( [The Importance of a Good Data Model in Power BI Desktop]( This tip will go through some guidelines for creating an optimized data model when working with Power BI for performance and accurate results.... [Smart, Sharp Tools to Enhance Data Quality]( [Smart, Sharp Tools to Enhance Data Quality]( How clean is your data? With 38+ years of experience in data quality, Melissa can help you verify addresses, validate identities, standardize contact information and enhance data. Download our Solutions Catalog today for free trials and POCs....... [SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports]( [SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports]( Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users....... [Monitoring for all of IT]( [Monitoring for all of IT]( End to End Monitoring | Health | Availability - I need to monitor the SQL Server instances in my environment and our IT team has a need to monitor the health and availability of our overall environment. We need to understand the issues in the enviro...... [SQL Server Connection Strings using SqlClient, OLDEDB and ODBC]( [SQL Server Connection Strings using SqlClient, OLDEDB and ODBC]( In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections....... [Simplify SQL Server Migrations to the Cloud]( [Simplify SQL Server Migrations to the Cloud]( Join this webinar to learn how to use AWS Migration Hub Orchestrator to simplify and accelerate SQL Server migration to Amazon EC2 and Amazon RDS....... [How to use the New WINDOW Clause in SQL Server 2022]( [How to use the New WINDOW Clause in SQL Server 2022]( In this tip, we'll introduce the new WINDOW clause in SQL Server 2022 and it can simplify queries with multiple OVER clauses....... [SQL Server Performance Tuning and Operational Monitoring]( [SQL Server Performance Tuning and Operational Monitoring]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager....... [By Daniel Calbimonte - ]( [SQL Server Database Stuck in Restoring State]( In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.... [By Sergey Gigoyan - ]( [Find and Remove Duplicate Rows from a SQL Server Table]( Learn how to find and remove duplicate rows from a SQL Server table with and without a unique index.... [By Koen Verbeeck - ]( [Improving data flow performance with SSIS AutoAdjustBufferSize property]( In SQL Server 2016 and later, a property has been added to the Integration Services (SSIS) data flow: AutoAdjustBufferSize. What is this property and how can I use it?... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}