Making Temporal Databases Work, Part 3: Saving Data
The post Making Temporal Databases Work, Part 3: Saving Data appeared first on SQLServerCentral.
Sites anglophones
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 […]
Audit SQL Server Extended Stored Procedures Usage
The post Audit SQL Server Extended Stored Procedures Usage appeared first on SQLServerCentral.
Leveraging SQL Transaction Control in Python Applications
Transactions are the unsung heroes of data consistency/integrity in database operations. For us Python devs working with databases, […]
Microsoft at the PASS Data Community Summit 2024
Microsoft is once again excited to the be top sponsor at the PASS Data Community Summit in 2024 […]
[Video] Office Hours: Salem Witchcraft Edition
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I […]
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and […]
Using a Service Account in Microsoft Fabric
The post Using a Service Account in Microsoft Fabric appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in […]
What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted […]
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction […]