Tim talks tech
Tag

SQL

#sql

More content

Read more stories on Hashnode

Articles with this tag

SQL to check if an index exists across multiple databases

Feb 20, 20252 min read

Background I recently wrote an EF Core migration which included dropping an index. This index was somewhat unusual, as it didn’t follow our naming...

SQL to check if an index exists across multiple databases

Generating random Latitude & Longitude pairs in the UK via SQL

Jan 7, 20251 min read

I recently needed test data consisting of many locations with latitude and longitude defined. They needed to be within the UK, but also needed to be...

Generating random Latitude & Longitude pairs in the UK via SQL

Find SQL Server views which depend on a specific table column

Nov 15, 20233 min read

If you want to modify a column in an existing SQL Server database, but there is a View using that column, you will find you are unable to modify the...

Find SQL Server views which depend on a specific table column

Worked example - Using regex to refine a SQL script

Mar 29, 20232 min read

I was recently asked to copy some data in a SQL Server database but to exclude records which had the words 'To Delete' in their names. This is a...

Worked example - Using regex to refine a SQL script

Using OUTPUT clauses to check data changes in a SQL script

Mar 6, 20232 min read

A colleague recently showed me the OUTPUT clause in SQL Server, which I wasn't familiar with. It allows you to view the data which has been changed by...

Using OUTPUT clauses to check data changes in a SQL script

Worked example - Reversing the order of lines of text in a file

Feb 9, 20223 min read

How the need to convert a script for creating database views into a script to drop them led me to a useful powershell snippet · I recently wanted to...

Worked example - Reversing the order of lines of text in a file