Microsoft Fabric, Query Tuning, Storage Problems, Tuning Checklist, and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Microsoft Fabric New Features Announced at Microsoft Build 2024]( Learn about new features of Microsoft Fabric such as Real-Time Intelligence, Fabric Workload Development Kit, GraphQL API, AI and Copilot, Data Factory Announcements, Task Flows, and Data Functions.... [mssqltips image]( [Dynamically Display Top N and Bottom N Records in One Power BI Chart]( This article will demonstrate the step-by-step process to dynamically display the Top N and the Bottom N records in the same Power BI chart.... [mssqltips image]( [Build Chatbot with Large Language Model (LLM) and Azure SQL Database]( In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Webinar: Performance Testing SQL Queries]( In this webinar, we will look at how to use SqlQueryStress, a free tool that allows SQL developers to mimic multiple users running one or more queries at once to help build better queries.... [mssqltips image]( [Webinar:Storage Performance Problems]( Learn how to unravel the many layers of the SQL Server infrastructure stack responsible for performance issues. We'll explore common bottlenecks, actual storage issues, network connectivity, and virtualization nuances. You'll leave with enough knowle... [mssqltips image]( [Getting Started with Microsoft Power BI]( Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Send an Alert when a SQL Server Database Configuration Changes]( There are times when a SQL Server database change is made and no one knows who made the change, when it was made, and what the change was. In this article, we look at how to capture these details with DDL Triggers. ... [mssqltips image]( [SQL Server Performance Tuning Checklist]( This SQL Server checklist will serve as a starting point to help determine what steps might make sense as part of a performance improvement effort.... [mssqltips image]( [DAX CASE Statement Functionality with IF, SWITCH and SWITCH True]( There is not a CASE statement in DAX, but in this article, we look at other options that have similar functionality such as IF(), SWITCH(), and SWITCH(TRUE()).... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]