Azure SQL Database query ideas - finding queries currently running on the DB
And perhaps saving the DB from an unexpected long running query...
Jan 25, 20233 min read39
Command Palette
Search for a command to run...
Series
Azure SQL Database Query Ideas
In the series of posts titled "Azure SQL Database query ideas", I cover some of the topics that I usually encounter as part of my projects.
Azure SQL Database query ideas - Creating new columns in report from row data in table
Thereby improving readability of information
Jan 27, 20233 min read18
Azure Data Studio - new release v1.44
Resolves issues related to Azure AD based user authentication to the database for MacBook users...
Jun 2, 20232 min read13
Azure SQL Database query ideas - table partitions
Knowing more about table partitions in Azure SQL Database...
Jun 6, 20237 min read34
Handling NULL values in join condition
Avoid unexpected filtering out of data in the output of your join condition...
Jul 10, 20233 min read6
Azure SQL Database query ideas - lookup and anti-lookup
Does this data exist in another table?
Oct 18, 20232 min read9