Blog Archive

Sort by date

T-SQL

• Oct 2021 - Copy a large table between servers, a couple wrong ways, maybe one right way
• Oct 2021 - Insert Only New Rows With Nullable Key Columns
• Apr 2021 - THROW command is non-terminating across linked servers
• Feb 2021 - "There's no way that will run"
• Feb 2021 - Use merge to split data into multiple tables
• Jan 2021 - RAISERROR Cheatsheet
• Jan 2021 - Clean up your queries and simplify logic with CROSS APPLY
• Dec 2020 - Only update rows that changed? Try using EXISTS and EXCEPT

SSMS

• Jan 2021 - SSMS Keyboard Query Shortcuts

Misc

• Jan 2021 - Certifications and learning

Blogging

• Mar 2021 - Building a Free Blog with GitHub Pages in Minutes

Quick-Post

• Mar 2021 - Building diagrams using graphviz
• Mar 2021 - Parsing a pipe delimited file to get a unique list of values

PowerShell

• Nov 2021 - Working with secure FTP in PowerShell
• May 2021 - PowerShell Common Parameters: PipelineVariable

T-SQL-Tuesday

• Oct 2021 - T-SQL Tuesday #143 – Short code examples

Docker

• Nov 2021 - Restore database from backup in Docker

Personal

• May 2021 - Starting a new personal blog!
• Jun 2021 - Your public "private" info and how to remove (most) of it