• Building RESTful APIs in Rust With Actix and Diesel

    Updated: 2024-04-26 14:54:23
    There are many packages and tools that you can use to facilitate your API development with Rust. Rust has a rich third-party ecosystem of crates for building APIs, including web packages like Actix and Rocket and ORMs like Diesel and SeaORM. This article delves into using Actix and Diesel to build web applications. You’ll learn … The post Building RESTful APIs in Rust With Actix and Diesel appeared first on Simple Talk.

  • Working with IAsyncEnumerable in C#

    Updated: 2024-04-24 15:37:58
    IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of data asynchronously. It is a great fit for building ETLs that asynchronously stream data to get it ready for transfer. You can think of IAsyncEnumerable as the asynchronous counterpart of IEnumerable because both interfaces allow you to easily … The post Working with IAsyncEnumerable in C# appeared first on Simple Talk.

  • 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.

  • 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.

Previous Months Items

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