A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
Sites anglophones
How to Send Email with SQL Server’s sp_send_dbmail
So you’re writing T-SQL code and you’ve decided that you want to send emails to customers, employees, or […]
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 […]
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be ...
Every SQL Server developer has heard it: « Don’t use NOLOCK in production! » But this common rule isn’t as […]
SQLBits is Coming Back to London in June 2025!
I used to feel bad saying that any one conference is “my favorite” because I worried that other […]
Calculate a Moving Average with T-SQL Windowing Functions
The post Calculate a Moving Average with T-SQL Windowing Functions appeared first on SQLServerCentral.
JSON in PostgreSQL
Overview In this article, we will learn about JSON datatypes, functions, operators in PostgreSQL and how to use […]
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 […]
[Video] Office Hours at the Petit Ermitage in LA
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your […]
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 […]
Who’s Hiring in the Microsoft Data Platform Community? December 2024 ...
Is your company hiring for a database position as of December 2024? Do you wanna work with the […]
Announcing the Holiday Sale
Our annual Black Friday sale is over, but we’ve got a simple sale for folks who couldn’t get […]
An introduction to Terraform
My first exposure to Terraform was when I started to work with data in the AWS cloud. As […]
SQL IS NULL and SQL IS NOT NULL Examples
The post SQL IS NULL and SQL IS NOT NULL Examples appeared first on SQLServerCentral.
Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
[Video] Office Hours: Car in the Dining Room Edition
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, […]
Execute Stored Procedures in the Microsoft GraphQL API
The post Execute Stored Procedures in the Microsoft GraphQL API appeared first on SQLServerCentral.
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric
Many companies have technical debt which consists of applications and/or databases that are no longer in support or […]
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Making Your Learning Plan for 2025
This week is my annual Black Friday sale, and over and over, folks buy the Fundamentals & Mastering […]
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 […]
This Is It! Our Annual Black Friday Sale on SQL ...
You’ve been eyeing my training classes all year long, biting your lip with lustful hunger, wishing you could […]
A First Look at SSMS 21
This isn’t really a first look, per se. I’ve seen Erin Stellato present on this a few times […]
[Video] Office Hours: Ask Me Database Questions
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I […]
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 […]
Announcing SQL Server 2025
This week we have announced SQL Server 2025 now available in private preview. SQL Server 2025 is an […]
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 […]
Updated Training Modules for SQL Server 2019 & 2022
At the PASS Summit this month, I presented a 1-day workshop called T-SQL Tuning for SQL Server 2019 […]
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re […]
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 […]
What’s New in SQL Server 2025
Today at Microsoft Ignite, Microsoft announced SQL Server 2025. The biggest new features focus on AI and bringing […]
SQL ConstantCare® Population Report: Fall 2024
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. […]
Help Me Help You.
In my PollGab room where y’all can ask questions, Chocolate Thunder wrote: I do genuinely wish that I […]
Microsoft SQL announcements at PASS Data Community Summit 2024
It was an amazing week at the PASS Data Community Summit 2024 in Seattle, Washington. Microsoft made several […]
How to Develop Custom T-SQL Code Snippets in Azure Data ...
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In […]
Explore Pandas in Python to Analyze and Manipulate Tabular Data
The post Explore Pandas in Python to Analyze and Manipulate Tabular Data appeared first on SQLServerCentral.
MySQL vs PostgreSQL: Numeric Datatype Comparison
When you think of how to store data in a database, you think of data types. A […]
Making Temporal Databases Work, Part 3: Saving Data
The post Making Temporal Databases Work, Part 3: Saving Data appeared first on SQLServerCentral.
Office Hours: Guess the Theme Edition
There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take […]
SSMS v21: Dark Mode, Git, Vertical Tabs, and More
SQL Server Management Studio v21 Preview 1 is out and let’s give it a quick whirl. It’s installed with […]
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 […]
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Representational State Transfer (REST) is a software architectural design that has been employed throughout the software industry to create stateless web […]
Relationships with Microsoft Fabric GraphQL API
The post Relationships with Microsoft Fabric GraphQL API appeared first on SQLServerCentral.
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 […]
Copilot in SSMS is Kinda Like IE in SSMS
You are not ready for how weird my take is. Last week at the PASS Summit conference in […]
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
[Video] Office Hours: SQL Server Questions and Answers
That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out […]
A Tidy Database is a Fast Database: Why Index Management ...
Everyone knows that indexes make databases faster, well not everyone as I once came across a team that […]