The DATA drive filled up with thousands of audittrace .trc files. Here is why SQL Server writes audit trace files there and how to stop them.
PowerShell – Tip: How to Format PowerShell Script Output?
Raw PowerShell output is hard to read. Here are three common ways to format PowerShell script output, starting with Format-Table, so results make sense.
SQL SERVER – Installation Error – File Format is Not Valid
At the license agreement step, SQL Server setup stopped with ‘File format is not valid’. Here is what caused this Installation Error for my client and the fix.
Extracting the Folder and File Name From a Full Path in T-SQL
Split a path at the last backslash and handle the odd inputs. Bare names, empty values, trailing spaces and NULL all behave.
BULK INSERT With FORMAT CSV and FIELDQUOTE for Quoted Files
A comma inside a quoted name can break a CSV load without any error. Here is how FIELDQUOTE fixes it, and how to validate what arrives.
Reading a JSON Lines File Into a Table With OPENROWSET
Load JSON Lines with OPENROWSET BULK, keep UTF-8 text intact, quarantine invalid objects, and insert validated typed rows.
Open Table Formats: Delta Lake and Apache Iceberg Explained
Open Table Formats turn a folder of Parquet files into a real table with transactions, history and safe schema changes. This post shows how Delta Lake and Apache Iceberg do it with a metadata layer, how a commit stays atomic, and what time travel means.