Tim talks tech
Tag

SQL Server

#sql-server

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

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

Using SQL Server to manipulate JSON data structures, including a boolean gotcha

Aug 31, 20234 min read

The problem I was solving I recently did some work to update the structure of some JSON stored in a SQL Server database. The JSON started out as a...

Using SQL Server to manipulate JSON data structures, including a boolean gotcha

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