Connecting Streamlit to Upload Data to Snowflake
Introduction We often see and think of reporting as visualizing the already available data from a database and […]
Sites anglophones
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension ...
The post Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension Tables appeared first on SQLServerCentral.
The ROI of SQL Prompt
The post The ROI of SQL Prompt appeared first on SQLServerCentral.
[Video] Office Hours in Osaka, Japan
Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host […]
How to Explain What We Do
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual […]
Why a Self-Join Requires Halloween Protection
The post Why a Self-Join Requires Halloween Protection appeared first on SQLServerCentral.
Save the date for PASS Summit 2025!
The post Save the date for PASS Summit 2025! appeared first on SQLServerCentral.
Are You Underpaid? Let’s Find Out! My Annual Salary Survey ...
Every year, I run a salary survey to help folks have better discussions with their managers about salaries, […]
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 […]
Feed SQL Server logs into SIEM
We sometimes complain that the Security Operations Center (SOC) doesn’t spot cyber-attacks on time, but maybe we’re not […]
Build a Streaming Data Architecture with Apache Kafka and Zookeeper
The post Build a Streaming Data Architecture with Apache Kafka and Zookeeper appeared first on SQLServerCentral.
PASS Summit is going on tour in 2025!
The post PASS Summit is going on tour in 2025! appeared first on SQLServerCentral.
Getting Started with the Data API Builder
Earlier this year I had a PM at Microsoft reach out and ask me what I thought about […]
How to Use Github in SSMS v21
SQL Server Management Studio v21 added native Git support, making it easier to use source control natively inside […]
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 […]
[Video] Office Hours in Zhengzhou, China
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to […]
Aggregate Functions in Power BI including Running Total, Running Average ...
The post Aggregate Functions in Power BI including Running Total, Running Average and Max appeared first on SQLServerCentral.
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with ...
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data […]
A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
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 […]