With the ever-evolving IDE's, my thought is that some essential knowledge may morphe into the "magic" sphere...

😎

SQLCMD, OSQL etc. did the job when one knew what the job was 😉

The bottom line is that, once again, they broke something that used to work just fine.  They're motto seems have become "If it ain't broke, fix it 'til it...

I will elaborate Jeff on the subject shortly.

😎

Certain that there is a bug there, the microsecond rounding used to work for the datatime data type, interesting to see if other...

Show your code, ol' friend, so that people don't just look at...

He he, 2022-07-03 13:41:52.0070000 is now unequal to 2022-07-03 13:41:52.007 depending on the data type 😉

😎

I cannot sufficiently nor politely express the growing level of disgust I've developed about Microsoft and SQL Server, especially since 2012 sp3.

I'd written some simple code to determine a...

As it happens, a  lookup table is precisely what I am creating.

The descriptions are supposed to be unique. If the originating organisation puts in duplicates because they cannot decide...

Hi @mark-3,

my concern here is that this exercise will render the data nonsensical and ambiguous.

😎

This free text approach is YASA, yet another SQL antipattern, a better approach is...

Thank you @Sukhdevsinh for this writeup!

😎

Now my question is; Why would you like to concatenate multiple values into a single value? I consider that as an antipattern that should be...

The image data type should be avoided, no real benefit over modern binary data types.

😎

The image data type can only be converted to binary, varbinary and interestingly enough timestamp. The...

Thank you Shivayan for this nice write-up, now I'm interested in how this scales in cost and capacity compared to other solutions. Any thoughts?

😎

And...

No but I have raised this kind of risks several times in the passed in assessments.

😎

If software is operating...

Just as peanuts are not nuts, they are legumes, peanuts do not have exocarp, mesocarp, and endocarp, phone numbers are not numbers. Phone numbers are not mathematical objects as phone...

Would anyone be prepared to help me with a few (seemingly) simple DAX questions?

I've been reading up and searching for answers, but can't seem to find the right way...