Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle Database for Database Professionals Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management... 05 December 2024 12 min read
Dennes Torres in Microsoft Fabric Granting Permissions in a Fabric Data Warehouse and Lakehouse We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We... 04 December 2024 4 min read
Louis Davidson in Editorials Love Your Conference Sponsors You probably already realize this, but I work for a company that sponsors conferences. As the editor of Simple Talk,... 04 December 2024 4 min read
Lukas Vileikis in MySQL MySQL Index Deep Dive: Clustered B-Tree Indexes If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database... 03 December 2024 10 min read
Lee Asher in PostgreSQL Overlapping Ranges in Subsets in PostgreSQL In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to... 29 November 2024 10 min read
Robert Sheldon in MongoDB Working with MongoDB Indexes Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I... 26 November 2024 20 min read
John Kerski in Career Hiring and Motivating Technical Polyglots in Data Analytics In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who speaks multiple languages... 22 November 2024 9 min read
Dennes Torres in Conferences Breaking Down Ignite: A Pragmatic Look at the Conference’s Best Innovations The amount of news brought by Ignite is huge. I was not expecting to find so many new features, resources,... 21 November 2024 10 min read
Edward Pollack in SQL Server Reading and Writing Parquet Files in SQL Server When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data... 19 November 2024 16 min read
Aisha Bukar in Databases MySQL vs PostgreSQL: Numeric Datatype Comparison When you think of how to store data in a database, you think of data types. A data type represents... 15 November 2024 18 min read
Dennes Torres in Blogs KQL: The top of a group in an easy way When learning something new, we always compare it with what we know. In this case, we end up comparing KQL... 13 November 2024 3 min read
Louis Davidson in Career T-SQL Tuesday #180 – Good enough is perfect Today’s post is in reply to the invitation post, Josephine Bush asks the question: “How do you get to good... 12 November 2024 4 min read
Joe Celko in Theory and design Data Control Language (aka Security) Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is... 12 November 2024 11 min read
Bravin Wasike in CI/CD Demystifying Continuous Integration vs. Continuous Delivery: Part 2 Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of the series, we... 08 November 2024 27 min read
Simple Talk Editor in Conferences PASS Keynote – Day 3 – Community Keynote Intro Ben Weissman, who is not going to retire after this, comes out to introduce the keynote and tell everyone... 08 November 2024 9 min read
Dennes Torres in Blogs Analyzing Kusto Query History in Fabric We can consume a Kusto database in Fabric from many different places: Notebooks, semantic models, real time dashboards and more.... 07 November 2024 5 min read
Goodness Woke in Other Development Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part II) In the previous article (here) touched on the overview of Frappe and ERPNext and how they’re connected. We also learnt... 07 November 2024 12 min read
Simple Talk Editor in Conferences PASS Keynote – Day 2 – Redgate Time to start! Annabel Bradford (Head of Events at Redgate) comes out on stage. Intro Annabel takes the stage... 07 November 2024 9 min read
Simple Talk Editor PASS Keynote – Day 1 – Microsoft In this blog we will be covering all the news and announcements from the 2024 PASS Data Summit Keynote as... 06 November 2024 10 min read
Robert Sheldon in MongoDB Connecting to MongoDB through Python This article is a bit of a departure from the previous articles in this series. Rather than focusing exclusively on... 05 November 2024 19 min read