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 […]
Sites anglophones
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 […]
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 […]
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) […]
Live webinar – Prioritizing security: Essential strategies for IT leaders
The post Live webinar – Prioritizing security: Essential strategies for IT leaders appeared first on SQLServerCentral.
Keeping up with the 2024 PASS Summit
In this post, I want to share a few places where you can keep up with what […]
AI and Databases
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
Our Annual Black Friday Sale Starts Now!
The wait is over: my annual Black Friday sale has officially launched! If you’ve been eyeing any of […]
A Guide to SQL Security in Django
The web apps we see today handle a lot of sensitive user data and this makes security of […]
Optimize SQL LIKE Wildcard Searches
The post Optimize SQL LIKE Wildcard Searches appeared first on SQLServerCentral.
Black Friday Super Sale!
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the […]
[Video] Office Hours: Let’s Have a Drink
I was making myself a drink to film Office Hours and I realized I should just film it […]
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 […]
Launch Day Bonus: Free Stuff on Friday
Our annual Black Friday sale launches this Friday and runs all month. For those of you who are […]
Virtualizing AWS 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 […]
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
NEW YORK, October 29, 2024 – Timescale, the leading PostgreSQL database platform, today expanded its PostgreSQL AI offerings […]
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
Who Actually Buys BrentOzar.com Training?
So you’re thinking about picking up some of my training & online services during our annual Black Friday […]
The Countdown is On: Our Black Friday Sale Starts This ...
All year long, when you’re watching my Office Hours sessions, you keep hearing me say, “That topic is […]