Working with Azure Functions, Power Platform Certification Exam Prep and Week in Review (MSSQLTips 1/27/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server 2022 is now generally available]( [Retrieve a File from Azure Blob Storage with an Azure Function]( [Retrieve a File from Azure Blob Storage with an Azure Function]( In this tip, we'll cover a solution that retrieves a file from Azure Blob storage into the memory of an Azure Function.... [Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam]( [Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam]( This resource includes several links to related topics to help you prepare for and pass exam PL-900 Microsoft Power Platform Fundamentals.... [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, visibility, and governance over your entire data estate....... [How to install SQL Server 2022 step by step]( [How to install SQL Server 2022 step by step]( In this article, we cover how to install SQL Server 2022....... [SSIS Data Quality Solutions]( [SSIS Data Quality Solutions]( Learn about the Melissa Data Quality Solutions for SSIS....... [Schedule, Export and Email Power BI Reports using Power Automate]( [Schedule, Export and Email Power BI Reports using Power Automate]( Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate....... [High Performance SQL Server Backup and Restore]( [High Performance SQL Server Backup and Restore]( 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....... [Learning the SQL GROUP BY Clause]( [Learning the SQL GROUP BY Clause]( Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets....... [SQL Server and DB2 Performance Considerations]( [SQL Server and DB2 Performance Considerations]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems....... MSSQLTips Week In Review [Create and Format a Bullet Chart in Power BI]( [Create and Format a Bullet Chart in Power BI]( In this article, we will go through the steps to create and format a bullet chart in Power BI. ... [Evaluating SQL Server Filtered Indexes in a Multi Table SQL Join]( [Evaluating SQL Server Filtered Indexes in a Multi Table SQL Join]( In this tip, we look at filtered indexes and how to create them in SQL Server as well as how to get a filtered index to work when pulling data back from more than one table.... [Find Updated Columns in Update Transaction with New BitWise Operators in SQL Server 2022]( [Find Updated Columns in Update Transaction with New BitWise Operators in SQL Server 2022]( Learn about the new bitwise operators in SQL Server 2022 along with a practical example of how to use these new operators.... [Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory]( [Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory]( Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.... [Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1]( [Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1]( This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema. ... [SQL Server Monitoring On-premises and Cloud for Management and DBAs]( [SQL Server Monitoring On-premises and Cloud for Management and DBAs]( The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to help ... [Steps to add a new disk to SQL Server failover cluster instance and move a user database to it]( [Steps to add a new disk to SQL Server failover cluster instance and move a user database to it]( In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.... [Transfer data from MySQL database to Microsoft SQL database]( [Transfer data from MySQL database to Microsoft SQL database]( In this article, we look at how to migrate data from MySQL to SQL Server and how to keep the data between the two databases synchronized.... [Understanding Cloud Transformation Roles and Responsibilities]( [Understanding Cloud Transformation Roles and Responsibilities]( This article provides a clear overview of the key cloud roles and responsibilities involved in cloud platform transformation and administration. These roles include leadership, development, and support personas at both cloud and traditional levels that al... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}