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
Alamat Kantor BCA KCU ASIA Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan...
BCA KCP Plaza Medan Fair CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G, Sekip, Kec....
BCA KCP Sabang Telpon/wa.085373737699
BCA KCP Sabang Telpon/wa.085373737699.Jl. H. Agus Salim No.57 B, Kb. Sirih, Kec. Menteng, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers