Making AI Talk to Your Database: AI-Powered Database Queries Made ...
Nowadays, artificial intelligence is everywhere. It’s so prevalent that even universities are implementing it into their curriculums. […]
simple-talk.com
MySQL vs PostgreSQL JSON Data Types: Key Differences & Which ...
In this article, the latest in the MySQL vs PostgreSQL series, we’ll compare how they each handle […]
15 Practical Tips for Securing SQL Server
Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks […]
How to Monitor and Optimize Batched Deletion Processes in SQL ...
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, […]
How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles ...
Since this article was written, Oracle AI Database 26ai has been released. Oracle Database 23ai added 300+ […]
5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, […]
How to Build an AI-Powered T-SQL Assistant with Python & ...
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, […]
Memories of Andrew Clarke, by Simon Galbraith
Simon Galbraith is the co-founder of Redgate and one of the creators of Simple Talk. Here, he […]
A Tribute to Andrew Clarke (a.k.a. Phil Factor)
We are deeply saddened to share the news that Andrew Clarke, better known to Simple-Talk readers as […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world […]
MySQL Shell Basic Configuration Management (Part 6 – Backups and ...
In this final part of the MySQL Shell Configuration Management series, we explore how to automate performance […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
PostgreSQL is an open-source relational database management system valued for its power, standards-compliance, and extensibility. Whether you’re […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike […]
MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL ...
Welcome back to our comprehensive guide on optimizing MySQL performance using MySQL Shell. So far in this […]
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL ...
A number of client tools are available for working with Azure Database for PostgreSQL flexible server. With […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
How to Increase SQL Server Column Width Without IO (Input/Output) ...
One of the most hassle-prone changes that can be made in a SQL Server database is to […]
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous ...
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; […]
How to use pgAdmin with Azure Database for PostgreSQL flexible ...
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is […]
How to Use the New PRODUCT() Function in SQL Server ...
With each version of SQL Server, there are always a few new features introduced that we applaud […]
Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]
How to Script Dimensions with data build tool (dbt) Macros
In previous articles we introduced the popular data engineering tool dbt (data build tool). We showed you […]
Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: ...
Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the […]
Common SQL Server Problems: Network Related or Instance Specific Error ...
This is the first in a series of articles meant to provide practical solutions to common issues. […]
13 Things I wish I knew about Power Query (when ...
When I first started with Power Query, it was in Excel, through the Power Pivot feature. I […]
Unlocking Infor CloudSuite data: Making the most of it with ...
In my experiences building end-to-end analytics solutions, I often need to connect to a variety of different […]
Columnstore Index Improvements in SQL Server 2025
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has […]
State Transition Constraints
About two decades ago, I introduced the concept of transition constraints to show Data Validation in a […]
Oracle ASM: Monitoring and Managing (Part 2)
In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a […]
Replacing a Column in a Large Active SQL Server Table
In a previous post I showed how to use a batching strategy to remove large amounts of […]
Getting started with Azure Database for PostgreSQL Flexible Server
Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a […]
DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part ...
Understanding the Divide — DevOps vs. SRE Explained The conversation around DevOps versus Site Reliability Engineering (SRE) […]
Replicating MySQL databases in Docker Containers
In my prior article, “Running a relational database with Docker”, I showed how to spin up a […]
Load Data into Snowflake Using Native Snowflake Connector for Python: ...
In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with […]
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
TempDB Resource Governor Space Controls in SQL Server 2025
TempDB is a system database in SQL Server that manages temporary objects for all databases on a […]
The good, the bad, and the awful taste muscle memory ...
When I was traveling a while back, I grabbed a small white metal tube out of my […]
Sponsoring Scenic City Summit
For the second year in a row, Simple Talk will sponsor Scenic City Summit in Chattanooga, TN, […]
Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation
PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group […]
Oracle ASM: A Simple Solution or Another Complexity? (part 1)
For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure […]
MySQL vs. PostgreSQL: Date and Time Data Types
Date and time data types are important because they help track and manage time-based information in databases. […]
Moving from SQL to MongoDB’s MQL
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Using Parameters with DAX in Report Builder
This is something we expect to be simple, but it has a lot of secrets. Using parameters […]
Running a MySQL database in a Docker Container
Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting […]
DISTINCT and UNION: What happens when you use them together?
When I was perusing my LinkedIn feed the other day, I came across this thread about using […]
Data Encoding Schemes
You probably noticed that when you get a bill or bank statement, it uses the current modern […]
SQL Server Developer Standard Edition: A Gift to Developers!
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]