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

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

Louis Davidson in Conferences

Keeping up with the 2024 PASS Summit

In this post, I want to share a few places where you can keep up with what is going on...

02 November 2024 3 min read

Phil Factor in AI

AI and Databases

Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s also an over-simplification....

01 November 2024 12 min read

Dennes Torres in Blogs

T-SQL Notebooks: Manage Views Source Control and more

T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this...

31 October 2024 3 min read

Joe Celko in Theory and design

Transactions

By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required...

29 October 2024 10 min read

Lukas Vileikis in MySQL

MySQL Index Overviews: FULLTEXT B-Tree Indexes

If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve....

25 October 2024 17 min read

Dennes Torres in Blogs

Shortcuts, Capacities and Costs : Some Considerations

Edit on 25/10/2024: According to some official documentations, there is an inaccuracy on this blog. The costs involved on data...

23 October 2024 3 min read

Koen Verbeeck in Azure

How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform

In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing...

22 October 2024 27 min read

Ben Johnston in Blogs

Writing an Efficient Query

SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for...

19 October 2024 20 min read

Register for Simple Talk

Articles

Reading and Writing Parquet Files in SQL Server

MySQL vs PostgreSQL: Numeric Datatype Comparison

KQL: The top of a group in an easy way

T-SQL Tuesday #180 – Good enough is perfect

Data Control Language (aka Security)

Demystifying Continuous Integration vs. Continuous Delivery: Part 2

PASS Keynote – Day 3 – Community Keynote

Analyzing Kusto Query History in Fabric

Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part II)

PASS Keynote – Day 2 – Redgate

PASS Keynote – Day 1 – Microsoft

Connecting to MongoDB through Python

Keeping up with the 2024 PASS Summit

AI and Databases

T-SQL Notebooks: Manage Views Source Control and more

Transactions

MySQL Index Overviews: FULLTEXT B-Tree Indexes

Shortcuts, Capacities and Costs : Some Considerations

How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform

Writing an Efficient Query