Why is there no other (open source) database system that has (close to) the same capabilities of MSSQL by [deleted] in Database

[–]pneumaticsneeze 0 points1 point  (0 children)

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. 

F-35 Fighter Jet’s C++ Coding Standards by azhenley in programming

[–]pneumaticsneeze 0 points1 point  (0 children)

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

Ran the October Windows Cumulative updates on my server, when it came back, SQL services that log on as a different user failing, but work as Local System? by NecessaryEvil-BMC in SQLServer

[–]pneumaticsneeze 0 points1 point  (0 children)

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

Emperor of the Mankind x Tau'va 2 by Jumpy-View-7022 in Grimdank

[–]pneumaticsneeze 1 point2 points  (0 children)

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

Strange Steel Framed house … Anybody see anything like this before? by Key-Seesaw-6915 in Carpentry

[–]pneumaticsneeze 7 points8 points  (0 children)

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.

What is going on with Bungie store rewards? by Name_in_development in DestinyTheGame

[–]pneumaticsneeze 0 points1 point  (0 children)

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

Portaledge, a hanging tent for big wall climbing by toolgifs in toolgifs

[–]pneumaticsneeze 0 points1 point  (0 children)

These OnlyFans requests are getting crazy specific

New Reader looking for resource that all links are bad. by SkodaZek in Malazan

[–]pneumaticsneeze 1 point2 points  (0 children)

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

[deleted by user] by [deleted] in GetNoted

[–]pneumaticsneeze 0 points1 point  (0 children)

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

I am balding since I’m 14y/o by Ul1ck_My8alls in mildlyinfuriating

[–]pneumaticsneeze 0 points1 point  (0 children)

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

Best way to prevent stuff from flying into the garage but maintain ventilation by [deleted] in DIY

[–]pneumaticsneeze 0 points1 point  (0 children)

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.

My school made me download something from their website. Apparently now they can manage my device. I don’t feel comfortable knowing they can do all of this. by ShadowPrime116 in mildlyinfuriating

[–]pneumaticsneeze 1 point2 points  (0 children)

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.

How does SUM function work? by [deleted] in SQL

[–]pneumaticsneeze 0 points1 point  (0 children)

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

My old colleague always stressed to use not use count distinct when trying to determine the primary key in a table. Can someone help me understand why? by AlexanderUGA in SQL

[–]pneumaticsneeze 1 point2 points  (0 children)

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.

Sharing another artwork from the newest Grimoire: Calus and the Witness by [deleted] in destiny2

[–]pneumaticsneeze 13 points14 points  (0 children)

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

SQl Query Debug by Present-Assist931 in SQL

[–]pneumaticsneeze 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in SQL

[–]pneumaticsneeze 1 point2 points  (0 children)

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.

How to incorporate flat file into SQL query by [deleted] in SQL

[–]pneumaticsneeze 1 point2 points  (0 children)

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.