Blog Archive

Sort by category

2021 November

• Restore database from backup in Docker
• Working with secure FTP in PowerShell

2021 October

• Copy a large table between servers, a couple wrong ways, maybe one right way
• T-SQL Tuesday #143 – Short code examples
• Insert Only New Rows With Nullable Key Columns

2021 June

• Your public "private" info and how to remove (most) of it

2021 May

• Starting a new personal blog!
• PowerShell Common Parameters: PipelineVariable

2021 April

• THROW command is non-terminating across linked servers

2021 March

• Building diagrams using graphviz
• Parsing a pipe delimited file to get a unique list of values
• Building a Free Blog with GitHub Pages in Minutes

2021 February

• "There's no way that will run"
• Use merge to split data into multiple tables

2021 January

• Certifications and learning
• SSMS Keyboard Query Shortcuts
• RAISERROR Cheatsheet
• Clean up your queries and simplify logic with CROSS APPLY

2020 December

• Only update rows that changed? Try using EXISTS and EXCEPT