I liked the article and made me think of the acronym of KISS (Keep It Simple and Standard).

https://ola.hallengren.com/sql-server-backup.html

Gentlemen's agreement is an arrangement or understanding which is based upon the trust of both or all parties, rather than being legally binding.  "a gentleman's agreement by the grain growers...

• This reply was modified 3 years, 2 months ago by  Peter Heller.
• This reply was modified 3 years, 2 months ago by  Peter Heller.
• This reply was modified 3 years, 2 months ago by  Peter Heller.

The question is if you need data masking, why not use SQL Server data masking by keeping it simple and standard versus Gallium Data which is non-enforceable since it is...

• This reply was modified 3 years, 2 months ago by  Peter Heller.

SSMS is the winner since you can access Azure Data Studio from SSMS as an external tool.  Azure Data Studio lacks the full blown bells and whistles of the Redgate...

There is such a high expectation of the DBAs in a heterogenous database environment which now entails NOSQL.  At best, they a jack of all databases and probably a master...

The go to has been suggested to try to avoid at all costs for the past 35 plus years.

Thanks for an interesting article.

This stairway is excellent. What would be an interesting extension to the series is the inclusion of SSIS and SSRS configuration for local machines.  It is an alternative way without...

It appears that Microsoft is moving towards an open cross platform environment.  A variation on WORM technology where WORM is Write once and run on many OS.  It will take...

• This reply was modified 5 years, 7 months ago by  Peter Heller.

How about adding the month(SomeDateTime) for the sorting correctly without affecting the group by?

select [Month] = datename(mm, SomeDateTime)
     , Amount  = sum(SomeAmount)
from...

This comes under the umbrella of disruptive technology.  An example of an industry that the article left out  was driverless vehicles. Uber and long distance trucking will eliminate millions of...