CSV
Loading CSV Into SQL Server With BULK INSERT Correctly
Load a CSV into SQL Server with BULK INSERT: FORMAT CSV for quoted fields, FIRSTROW, UTF-8, error files, server paths and permissions.
7 min read
Library
Everything you need to level up your coding skills.
CSV
Exporting SQL Server Results to CSV With bcp and sqlcmd
How to export a SQL Server query to a real CSV with bcp: add the header row, quote fields yourself, fix dates and NULLs, and pick the right encoding.
10 min read
JSON
Building JSON From Query Results With FOR JSON in SQL Server
Turn SQL Server rows into JSON with FOR JSON PATH and AUTO, nest child rows, control nulls and wrappers, and avoid the double-encoding trap with JSON_QUERY.
7 min read
JSON
Reading JSON in SQL Server With OPENJSON and a Schema
How OPENJSON turns a JSON array or object into rows in SQL Server, with the default key, value and type columns, the WITH clause, nested arrays and the traps.
7 min read
JSONGuide
JSON in SQL Server Oracle Snowflake and BigQuery Compared
How SQL Server, Oracle, Snowflake and BigQuery store, read, unpack, build and index JSON, side by side, with the null, type and size traps in each.
19 min read
Excel
Why an Exported Excel Date Shows as a Number and the Fix
An exported date shows as 45292 because Excel stores dates as numbers and the cell has no date format. See the cause, the code fix and a file repair.
7 min read
Excel
Making Excel Exports Open Cleanly Every Time on Any PC
Stop repair prompts, garbled accents and wrong columns when exports open in Excel: legal characters, sheet names, time zones, NaN, BOM and separators.
7 min read
Excel
Emailing a Scheduled Excel Report From a Database Job
Build a job that queries a database, writes an Excel file and emails it on a schedule with smtplib and cron, with safe credentials and failure alerts.
8 min read
Excel
Freezing Panes Filters and Column Widths From Code
Freeze the header row, add filter buttons and set column widths from Python with openpyxl and XlsxWriter, including an auto-width helper and print settings.
7 min read
Excel
Adding Formulas and Number Formats From Python Code
Write Excel formulas and number formats from Python with openpyxl and XlsxWriter: English syntax, cached values, table references, percent and date codes.
7 min read
Excel
Building a Multi Sheet Excel Report From SQL Queries
Build one Excel workbook from several SQL queries: a summary sheet, a sheet per region, formulas that point across sheets and an index with working links.
7 min read
Excel
Exporting MySQL Data to Excel With a Python Script
Export a MySQL query to a clean XLSX with PyMySQL and pandas, handling DECIMAL, zero dates, tinyint flags and utf8mb4, and compare it with Workbench.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.