Blog Archive

Sort by category

2024 August

• Decoding datetime2 columnstore segment range values
• Why aren't old rows dropping from my temporal history table?

2024 July

• Everything's a CASE statement!
• Fun with Unicode characters in SQL Queries

2022 June

• What's new in SQL Server 2022

2022 April

• Handling log files in PowerShell

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