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

A group of people standing together Description automatically generated

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