Fabric Databases Connection Secrets
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
simple-talk.com
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
SQL Server 2022 CU Updates and Error Code 0x851A0043
I’ve been working in the Azure space for the last few years and less with full server […]
MySQL Index Overviews: Descending B-Tree Indexes
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless […]
SQL Server BIT_COUNT and an Alternative
I was editing an article the other day that uses the BIT_COUNT function that was added to […]
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: […]
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of […]
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, ...
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude […]
SQL Endpoint Secrets you need to know
Recently I had a severe problem with SQL endpoints and I was required to build a quick […]
Creating Time Series Collections in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Weekly Blogging
I spent a few weeks away from the office in early January, just like last year, mostly […]
Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Nostalgic Memory Loss
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]
Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]
Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
I Wrote a Book on How You Broke Your Database ...
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]
Customizing the Export and import of Parquet Files in SQL ...
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]
A Use Case for Memory-Optimized Tempdb Metadata
I recently had an interesting production SQL Server issue that turned out to be very easy to […]
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways […]
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]
Simple Talk 2024 Year in Review
Happy New Year to all of the Simple talk readers! What a year this has been. I […]
Introduction to MySQL Shell and Basic Configuration Management (Part 1)
The database is an important part of any application and setting it up correctly is key to […]
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database […]
When Should You Employ Snowflake Materialized Views?
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place […]
TSQL Tuesday #181 – The first SQL Server Feature that ...
First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you […]
A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
T-SQL Tuesday #181: Query Store and its evolution
Query Store. This is my choice in relation to “What feature release made you say WOW!”, the […]
Introduction to Oracle Database for Database Professionals
Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used […]
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 […]
Love Your Conference Sponsors
You probably already realize this, but I work for a company that sponsors conferences. As the editor […]
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 […]
Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Essential Strategies for Optimizing Snowflake Performance and Reducing Costs
In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data […]
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 […]
Breaking Down Ignite: A Pragmatic Look at the Conference’s Best ...
The amount of news brought by Ignite is huge. I was not expecting to find so many […]
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 […]
MySQL vs PostgreSQL: Numeric Datatype Comparison
When you think of how to store data in a database, you think of data types. A […]
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 […]
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 […]
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
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 […]
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part ...
In the previous article (here) touched on the overview of Frappe and ERPNext and how they’re connected. […]
PASS Keynote – Day 2 – Redgate
Time to start! Annabel Graham (Head of events at Redgate) comes out on stage Intro Annabel […]
Connecting to MongoDB through Python
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]