Sandeep PawarProfabric.guru·Nov 18, 2024Querying Fabric KQL Database Using REST APII have previously explained how to query a KQL database in a notebook using the Kusto Spark connector, Kusto Python SDK, and KQLMagic. Now, let's explore another method using the REST API. Although this is covered in the ADX documentation, it isn't i...Discuss·495 readsmicrosoftfabric
Sandeep PawarProfabric.guru·Nov 13, 2024QuickTip: Querying KQL Tables From Other Workspaces In FabricIn Fabric, if you want to query a delta table from a lakehouse in another workspace, you create a shortcut to that table. Similarly, in Eventhouse, you can also create shortcuts to Eventhouses in other workspaces, but the option might not be immediat...Discuss·528 readseventhouse
Sandeep PawarProfabric.guru·Oct 29, 2024🪄KQLMagic Is Now In Fabric Runtime 1.3I wrote a blog last year on the usefulness of KQLMagic command in Fabric notebook and made a suggestion that it should be part of the default runtime. Well, guess what - it’s now in the Fabric Runtime 1.3. No installation necessary and authentication...Discuss·348 readsnotebookeverything
Dru BanksProbluecordsecurity.io·Oct 26, 2024KC7 Case: A Rap BeefTwo hip-hop artists are caught in a musical feud that extends into cyberspace. One artist's oversharing in his lyrics makes him a target, leading the rival label to hire a hacker to exploit vulnerabilities. As a security analyst for OWL Records, your...Discussthreat intelligence
Kazhian Muthusami (Kaz)kazhian.hashnode.dev·Sep 15, 2024Log Query LanguagesLog Query Languages are designed for querying, analyzing, and processing log data and other time-series data. These languages are typically optimized for handling large volumes of data generated by applications, systems, and devices, making them part...Discussspell
Jonathan DeLeonforCybersecurity Projects & Blogmrcyberleon.hashnode.dev·Aug 24, 2024Utilize Custom Analytics with Query in Microsoft Sentinel to monitor for malicious login activities.Objective: Utilize SIEM technology to consolidate logs (Windows Events) for ingestion into the SIEM and formulate a custom analytics query to run/detect potential malicious activity, thereby monitoring for possible Brute Force Login attempts. Tools: ...DiscussAzure
Simonsimonlvgn.hashnode.dev·Jun 11, 2024VS Code Extensions for Detection EngineeringIntroduction In this blog post, we'll explore useful Visual Studio Code extensions for detection engineering. These extensions can help you write and validate rules, navigate complex data structures, and even interrogate databases. Let's dive in! Sig...Discussstix
Josef Richbergjosefrichberg.com·Feb 6, 2024Extracting Azure Analysis Services Metrics from your Log Analytics workspace into PowerBIWe have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will enable you to pull all the user/query information necessary to manage these servers...Discuss·150 readsPowerBI
Sandeep PawarProfabric.guru·Aug 27, 2023Creating Shortcut To KQL Table In Fabric LakehouseShortcuts in Microsoft Fabric are one of the best features that allow you to point to any location on OneLake from any engine without moving the original data. It just magically makes it appear virtually via embedded references within OneLake. The of...Sandeep Pawar and 3 others are discussing this4 people are discussing thisDiscuss·861 readsKQL
Sandeep PawarProfabric.guru·Aug 25, 2023Building Insightful Analytical Solutions Using KQLMagicA few months ago, I wrote a blog post about querying a KQL database in Fabric notebooks using the Python Kusto SDK. Although it works perfectly, my friend Alex Powers reminded me that kqlmagic can also be used in notebooks for a more ad hoc experienc...Discuss·693 readsmicrosoftfabric