Working with IAsyncEnumerable in C#IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of […] 24 avril 2024 dans Sites anglophones étiqueté .NET / Homepage par simple-talk.com
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – […] 22 avril 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Building a Culture of Data: The Technical AspectsIn the first part of this two-part series, I covered the mostly non-technical aspects of building a […] 19 avril 2024 dans Sites anglophones étiqueté Blogs / Culture / Data culture / Homepage par simple-talk.com
Database Subsetting and Data ExtractionLet’s start by defining a subset and why you would require a data subset? When dealing with […] 17 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / Theory and design par simple-talk.com
Exploration Experience: Saving and Creating DatasetsI have been talking about Data Exploration in Power BI on many of my sessions, specially the […] 17 avril 2024 dans Sites anglophones étiqueté Blogs / Data Exploration / Microsoft Fabric / Power BI par simple-talk.com
Snake draft sorting in SQL Server, part 2In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […] 15 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Snake draft sorting in SQL Server, part 1I recently had a restore job where I needed to split the work up into multiple parallel […] 12 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Fabric and Azure SQL in a few clicks: Mirroring a ...Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […] 12 avril 2024 dans Sites anglophones étiqueté BI / Homepage / Microsoft Fabric par simple-talk.com
How to Use Any SQL Database With RustRust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t […] 11 avril 2024 dans Sites anglophones étiqueté Homepage / Rust / Web par simple-talk.com
Azure OpenAI and RAG SecurityThe most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […] 10 avril 2024 dans Sites anglophones étiqueté Azure / Blogs / openai / Security par simple-talk.com
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, ...In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in […] 8 avril 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Giving Feedback on Microsoft Data Platform ToolsAs a data professional, there is a set of tools that you use on pretty much a […] 8 avril 2024 dans Sites anglophones étiqueté Editorials / Homepage / SQL Server par simple-talk.com
Dynamic Partitioning and a Simple Incremental LoadLet’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode(« overwrite »).format(« delta »).partitionBy(« Year », »Month », »Day »).save(« Tables/ » + table_name) […] 3 avril 2024 dans Sites anglophones étiqueté Blogs / lakehouse / Microsoft Fabric par simple-talk.com
Building MongoDB Aggregations in MongoDB CompassThis article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […] 2 avril 2024 dans Sites anglophones étiqueté Homepage / MongoDB / NoSQL par simple-talk.com
SQL LogicIn this article, I will discuss the history and thinking behind several types of logic that are […] 29 mars 2024 dans Sites anglophones étiqueté Database Theory / Homepage / Theory and design par simple-talk.com
Pagination and ordering by large valuesPagination is a technique for limiting output. Think of Google search results, shopping the electronics category on […] 25 mars 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Department of Redundancy DepartmentEver wonder all the reasons that we use databases instead of file systems? While we don’t think […] 18 mars 2024 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
The Benefits of Volunteering at SQL SaturdaysEditor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […] 14 mars 2024 dans Sites anglophones étiqueté Blogs / Career par simple-talk.com
Transforming and Analyzing Data in PostgreSQLIn our data hungry world, knowing how to effectively load and transform data from various sources is […] 12 mars 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Get the most out of SQL Server Agent logsIf you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on […] 11 mars 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Reverse Creating the PBIP file from Source ControlOn my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […] 6 mars 2024 dans Sites anglophones étiqueté Blogs / Git / Microsoft Fabric / Power BI / Source Control / Uncategorized par simple-talk.com
Writing your 2024 PASS Data Community Summit SubmissionIt is time again for the PASS Data Community Summit Call For Speakers. Some of you are […] 5 mars 2024 dans Sites anglophones étiqueté Opinion Pieces par simple-talk.com
Serverless Authentication methods in web apps.Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional […] 5 mars 2024 dans Sites anglophones étiqueté cloud / Homepage par simple-talk.com
The Value of Conference SpeakingEditor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, […] 4 mars 2024 dans Sites anglophones étiqueté Career / Homepage par simple-talk.com
Building MongoDB AggregationsThis article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […] 1 mars 2024 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
Friendly Deletes in SQL ServerOne of the first things you learn when working with SQL Server, and other transactional based SQL […] 1 mars 2024 dans Sites anglophones étiqueté Blogs / DELETE Statement / Performance / SQL Server par simple-talk.com
Find and Replace Text in Strings in T-SQLString manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […] 29 février 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Upgrade SQL Server on your workstationLately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. […] 26 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Database Feature TogglesIn software development the concept of feature toggles are used to selectively turn on and off features. […] 19 février 2024 dans Sites anglophones étiqueté Homepage / Software Delivery par simple-talk.com
Functions and Procedures: Learning PostgreSQL with GrantOne of the most useful constructs in SQL Server is the stored procedure. It gives you a […] 15 février 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
Leave it better than you found itThis is for the folks who still have to log into remote machines and do work manually […] 12 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Automating BCP with PowerShellI was talking with a good friend that has an environment with terabytes of information and to […] 9 février 2024 dans Sites anglophones étiqueté Homepage / PowerShell par simple-talk.com
Feature Flags in Data ProjectsMy motivation for writing this summary was an interaction with a project owner that didn’t understand why […] 1 février 2024 dans Sites anglophones étiqueté ADF / Blogs / CI/CD / Feature Flags / Power BI / SSIS / SSRS par simple-talk.com
Adding a new AI usage policy to Simple-TalkI used to think plagiarism was my worst thing to deal with as an editor. That is […] 26 janvier 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
Top-Down and Bottom-Up Approaches in Microsoft FabricNikola Ilic, best known as Data Mozart, published a great article and video about how to make […] 25 janvier 2024 dans Sites anglophones étiqueté Azure / BI / Homepage / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
State of the Database Landscape Results 2024Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […] 23 janvier 2024 dans Sites anglophones étiqueté Career / Databases / Homepage / stateofdatabaselandscapesurvey par simple-talk.com
Querying MongoDB DocumentsMongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […] 22 janvier 2024 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
The Importance of RetentionIt is always an afterthought. New objects are created that start off small and current. New feature […] 19 janvier 2024 dans Sites anglophones étiqueté Database Administration / Homepage / T-SQL Programming par simple-talk.com
Working on Technology Off the ClockI have always spent time learning relational databases on my own, non-work time. As the years have […] 16 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Semantic Model: More than a Simple Name ChangeThe animation on the top of this article tries to track the evolution of the enterprise architecture […] 10 janvier 2024 dans Sites anglophones étiqueté Blogs / Data Warehouse / lakehouse / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
Optimized locking in Azure SQL DatabaseI don’t think I’ve ever had a great impression of Azure SQL Database as a place for […] 8 janvier 2024 dans Sites anglophones étiqueté Azure SQL Database / Database Administration / Homepage / Locking par simple-talk.com
PowerShell Dynamic Parameters and SQL ServerHave you ever been in a situation that you want to call a cmdlet or a function […] 5 janvier 2024 dans Sites anglophones étiqueté Homepage / PowerShell par simple-talk.com
Being A Bit Less Comfortable in 2024I hate coming up with ideas for editorials, but my last editorial of the year gives me […] 3 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Two-Dimensional Interval Packing ChallengePacking intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […] 2 janvier 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming / Theory and design par simple-talk.com
Warehouse Load Patterns – Part 2 – Load PatternsThis continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […] 31 décembre 2023 dans Sites anglophones étiqueté BenJohnston_ETL / Blogs / ETL / load patterns par simple-talk.com
Eager Aggregation in SQL queriesAggregation is a widely used way to summarize the content of a database. It is usually expressed […] 27 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL / Theory and design par simple-talk.com
Introducing the MongoDB DocumentMongoDB is a document database. As such, the data is stored as individual documents. A document is […] 26 décembre 2023 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
Counting more efficientlyNearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […] 20 décembre 2023 dans Sites anglophones étiqueté Homepage / metadata / T-SQL Coding / T-SQL Programming par simple-talk.com
Using a SQL TokenizerImagine this: you have several directories full of SQL script files, and you need to know where […] 18 décembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft FabricI have published videos and articles before about Lakehouse maintenance. In this article I want to address […] 17 décembre 2023 dans Sites anglophones étiqueté BI / Homepage par simple-talk.com