Build Parquet exports from SQL Server 2022 with PolyBase CETAS, S3-compatible storage, and checks for rows, types, and files.
SQL SERVER – Mismatch Between sys.database_files and sys.master_files For TempDB Database
I would share my knowledge and findings of a situation where there was a mismatch between sys.database_files and sys.master_files for the TempDB database!
SQL SERVER – PRINT Statement and Format of Date Datatype
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
How to Move SQL Server MDF and LDF Files? – Interview Question of the Week #189
How do you move SQL Server MDF and LDF files? Detach and attach is the old way, so here is the step-by-step method I use for my clients today.
SQL SERVER – Rename Physical Database File Name for Any Database
Can you rename the physical file of a database? Yes, and following my post on logical names, here are the steps to rename physical database files.
SQL SERVER – Rename Logical Database File Name for Any Database
After a restore, the logical file name broke my client’s naming rules. Here is how to rename logical database file names in a few quick steps.