My current company didn't have a DBA before I got there, so everything went in as Enterprise (smh). I've been slowly introducing Standard in where it would be more...

Would love to have a standard edition of developer version.  I've written queries that perform fantastic in development, but horrible in production only to find out the plan optimizer...

That's 2 of your April Fools' jokes that have turned out to be prescient!

I've been thinking about per-core licensing concerning software, not just SQL Server.  I understand that software...

All depends on the use case. One might work better than the other, or one might not work

Connect in SSMS and then select the security tab. Then expand logins, you should see something like:

Is your Windows login listed? For me, Aristotle\Steve is my local...

I would likely try to host it as a container, so I can easily start the process and run it. It is an executable, so you could just run is...

What Johan said. You would need to track the plans across time for a proc to see if the same index is used or not used. Plans clear out of...

Praise and celebration can be big carrots. Assigning better work...

Firstly, what does a carrot look like to you?  A money-oriented person may gain motivation from the promise of a bonus.  A people-oriented person may gain motivation from the...

If you want to convert from a csv, python can help:

def detect_date_format(date_str):
    if re.match(r'^\d{4}-\d{2}-\d{2}$', date_str):
        return 'YYYY-MM-DD'
...

Don't threaten the AIs: https://venturebeat.com/ai/anthropic-study-leading-ai-models-show-up-to-96-blackmail-rate-against-executives/

So much for Asimov's laws of robotics.

Interesting debate and technique. I tend to like looking for creative solutions that might not impact users. A new table, if this one isn't too active with changes, is a...

Likely some weird VS thing related to the shell.

I am glad in many ways that v21 uses the newer VS shell. Seems cleaner, though the different icon and slightly different...

I tend to use Brian's approach, doing an update then insert. One of the things that sometimes helps if it's  a lot of records is I'll add a bit col...

I tend to agree. I was surprised that some DBAs didn't want to compromise to 1 tool and then ad hoc queries as needed. The overhead worries me, especially if...