Exporting VARCHAR MAX and NVARCHAR MAX to CSV
Learn how to deal with commas and new lines in CSV files that are destined for Excel. Use the REPLACE command to clean up your outfiles.
Read articleRudy Rodarte · Technical writing
Notes from the data platform.
Practical notes on databases and the systems around them. SQL Server is my deepest area of experience; my current work also spans PostgreSQL, ClickHouse, and data warehousing.
Explore the articlesBrowse by subject
Topics
01
SQL Server & Windows
Database administration, T-SQL, PowerShell, and the systems around them.
02PostgreSQL
Queries, administration, and practical notes from daily work.
03ClickHouse & Data Warehousing
A home for writing on analytics and modern data platforms.
04Other Topics
MongoDB and useful tools that do not fit neatly elsewhere.
From the archive
Latest articles
When Excel will not convert a date to a date
When importing data from CSVs into Excel, some dates are not recognized as dates. Learn how to convert these dates to real Excel dates.
Read articleDisplay Virtual Machine IPs using PowerShell
Find the IP addresses of running Hyper-V virtual machines from a single PowerShell command.
Read articleDisplay function definitions in PSQL
Display a PostgreSQL function definition from a psql prompt with pg_get_functiondef.
Read articleGet current PostgreSQL Sessions
Query pg_stat_activity to list active PostgreSQL sessions and connection details.
Read articleList all MongoDB Users
List MongoDB users, their databases, and assigned roles from the shell.
Read articleUseful SQL Server Date Formats
Here are a few date formats that I've found useful over the years.
Read articleFinding the SSRS Log File
Discover how to find and examine the SQL Server Reporting Services log file.
Read articleT-SQL Tuesday March 2019 – Dipping into the Cookie Jar
This month's TSQL Tuesday is hosted by Shane O’Neill (B/T). The challenge this month is to write about “Dipping back into the cookie jar” or using the memories of a past challenge or…
Read articleT-SQL Tuesday July 2018 – Working with Dates
This snippet is so nice, I'm posting it again! I've utilized the script below at least once a week, for either reports, or working with large data sets.
Read article