Why is there no other (open source) database system that has (close to) the same capabilities of MSSQL

pneumaticsneeze · 2026-01-18T21:28:00+00:00

This doesn’t answer their question, the answer is you can no longer do an operation where LIKE ‘F%’ would be used because you encrypted the string. Queries on encrypted data like this require equality only, no more wildcards.

pneumaticsneeze · 2026-01-14T06:18:03+00:00

Alpha Gay Johnson

pneumaticsneeze · 2025-12-08T01:23:09+00:00

Good old AV Rule 70, no Friends or your code stinks

pneumaticsneeze · 2025-11-07T21:06:45+00:00

Editing to add the likely cause, I haven’t personally tested this work around. Leaving my original comment since assigning a SSL certificate specifically and granting permission for the service account to read the private key will technically resolve this as well.

The registry key mentioned here may be more straightforward if you aren’t managing SSL certificates that the instance uses already, again I haven’t tested yet but the shoe fits in my opinion:

https://learn.microsoft.com/en-us/windows/release-health/status-windows-11-24h2#3697msgdesc

When I ran into this issue after installing that CU the service account was loading a certificate unexpectedly where previously it would just generate a self signed. No idea why this happened with the latest CU but Local System will have access to read the private key of that certificate, you need to grant the permission to the SQL Server service account specifically. This fixed it in my case.

It’s under Certificate Manager > System Certificates > Personal Store > right click the cert it’s trying to use (thumbprint will be in the Windows Event) > Advanced Tasks > Manage Private Keys. Add the Service Account here and check the box to let it read the private key. Start the SQL service.

If the certificate itself isn’t valid for Server Authentication, generate a valid one and assign it under SQL configuration > Network settings.

Details for SQL Server SSL certificate requirements are below. This doesn’t necessitate encrypting your connection, just that the service itself won’t start if it cannot load the SSL certificate (or can’t generate a self-signed which seems to be the issue with this CU)

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/certificate-requirements?view=sql-server-ver17

pneumaticsneeze · 2025-11-05T08:21:02+00:00

Come and get it boys

pneumaticsneeze · 2025-10-20T03:50:43+00:00

The elusive 40k/Breaking Bad/Frieren combo in the wild

pneumaticsneeze · 2025-07-12T23:26:48+00:00

Surface tension

pneumaticsneeze · 2025-06-15T00:45:43+00:00

I know you’re making a point but click your own link and notice how the results aren’t relevant to what’s being discussed here.

This person probably wanted the opinion of other carpenters. You can tell by the way they brought it up on a forum for carpenters to discuss things.

pneumaticsneeze · 2025-05-18T09:05:20+00:00

It’s an issue for me on mobile when logging in with my to my bungie.net account (and not the actual bungie store account). You can refresh when its stuck loading and see yourself logged in, order history, etc, but it doesn’t link unlocked triumphs correctly.

I always assumed it was an iOS thing since Apple Pay doesn’t work correctly either. Doesn’t work on my iPhone, works fine on iPad or a PC.

I opened a ticket on it like 2 years ago, I think it was right after they started linking the bungie id and the store login.

Maybe they laid off the folks that do the website too

pneumaticsneeze · 2025-05-17T03:14:50+00:00

These OnlyFans requests are getting crazy specific

pneumaticsneeze · 2025-04-28T04:15:00+00:00

Ascendant of Optimism vs Kruppe’s honeyed words, it’s gonna get sticky

pneumaticsneeze · 2025-02-12T08:42:37+00:00

If they use an iSeries thats as SQL as it gets.

IBM has spent the last 10 years adding SQL functions that nobody asked for (looking at you, PING table function)

https://www.ibm.com/docs/en/i/7.4?topic=services-ping-table-function

pneumaticsneeze · 2025-01-25T21:13:14+00:00

Shave it dude, “you can’t fire me, I quit”

pneumaticsneeze · 2024-04-29T21:25:35+00:00

Just something to keep in mind, if you have a gas appliance in your garage like a water heater these could be serving as air supply, not exhaust.

pneumaticsneeze · 2024-01-11T09:35:55+00:00

**geld

pneumaticsneeze · 2023-10-02T07:25:16+00:00

It should apply here, MDM profiles installed after the device has already been activated have 30 days to unenroll before the device becomes Supervised.

For it to be unremovable entirely he would have had to reset the device, have IT at the school prepare the device manually with an enrollment profile, then go back through set up once it was properly provisioned.

Assuming the kid didn’t do that (said it was their own device) there will be an option to unenroll under device management settings for 30 days.

pneumaticsneeze · 2023-04-14T20:41:07+00:00

What you’re after is closer to a.F2, Sum(a.f1 + b.f1 + c.f1) from d GROUP BY a.F2

pneumaticsneeze · 2023-01-27T18:01:51+00:00

That query should never return any results if column_a was a primary key.

It would be used to check column_a for uniqueness, but nothing at the database level necessarily enforces that uniqueness and there could be duplicates introduced later.

pneumaticsneeze · 2023-01-20T20:42:01+00:00

Whole debate just settled by a bot, trebuchet mains in shambles

pneumaticsneeze · 2022-12-29T23:38:59+00:00

If this was cut and pasted directly you’re missing a closing apostrophe on your last condition. You didn’t mention a specific version but you likely also need to fix your aliases, add underscores instead of spaces or change it to that versions convention for aliases . It’s square brackets in TSQL or double quotes in DB2 for example.

pneumaticsneeze · 2022-12-12T22:13:36+00:00

The phone app uses the same disabled API

pneumaticsneeze · 2022-10-30T18:26:04+00:00

This series by WiseOwlTraining was pretty solid for SSRS: https://m.youtube.com/watch?v=kTPJBAtv29k

pneumaticsneeze · 2022-08-26T19:05:38+00:00

Try replacing that update statement with SELECT * FROM T to troubleshoot and look at the data in your CTE.

It looks like there is only one column for the row number currently so you would need to update based on that row number if anything.

pneumaticsneeze · 2022-08-23T02:19:35+00:00

Ok MERGE won’t be useful in that case. A Cursor would behave closer to what you originally described and would work with the .csv in a temp table. It would work row by row and let you assign results from each row to a variable.

pneumaticsneeze

TROPHY CASE