tldr; W11 bluetooth doesn't work with multiple cards. It will see devices but will not pair. Same hw pairs under Linux.

hey folks. I posted this to /r/techsupport on reddit and for some reason they say they don't support Windows 11 Enterprise... and it took them a day to tell me instead of using automod. I thought this was both funny and the dumbest thing. Anyway, here's a fun little issue I'm trying to sort out.

Windows 11 Enterprise 22h2 (22621.3810)

About two weeks ago (after a year of having this system) my bluetooth decided not to pair with anything. It will see devices and try to pair, but it never goes through.

I have tried:

• a different wireless card / bt combo (PCIE)
• removing the wireless / bt combo and using a bt dongle
• removing all drivers (show hidden devices etc), rebooting clean, reinstalling
• changing the USB connection to the mobo for the PCIE card
• live boot of latest Ubuntu LTS -- successfully paired DS4 controller and Sony Headphones

The event logs for Bluetooth Policy are all positive (e.g. A connection to a remote device 0xA4538553B7FD was successfully established) -- but nothing is paired.

This happened on a day when I added two HDDs to the box and ran updates etc. I also tried everything above without the drives installed without any luck.

Any ideas?

notes:

• I just finished with a W11 windows-to-go install off a super slow USB and I wasn't able to pair headphones or the DS4, but I did pair some sony TW earbuds. I'm sensing a fresh install in my future.

I watch Countdown every day. For the last year I've had a t2.micro for free from AWS. Its been pretty good, but my year is coming up. I am looking for the cheapest VPN possible, which is often having my own VPS.

Does anybody have any suggestions? Most are around $6, which isn't too bad, but I'd love to get something cheaper; either in a reliable lowend box or a proper provider.

Current Library: built in sqlite
Current db: sqlite (but will have access to Snowflake soon for option 1 below)

Wondering if anyone here has some advise or a good place to learn about dealing with databases with Python. I know SQL fairly well for pulling data and simple updates, but running into potential performance issues the way I've been doing it. Here are 2 examples.

1. Dealing with Pandas dataframes. I'm doing some reconciliation between a couple of different datasources. I do not have a primary key to work with. I have some very specific matching criteria to determine a match (5 columns specifically - customer, date, contract, product, quantity). The matching process is all built within Python. Is there a good way to do the database commits with updates/inserts en masse vs. line by line? I've looked into upsert (or inserts with clause to update with existing data), but pretty much all examples I've seen rely on primary keys (which I don't have since the data has 5 columns I'm matching on).

2. Dealing with JSON files which have multiple layers of related data. My database is built in such a way that I have a table for header information, line level detail, then third level with specific references assigned to the line level detail. As with a lot of transactional type databases there can be multiple references per line, multiple lines per header. I'm currently looping through the JSON file starting with the header information to create the primary key, then going to the line level detail to create a primary key for the line, but also include the foreign key for the header and also with the reference data. Before inserting I'm doing a lookup to see if the data already exists and then updating if it does or inserting a new record if it doesn't. This works fine, but is slow taking several seconds for maybe 100 inserts in total. While not a big deal since it's for a low volume of sales. I'd rather learn best practice and do this properly with commits/transactions vs inserting an updating each record individually within the ability to rollback should an error occur.

Right now ~comp and ~tech are getting these kinds of posts, but I personally feel a ~tech_support ~tech.support (or ~tech_help? ~tech.help) group would be a better alternative.

People who love to help would flock to the group, and people who need it would feel safer to ask for help without receiving straight up LMGTFY (Let Me Google That For You) kind of answers.

There could be also a ~help group, wich a much broader scope (probably about Tildes itself).

What you think?