• 4 Reasons to use KustoDB for Real-Time

    Updated: 2024-04-23 17:00:45
    When implementing real-time ingestion, we usually implement an architecture called lambda. Using the lambda architecture, KustoDB in Microsoft Fabric is always recommended for the speed layer. Do you know why? Let’s analyze in detail. 1 – KustoDB uses SSD KustoDB uses an internal SSD storage. Lakehouses use ADLS as their backend. In this way, Kusto … The post 4 Reasons to use KustoDB for Real-Time appeared first on Simple Talk.

  • Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

    Updated: 2024-04-22 01:12:09
    The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL. In the first article, we discussed … The post Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3 appeared first on Simple Talk.

  • Building a Culture of Data: The Technical Aspects

    Updated: 2024-04-19 20:52:36
    In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While the lion’s share of the work will be getting people to work together and embrace ever deeper use of data, as a reader of Simple-Talk, a lot of this transition will be technical. In this … The post Building a Culture of Data: The Technical Aspects appeared first on Simple Talk.

  • Database Subsetting and Data Extraction

    Updated: 2024-04-17 21:27:55
    Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data. In doing so, the development team will be hit with the difficulties of managing and accommodating the … The post Database Subsetting and Data Extraction appeared first on Simple Talk.

  • Exploration Experience: Saving and Creating Datasets

    Updated: 2024-04-17 17:00:02
    I have been talking about Data Exploration in Power BI on many of my sessions, specially the sessions about Data Marts. The new data exploration feature is one more feature on this expanding scenario for data exploration. This one brings some interesting details. We start using this feature from a query. The feature will allow … The post Exploration Experience: Saving and Creating Datasets appeared first on Simple Talk.

  • Snake draft sorting in SQL Server, part 2

    Updated: 2024-04-15 00:14:55
    In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel. In the previous example, we determined a distribution order for databases based on size – though you can rank by … The post Snake draft sorting in SQL Server, part 2 appeared first on Simple Talk.

  • Snake draft sorting in SQL Server, part 1

    Updated: 2024-04-12 10:34:31
    I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times. Imagine a job that loops through and restores each … The post Snake draft sorting in SQL Server, part 1 appeared first on Simple Talk.

  • Fabric and Azure SQL in a few clicks: Mirroring a Database

    Updated: 2024-04-12 02:26:00
    Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now. Before getting into a step-by-step of the … The post Fabric and Azure SQL in a few clicks: Mirroring a Database appeared first on Simple Talk.

  • How to Use Any SQL Database With Rust

    Updated: 2024-04-11 00:20:16
    Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on the “fearless concurrency” mantra but also on its expanding ecosystem that fosters integration with various technologies. A domain Rust proves to be formidable is database interaction, and a pivotal player in this realm is the … The post How to Use Any SQL Database With Rust appeared first on Simple Talk.

  • Azure OpenAI and RAG Security

    Updated: 2024-04-10 22:08:08
    The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and Cloud Security: Secure Access from your Applications to Azure SQL explain private endpoints from different points of views: Azure SQL and Function Apps. The concepts of Private Endpoints apply to most Azure features and even the relation of … The post Azure OpenAI and RAG Security appeared first on Simple Talk.

Previous Months Items

Mar 2024 | Feb 2024 | Jan 2024 | Dec 2023 | Nov 2023 | Oct 2023