A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
simple-talk.com
Unmasking SQL Server Dynamic Data Masking – Part 2 – ...
This is the second part of a series on SQL Server Dynamic Data masking. The first part […]
Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s […]
SQL Server 2022: Capture SQL Anti-Patterns
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]
T-SQL Gap-Filling Challenge
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
Unmasking SQL Server Dynamic Data Masking, Part 1, Intro
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Self Review: Practical Graph Structures in SQL Server and Azure ...
I just finished writing this book a few weeks ago, and as I read it, I thought […]
Optimizing MySQL: Adding Data to Tables
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
Changing log growth strategy in SQL Server 2022
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
Uncovering the mysteries of PostgreSQL (auto) vacuum
Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered […]
Importing data into a MySQL database using LOAD DATA
Database and development teams often load data from plain text files into their MySQL databases. The files […]
PostgreSQL Basics: Essential psql Tips and Tricks
Having access to the psql command-line tool is essential for any developers or DBAs that are actively […]
PostgreSQL Basics: Getting started with psql
PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation […]