For me

• SSMS = Server administration, adhoc query and manual deployment interface
• Azure Data Studio = Run books and saved diagnostics procedures
• PgAdmin, SQL Server Developer, MySQL Workbench = PostgreSQL,...

Shameless plug and praise here for SQLServerCentral… The majority of my coding standards and practices are derived from reading and applying the concepts from the content of SQLServerCentral articles and...

Here states different:

…

Your approach seems to be the faster solution here. I did some timeit tests to confirm. Excellent approach and solution! I wonder if this flip...

Thanks for the question, learned something new today.  As always, and to the bane of cat lovers, there are many ways to skin a cat... I didn't know about the...

My standard design is that the R part of CRUD is done via views and the CUD part of CRUD is done through stored procedures. (in case CRUD is unfamiliar...

I get the sentiment about personal power, though on an initiative like GDPR and CCPA compliance. "Institutional Power" is going to be required. It doesn't matter how much passion you...

Version control is one of those basics that if you don't know how it works, how to leverage it, stop any current learning you're doing and focus on this. Depending...

"Negativity, tearing down, just generally poor behavior doesn't do anyone any good. Best to always be, as much as possible, uplifting. It does get hard sometimes though, just saying."

I never...

A little bit tricky for me, the code as is (ignoring the missing indentation) would fail since calcsq is defined as calcsq then called as calcSq, the differing case would...

Without knowing the details of the email that the employee opened it's hard to say. There needs to be a judgement call as to whether or not the employee should...

Reading the comments, there's been a mixed amount of change since 2015 to today out there.  For me, lots of change, in 2015 I was all SSMS all the time...

Thank you Steve; you're spot on here and I thank you for calling us to task on this.

I'm a proponent of schema for both security and organization.
Our design for data access and manipulation is fairly straight forward. the R part of CRUD is done via...