The verical resutls feature is a nice one to have. Though I have seen this in powershell with the invoke sql command(let).  Powershell seemingly decides for you to present in...

I have a feeling people want to test with real data because I suspect the database is not in a normalized state. That is, there is probably a repeat of...

This is not much to go on as the schema of your tables is unknown. I suspect you would benefit from a classic Calendar table which comes with columns for...

If you have Query Store turned on maybe this is what you are looking for?

SELECT distinct top 10 
    qt.query_sql_text
    ,...

For any data you had to delete, anything with personally identifiable information, there are a couple of tools that can generate data for you to use in testing and development.

I've...

Msg 15274, Level 16, State 1, Line 6 Access to the remote server is denied because the current security context is not trusted.

I am getting the same error for...

Good article,  and it does brign up the question of why a database is in full recovery model with no backups being made to keep the log file contained.

This process...

At a high level , reagardless of database platform, a view is simply a stored SQL statement. The statement is encapsulated with a label (what you refer to as the...

I am not sure if it is worth mentioning but the Average function is a Mean average. In certain situations you may want to find a median average, for which...

In Redshift, which is a cousin of PostgreSQL, you can have both a "temporary" table and a "#" table as in Sql Server. Both are temporary tables. Is this the...

I appreciate you taking the time to provide examples to explain triggers.

You did mention "Try to avoid time-consuming operations in the trigger" yet you make use of creating temporary tables...

An issue that can arise with non nullable columns is that if at a later time you realise you need them to be null after all , due to some...

Thanks for sharing. If you use Ola Hallengren's scripts for Jobs related to backups and other maintenance, they do the check internally so you dont need to do this check on...

Much appreciated , thank you for the information.

Thank you for the interesting article. I saw the SQL patterns sought had to do mainly with formatting. Woud any of this cause an issue with a git commit ?

Would...