SQL Server and Oracle Transparent Data Encryption Differences and Similarities
In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
How to visualize Python charts in Power BI part 3
In Part 3, we look at how to use Python to create more charts for Power BI.
Guide to Build Graph Node and Edge Tables with Azure Data Studio
Learn how to build graph node and edge tables using Azure Data Studio in this step-by-step guide.
The Lock Escalation Threshold – Part 1
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.
Who Are You?
I was sitting here thinking about the editorial when Kathi Kellenberger came to mind. She would frequently write about her favorite show, Star Trek. I too have been a fan of Star Trek since I was very young. However, my favorite show is a little more obscure and not as many people have seen it, […]
How to Use PowerShell to Set Secure SA Passwords in Bulk
Learn how you can bulk set passwords using PowerShell for all your instances.
Paying It Forward on the Internet
Helping others has been good for Steve's career and he encourages you to do it as well.
Managing Static Data in Flyway Database Development
If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.
SQL WHERE Tutorial
In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara mengatasi saldo tertahan/pending di bank permata
Cara Mengatasi transaksi pending di PermataBank (saldo berkurang namun transfer/pembayaran belum berhasil) dapat dilakukan...
BCA KCP Batu Ceper CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan...
BCA KCU TANGERANG CITY CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers