Create a Star Schema in Power BI Desktop, Azure SQL Managed Instance Auditing, Distribute Python Code and Week in Review (MSSQLTips 12/19/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server 2022 is now generally available]( [Enable Auditing for Azure SQL Managed Instance]( [Enable Auditing for Azure SQL Managed Instance]( In this article, we look at how to enable auditing for an Azure SQL Managed Instance.... [How to Create a Star Schema in Power BI Desktop]( [How to Create a Star Schema in Power BI Desktop]( Learn how to build a star schema data model using Power BI Desktop for improved report development and performance.... [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....... [SQL DATE Functions]( [SQL DATE Functions]( In this article we will explore several SQL Server Date Functions and show many examples of the date functions usage....... [Find, Analyze and Optimize SQL Server Performance]( [Find, Analyze and Optimize SQL Server Performance]( Learn about the Query Tuning and Table Tuning Advisors in SolarWinds Database Performance Analyzer to find, analyze and optimize SQL Server performance....... [Simple way to Import XML Data into SQL Server with T-SQL]( [Simple way to Import XML Data into SQL Server with T-SQL]( In this tip we look at a simple way to import a simple XML document into a SQL Server table....... [Strategies to Improve SQL Server Storage Performance]( [Strategies to Improve SQL Server Storage Performance]( Learn about important considerations for SQL Server Professionals building and managing large databases - storage, lower life cycle environments, performance, IO, backups, snapshots, DBCCs and more....... [Create a Python Wheel File to Package and Distribute Custom Code]( [Create a Python Wheel File to Package and Distribute Custom Code]( In this article we will explore how to create a Python wheel file using Visual Studio Code, load it to a Databricks Cluster Library, and finally call a function within the package in a Databricks Notebook....... [Enterprise SQL Server Performance Tuning and Management]( [Enterprise SQL Server Performance Tuning and Management]( 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...... MSSQLTips Week In Review [Adding a Database Project to a Visual Studio Solution]( [Adding a Database Project to a Visual Studio Solution]( In this article, we will look at how to add database code to a Visual Studio solution along with the application code.... [Building a SQL Computational Framework for MACD Indicators]( [Building a SQL Computational Framework for MACD Indicators]( This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.... [Comparing PARSEONLY and NOEXEC options in SQL Server]( [Comparing PARSEONLY and NOEXEC options in SQL Server]( In this article, we look at different ways to check query syntax by using PARSEONLY, NOEXEC as well as executing the code to see how SQL Server handles each of these.... [Creating an Entity Relationship Diagram (ERD) for Database Applications]( [Creating an Entity Relationship Diagram (ERD) for Database Applications]( In this article, we look at various aspects of an ERD (entity relationship diagram) and how to put together an ERD for your database applications.... [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.... [Understanding SQL Server Schemas]( [Understanding SQL Server Schemas]( Learn about SQL Server schemas in this overview tip that explains what they are, how to create, and creating objects in different schemas.... [Using sp_prepare and sp_execute to utilize prepared SQL statements]( [Using sp_prepare and sp_execute to utilize prepared SQL statements]( Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}