May 2022 Top Tips + SQL Server Internal Database, DAX Rounding Functions and Late Arriving Dimensions (MSSQLTips 6/1/2022)

[tag] [MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [Discover Ways to Automate a Data Dictionary]( ) [The importance of SQL Server’s internal database version]( In this article see how you can prevent compatibility issues when trying to restore a SQL Server database from one instance to another by examining the internal database version number.... By Aaron Bertrand - [Learn More]( [DAX Rounding Functions for Power BI Reports]( In this article we look at various ways you can use DAX to round numbers for Power BI reports using round, rounddown, floor, trunc, mround, ceiling, roundup and iso.ceiling.... By Kenneth A. Omorodion - [Learn More]( [Migrating SSIS Packages]( Migrating on-premises SSIS data can be challenging. Learn how to manage this workload using DataOps tools and eliminate needless programming of SSIS components and improve the efficiency of your data-centric applications in production.... [Learn More]( [Implement Late Arriving Dimensions on Data Lakehouse using Azure Synapse Mapping Data Flow]( In this tip we discuss ways to handle late-arriving dimensions when working with a Lakehouse and Azure Synapse Analytics.... [Learn More]( [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.... [Learn More]( [SQL Server Reporting Services Mobile Reporting Tutorial]( SQL Server Reporting Services (SSRS) 2016 introduced Mobile Report Publisher which is intended to develop reports for mobile devices, tablets as well as desktops. It ships with 30 different visualizations that can be used to develop rich mobile... [Learn More]( [Quickly Pinpoint SQL Server Performance Issues]( My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our producti... [Learn More]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Learn More]( [Email Validation Simplified with Web API and SSIS]( Email is mission critical in our organization. Our organization uses email as a means to communicate with current and prospective customers due to the cost, speed, simplicity and interactivity. We need to ensure our email addresses are correct when t... [Learn More]( MSSQLTips - Last Month's Top Ten Tips [SQL Database Overview]( [Configure and Query Change Data Capture (CDC) data for Azure SQL Database]( [SQL Server PIVOT and UNPIVOT Examples]( [Search all String Columns in all SQL Server Tables or Views]( [Getting started with SQL MAX Function with Use Cases]( [PowerShell for the DBA - Basic Functions]( [PowerShell for the DBA - CMDLETs and Advanced Functions]( [How to Avoid Making Remote Desktop Connections to SQL Server]( [Overview of ETL Tools in the Microsoft Data Platform – Part 1]( [My Favorite T-SQL Enhancements in SQL Server 2022]( [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}