Fabric: Query a SQL Endpoint from a Notebook
Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can […]
Tous les articles
Query Exercise Answer: Finding Email Addresses
For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users […]
Improving the Performance of UPDATE Statements in SQL Server
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]
The Wide World of GiST Indexes
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets […]
Why Your Azure SQL DB Hyperscale Bill is Higher Than ...
tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like […]
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.
Dynamic T-SQL Script Parameterization Using Python
When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many […]
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
MySQL vs PostgreSQL – String Datatypes
A very common task in creating a database is to store string data. For example, words, paragraph(s) […]
[Video] Office Hours: Waiting for the Hot Tub to Fill
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s […]
T-SQL Has Regex. Don’t Get Too Excited.
Regular expressions are a way of doing complex string searches. They can be really useful, but they have […]
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
AI Tools for Job Seekers – Salary
The post AI Tools for Job Seekers – Salary appeared first on SQLServerCentral.
VEEAM backup et SQL Server… Le piège a con !
L’utilisation par défaut de VEEAM backup combiné à SQL Server détruit vos journaux de transactions… Le saviez-vous ? […]
Query Exercise: Looking for Email Addresses
“They put their password WHERE?!?” Personally identifiable information (PII) is freakin’ everywhere. When companies first start looking to […]
MySQL vs. PostgreSQL: Character Sets and Collations
This is part of a series of posts from Aisha Bukar comparing MySQL and PostgreSQL. You can […]
Free Webcast Tomorrow: Fundamentals of Query Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Distractions
The second I wrote down the idea for a blog posts on Distractions, I knew there had […]
Pitfalls to avoid while feeding events into CrowdStrike
Because it’s important to know when adversaries are scanning the network searching for vulnerabilities, misconfigurations, unpatched systems or […]
Using SQL Server Stored Procedures with the Django ORM
There comes a time when the built-in ORM just isn’t enough. You might have complex queries or performance-critical […]
Data Streaming Databricks in Azure
The post Data Streaming Databricks in Azure appeared first on SQLServerCentral.
What’s Coming in SQL Server 2025, DMV Edition
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things […]
Announcing Fundamentals Week 2025!
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
How I Achieved Scalability in a. Amazon RDS Shared DB ...
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each […]
Free Webcast Tomorrow: Fundamentals of Index Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Deploy DACPAC to Azure SQL Database using Visual Studio
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are […]
INFO.VIEW DAX Functions Usage and Examples
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The State of the Database Landscape in 2025: Insights and ...
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
Scales & Measurements
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
How to Download and Restore AdventureWorks 2019 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
[Video] Office Hours: Philosophical Questions at the Waterfall of the ...
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over […]
Simple Talk on the Road In March
The holidays truly are over, and it is time to hit the road again here at Simple […]
How Shortcuts affect Lakehouse’s Maintenance
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided […]
Free SQL Server Spring Training Live Webcasts Start Next Week.
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
Importing and exporting data in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Understanding the Logical Functions IIF and Choose in SQL Server ...
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]
The Power of Generate_series
The post The Power of Generate_series appeared first on SQLServerCentral.
Implementing Enterprise Data Security in Snowflake: Practical Concepts
As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed […]
Who’s Hiring in the Microsoft Data Platform Community? March 2025 ...
Is your company hiring for a database position as of March 2025? Do you wanna work with the […]
Determining Whether Home Addresses Fall Within a Tornado Polygon Using ...
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]
How to Download and Restore AdventureWorks 2022 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
SQL Server Backup or Restore using Network Share with SSMS
The post SQL Server Backup or Restore using Network Share with SSMS appeared first on SQLServerCentral.
MySQL Shell Basic Configuration Management (Part 3 – Disk I/O ...
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the […]
Office Hours: Unusual Beach Chair Edition
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on […]
Finding Out What Changed in a Cumulative Update
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We […]
Why use Tally Tables in the Fabric Warehouse? Data Engineering ...
Did you know that Edgar F. Codd is considered the father of the relational model that is used […]
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on SQLServerCentral.
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
You’re looking at a wide table with 100-200 columns. Years ago, it started as a “normal” table with […]
Beyond Single-Cloud: A Peek into Multi-Cloud
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology […]
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on […]