Blog Archive
Sort by date
Other
T-SQL
- Jun 2022 - What's new in SQL Server 2022
- 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
Misc
Blogging
Quick-Post
- Mar 2021 - Building diagrams using graphviz
- Mar 2021 - Parsing a pipe delimited file to get a unique list of values
PowerShell
- Apr 2022 - Handling log files in PowerShell
- Nov 2021 - Working with secure FTP in PowerShell
- May 2021 - PowerShell Common Parameters: PipelineVariable