iMasters

Uma tabela disfarçada vs. várias tabelas de verdade

SQL Server × PostgreSQL – Particionamento 📚 A série completa: ✅ 01 · Particionar não é otimizar. É organizar ✅ 02 · Uma ...

[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...

17 Items to Check Before Upgrading to PostgreSQL 19—The One pg_upgrade --check Misses, and Inspection SQL (Measured on 18.6 and 19beta4)

The release notes for PostgreSQL 19 (scheduled for official release in October 2026) contain a section titled "Migration to ...
learn

CREATE TABLE

Creates a new table in Azure Synapse Analytics. To understand tables and how to use them, see Tables in Azure Synapse Analytics. The name of the new table. To create a local temporary table, precede ...
learn

CREATE TABLE AS SELECT

Microsoft Fabric Data Warehouse is an enterprise scale relational warehouse on a data lake foundation, with a future-ready architecture, built-in AI, and new features. If you're new to data ...
aws.amazon

AWS Transform を使用した SQL Server データベースから Aurora PostgreSQL へのモダナイズ

このブログは、2026 年 8 月 3 日に公開された「 Modernize SQL Server databases to Aurora PostgreSQL using AWS Transform 」を翻訳したものです。 はじめに SQL Server データベースの Aurora PostgreSQL へのモダナイ ...
InfoWorld

The revenge of SQL: How a 50-year-old language reinvents itself

Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...
habr

SQL для аналитика в ритейле: разбор 4 задач с данными (от простого к сложному)

Пример вывода по данным: 3 февраля резкое падение выручки (-35% к предыдущему дню) возможно, выходной или проблемы с поставками. Средний чек ...
KDnuggets

Automate SQL Workflows with n8n: Scheduled Database Reports via Email

Data teams across organizations face the same recurring challenge: stakeholders require regular reports, but manual SQL reporting consumes valuable time that could be spent on analysis. The process ...
Hacker

Memory-Optimized Tables in SQL Server: When, Why and How to Implement Them

Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...
builtin

NOLOCK in SQL Server Explained

CREATE TABLE Employee ( EmployeeID INT, EmployeeName VARCHAR(100) ); INSERT INTO Employee (EmployeeID, EmployeeName) VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie ...