Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 19, 2024Mastering `sp_executesql`: Enhancing Security and Performance in SQL Serversp_executesql is a system-stored procedure in SQL Server used to execute a Transact-SQL statement or batch that can be reused multiple times, or to execute a dynamically built T-SQL statement. The primary advantage of using sp_executesql over EXECUTE...DiscussSQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Mar 15, 2024How to Improve SQL Server Performance: A Guide to Fixing Redo Operations Using DMVsIn SQL Server, particularly within the context of Always On Availability Groups or database mirroring, the REDO_THREAD_PENDING_WORK column can be an invaluable metric for troubleshooting performance issues. This metric essentially measures the amount...DiscussSQL
Sandeep PawarProfabric.guru·Feb 29, 2024Calculating and Reducing Power BI Dataset Size Using Semantic LinkSemantic Link v0.6 is out and it has many new exciting additions to its growing list of list_* methods. Highlighted are some of the new methods. Install the latest version and check it out. Some of the existing methods such as list_columns() have an...Martin du Toit and 2 others are discussing this3 people are discussing thisDiscuss·1.6K readsdataset optimization
Sandeep PawarProfabric.guru·Jan 29, 2024Using runMultiple To Orchastrate Notebook Execution in Microsoft FabricUsing runMultiple in MicrosoftFabric notebook isn't new. It was announced, I think, at MS Ignite in November 2023. I tested it and worked beautifully. But the Notebooks team has been quietly adding great features to it and I wanted to show some of th...Discuss·1.7K readsmicrosoftfabric
Sandeep PawarProfabric.guru·Jan 17, 2024One Line Code To Get A List Of Items From All The Fabric/Premium WorkspacesWhat the title says, thanks to the latest version (v0.5) of Semantic Link !pip install --upgrade semantic-link --q #upgrade to semantic-link v0.5 import sempy.fabric as fabric import pandas as pd df = pd.concat([fabric.list_items(workspace=ws) for...Discuss·1.2K readsmicrosoftfabric
Sandeep PawarProfabric.guru·Dec 7, 2023Refreshing Individual Tables and Partitions With Semantic LinkSince version 0.4 Semantic Link there have been several methods to refresh individual tables and partitions in a semantic model. In this blog, I will show how to use the .refresh_dataset().execute_tmsl() and TOM to achieve granular refresh. Prerequis...Discuss·3 likes·3.1K readssemantic-link
Parth Ladhashnode.thenavigatedata.com·Dec 4, 2023Power Query's Missing IN OperatorThe IN operator is a common feature in programming languages, allowing users to check if a value exists within a specified list. While Power Query M doesn't have a built-in IN operator, we can still achieve the same functionality using alternative me...DiscussDataFlowGen2
Sandeep PawarProfabric.guru·Nov 15, 2023Identifying Semantic Model Storage Mode in FabricWith the latest addition of Direct Lake as a storage mode in Power BI, the range of available storage modes continues to expand. If you look at the semantic models in the workspace, except for the Push Semantic Model, it's not possible to identify if...Discuss·851 readssemantic-link
Sachin Korgaonkar, PMP, MBA (Finance)thegeekgypsy.hashnode.dev·Oct 10, 2023Microsoft Fabric - Unified Data Analytics Platform - Part 1I recently had the opportunity to work on a project for a unified data analytics platform. Even though I had more experience with Databricks, the customer insisted on using Microsoft Fabric, which was launched in May 2023 and is still in public previ...Discuss·1 likemicrosoftfabric
Ian Santillanievsantillan.hashnode.dev·Oct 3, 2023Analyzing Wildlife Data with Microsoft FabricAnnouncement Announcing an end-to-end workshop on how you can build a powerful data analytics solution using Microsoft Fabric, to handle large-scale and complex data sets. This workshop provides you with a working knowledge on how to: Load data into...Discussfabric