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...

I always had suspicion on the  covid statistics provided by China these last few years. Even if the hard line lockdowns were as effective as claimed, then that can mislead....

The term 'Hacker", derived from 'Hack', began at MIT in the 1950's. These students were fascinated how a change in one part of an electrical system affected another. It wasn't...

This is the main...