Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
Archives du mois : novembre 2024
[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 […]
Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground ...
The increasing adoption of AI technologies is presenting new challenges for our customers’ data estate and applications. Most […]
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 […]
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 […]
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 […]
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 […]
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 […]
Office Hours in the Valley of Fire
I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and […]
Step by step guide to setup PostgreSQL on Docker
Introduction PostgreSQL is a powerful open-source relational database management system with robust features for handling large datasets and […]
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 […]
Data Chouette – 1 an déjà !
1 – Genèse Cela fait presque un an que nous avons lancé la chaîne Data Chouette ! […]
Data Chouette
Chaine dédiée à la présentation de services Data. Vous êtes passionné par les données et vous trouvez […]
Save money on Microsoft SQL Server licensing with Microsoft Azure ...
As customers execute their multi-cloud strategy, the deployment of SQL Server across multiple cloud providers becomes a critical […]
Office Hours at the PASS Summit in Seattle
I’m in Seattle this week for the PASS Data Community Summit. Before the pre-conference sessions started, I sat […]
What’s In Your Development Database? The Answer: Production Data
The post What’s In Your Development Database? The Answer: Production Data appeared first on SQLServerCentral.
The SQLskills Black Friday Super Sale!
The post The SQLskills Black Friday Super Sale! appeared first on SQLServerCentral.
Connecting to MongoDB through Python
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Who’s Hiring in the Microsoft Data Platform Community? November 2024 ...
Is your company hiring for a database position as of November 2024? Do you wanna work with the […]
Watch Me Stream at the PASS Summit for Free!
This week at the PASS Data Community Summit in Seattle, 15 sessions are getting streamed online for free! […]
Your Personal ChatGPT Tutorial
Introduction We are currently in a golden age of AI, with the emergence of large language models (LLMs) […]