How to Turn on Instant File Initialization
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
Understanding Your Value
Data can help you understand the value you bring to a company as a data professional.
Create Size-based Backups for SQL Server 2017
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
PowerShell Tool Time: Controlling Our Tools
The next installment of the Powershell Tool Time series shows you how to manage backup files by
Can you prevent deletes and inserts without a WHERE clause from running?
Erik writes a script to do what it says on the tin.
Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask
Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.
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 Soekarno Hatta CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Soekarno Hatta No.RT. 29, Batu Ampar, Kec. Balikpapan Utara, Kota...
BCA KCP Balikpapan Baru CSTelpon : 0853-73737551
CSTelpon : 0853-737375516 No, Komplek Balikpapan Baru, Blk. D 1-2, Kota Balikpapan, Kalimantan Timur...
BCA KCP KS Tubun TLP/WA 08216366654
Graha Indramas, Gd, Jl. AIP II Jl. K.S. Tubun No.77 Lt.dasar, Daerah Khusus Ibukota...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers