Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises […]
Sites anglophones
[Video] Office Hours: I Feel Like an Amateur Edition
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling […]
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
The post Troubleshoot SQL Server Always On Availability Groups with SQL LogScout appeared first on SQLServerCentral.
Empowering Lakehouse Users – Data Engineering with Fabric
Microsoft Fabric allows the developers to create delta tables in the Lakehouse. However, the automation of copying, updating, […]
The Future of DBAs: History Rhymes
Eitan Blumin recently wrote a post about the future of the DBA career in which he talked about […]
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage […]
Exploring MVCC and InnoDB’s Multi-Versioning Technique
In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing […]
How Big Data Supports Gen AI
Big data processing plays a pivotal role in the development and efficiency of Generative Artificial Intelligence (AI) systems. […]
Optimizing MySQL: Deleting Data
In the previous parts of these MySQL optimization series, we told you how query optimization works on […]
SQL Replication Error – the row was not found at ...
The post SQL Replication Error – the row was not found at the Subscriber when applying the replicated […]
Managing SQL Agent in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
[Video] Office Hours: Answers for Your Database Questions
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
Getting Data Out of an Audit Table: Answers & Discussion
In last week’s post, I gave you a trigger that populated a history table with all changes to […]
Combining Silver Tables into a Model – Data Engineering with ...
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze […]
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age […]
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for […]
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, […]
Read Data Stored in a Lake Database using Azure Synapse ...
The post Read Data Stored in a Lake Database using Azure Synapse Analytics appeared first on SQLServerCentral.
Using Machine Learning Pipeline Execution Activity in Azure Data Factory
Introduction The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to […]
Identifying Customer Buying Pattern in Power BI – Part 2
In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product […]
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: […]
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column […]
SQL Server Filtered Index Essentials Guide
The post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […]
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined […]
[Video] Office Hours: Ask Me Anything About Azure and Microsoft ...
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go […]
Ingest and Retrieve data from an ADX Cluster Using Python
Introduction Azure Data Explorer (ADX) helps to analyze high volumes of data in near real-time. The Azure Machine […]
The Curious Case of… missing log information
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
Who’s Hiring in the Microsoft Data Platform Community? May 2024 ...
Is your company hiring for a database position as of May 2024? Do you wanna work with the […]
Database Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Managing Failed Pipeline Runs in Azure Data Factory
The post Managing Failed Pipeline Runs in Azure Data Factory appeared first on SQLServerCentral.
Query Exercise: Who’s Changing the Table?
For this week’s Query Exercise, your challenge is to find out who keeps messing up the rows in […]
It’s Time For Our Annual Anniversary Sale!
I first registered BrentOzar.com way back in May 2001. Over the years, some things in databases have changed […]
Metadata Driven Pipelines – Data Engineering with Fabric
What is a metadata driven pipeline? Wikipedia defines metadata as “data that provides information about other data.” As […]
PySpark Secrets to use with Fabric
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […]
Join Me at the PASS Data Community Summit in November!
On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and […]
Updating Documents in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Learning Spark SQL String Functions with Explanations and Code Examples
The post Learning Spark SQL String Functions with Explanations and Code Examples appeared first on SQLServerCentral.
Exporting and Importing Registered Servers in SSMS
Many SQL Server Management Studio (SSMS) users connect to the same SQL Server instances over and over. In […]
Database technology learning resources
Before I started as the editor of Simple Talk, I worked on SQL Server. Only. (Ok, I […]
Building RESTful APIs in Rust With Actix and Diesel
There are many packages and tools that you can use to facilitate your API development with Rust. […]
What happens when we drop a column on a SQL ...
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […]
[Video] Database Answers in Hong Kong
As my time in Hong Kong came to an end, I sat inside on a foggy morning and […]
Working with IAsyncEnumerable in C#
IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of […]
Troubleshooting Mysterious Blocking Caused By sp_getapplock
I’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. […]
It’s almost time for Fundamentals Week! Have you signed up ...
The Monday after next, I’ll be getting together with dozens of smart people who are a lot like […]
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – […]
Unlocking Power with Updatable Views in SQL Server
Relational database management systems (RDBMS) rely on Structured Query Language (SQL) as their foundation for data management and […]
Kubernetes For Complete Beginners
The post Kubernetes For Complete Beginners appeared first on SQLServerCentral.