What Is SQLPSX?
SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.
Batch Mode For Row Store: What Does It Help With?
Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements.
T-SQL Decommenter Part II
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
SOX and Database Administration – Part 3
Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.
The Linux CoC
Some controversy over a new Code of Conduct has risen. Steve thinks we just need treat each other well.
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
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
BCA KCP Kramat Jaya Baru Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota...
BCA KCP Pondok Bambu Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec....
BCA KCP Cempaka Putih Raya Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers