Load JSON Lines with OPENROWSET BULK, keep UTF-8 text intact, quarantine invalid objects, and insert validated typed rows.
Querying External Files With PolyBase
PolyBase and SQL Server external tables expose CSV and Parquet files through schemas, while query plans show whether filters reduce remote work.
Moving Data Out of SQL Server in Open Formats
Move SQL Server data into open formats such as CSV, JSON, and Parquet while preserving types, NULLs, encoding, and readable files.
SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid
Fix Setup Error: File format is not valid in SQL Server 2012 RC0. A reader downloaded the ISO twice; the real culprit was the extraction tool, not the media.
Importing CSV Files Without Surprises
Importing CSV files Without Surprises covers quoted delimiters, UTF-8 encoding, dates, staging tables, and SQL Server BULK INSERT FORMAT = ‘CSV’.
Loading Large Files Fast With BULK INSERT
BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.
SQL SERVER – SQL Code Formatting Tools
SQL Code Formatting matters, and every DBA has a preference; I like uppercase keywords. I ran one script through online formatters and two were worth sharing.