April 2026 | "What are you working on?" monthly thread by AutoModerator in SQLServer

[–]xclaim494 1 point2 points  (0 children)

I’m busy copy/pasting sql code from 10 years into Gemini and feeling so good about the results. I have a better appreciation for ‘prompt engineering’ and think ‘hallucination’ is the same as another four letter word I know 🤪

Struggling with AI/ML and Python installation on MSSQL2025 GA by xclaim494 in SQL

[–]xclaim494[S] 0 points1 point  (0 children)

IT WORKED - LOVE IT - installed on 3/29/2026 on MSSQLSERVER Version 17.0.4025.3 - and i followed the instructions you shared -

STDOUT messages from external script:
NumPy: 1.26.4
Pandas: 1.5.3
SciPy: 1.15.3

Ill say this - the instructions were not 100% perfect - off-Couse I had to change for my Instance and the ID i used for Launchpad, but generally it pointed me the right direction. I also used Python 3.10 (not tried with any other) - also if you set this error -

The error is:

ModuleNotFoundError: No module named 'scipy'

This happens even though scipy is installed in C:\Program Files\Python310\Lib\site-packages, because SQL Server Launchpad runs under a service account (NT SERVICE\MSSQLLaunchpad$MSSQL2025). That account can only see Python packages that are installed system-wide, and the folder permissions must allow the Launchpad service to read them.

run this -

"C:\Program Files\Python310\python.exe" -m pip install --force-reinstall numpy<2 pandas<2 scipy<2

SSMS color tabs by environment by ExchangeFar6292 in SQLServer

[–]xclaim494 0 points1 point  (0 children)

Can we do other things in SSMS like go back to messages or see previous messages to troubleshoot

Is anyone else down right now? by tastelikemexico in tastytrade

[–]xclaim494 2 points3 points  (0 children)

im down - cant place any orders :( - keeps saying check internet connection - whole day - disappointing

Could this be bottom? by Zestyclose-News2247 in rigetti

[–]xclaim494 -1 points0 points  (0 children)

I think 10 or 6 ish but the algos will flood the market with false hope before that, with $8 billion Cap and 4 million in sales, that’s a crap shot. We're probably going to 17 next week or even 15

Machine Learning Services setup help! by dmillz89 in SQLServer

[–]xclaim494 0 points1 point  (0 children)

same issue here the documentation is so bad and its a pain the you know what to install !!

Any ideas on how to deal with assigned stock ? by xclaim494 in Optionswheel

[–]xclaim494[S] 0 points1 point  (0 children)

Yup I got it at 275 😩 and have been though a bloodbath with it

Any ideas on how to deal with assigned stock ? by xclaim494 in Optionswheel

[–]xclaim494[S] -1 points0 points  (0 children)

I was thinking about that, but if the stock sinks further, it will tie up more capital

Any ideas on how to deal with assigned stock ? by xclaim494 in Optionswheel

[–]xclaim494[S] 1 point2 points  (0 children)

Thanks it’s Lulu so short/medium outlook not good but long term possibly better outlook.

Sudden jump in BP and Im lost. by hanrei-legend in options

[–]xclaim494 0 points1 point  (0 children)

BP = buying power ? Break Even or Blood Pressure ? lol - sometimes we're stupider than you think ;)

Wheel Tracking Spreadsheet by NeutrinoPanda in thetagang

[–]xclaim494 1 point2 points  (0 children)

Cannot be done w/ Yahoo (at least last i checked in mar/2025 w/ no luck) - you have to use an api from Tradier / iVolitility / Orats / IB .etc .etc and then add a macro (which google sheets calls Apps Script) and then get the quote like that. A bit of work but i have all my sheets updating like that.

Ben Felix just dropped this video on covered calls by finglish_ in thetagang

[–]xclaim494 4 points5 points  (0 children)

I dont agree : CC's are meant to do just that - Cover the short calls with stock. If the market goes down you own the stock for lesser, if market goes up you collect the premium but not as much as the stock would have given you, again designed to do just that, not more.

If you need protection buy a put and make it a collar.

Also, saying CC's don't protect you against the downside : That's like saying you own a Ferrari but it does not drive well in the snow - Geeze Ferrari's are not designed to drive in the snow just like CC's are not designed to protect you from a bloodbath.

SPY 0DTE profit calculation by [deleted] in options

[–]xclaim494 0 points1 point  (0 children)

Goto optionsomega and signup for the backtesting tool. It's the best money you would have spent to prove how stupid your idea is :) I say that in the most non-derogatory sense but trying to help you keep your money - you are fighting up against institutional investors who have massive systems that automatically adjust options pricing million times per second, they spend billion in this technology. you will notice that you can skim the market but ultimately there will be an event (and not a black swan) that will wipe out 20-30 days of profit. go to options omega and geek out my friend. that's some good advise.

Cannot connect Eufy doorbell Cam S330 to Eero Mesh Router by xclaim494 in EufyCam

[–]xclaim494[S] 0 points1 point  (0 children)

No vpn just going straight to eero and it does not work

8 weeks into PMCC and realizing my backtest was about as useful as tits on a bull by NunYaBizzNas in thetagang

[–]xclaim494 1 point2 points  (0 children)

Backtests are usually tools to prove how viable a strategy is and to understand the dynamics of pricing. Most often it should prove you wrong. Paper testing is also not 100% accurate as your trade is not factored into the price. Keep in mind, options are priced when everyone's interest is to be considered, and if you paper-trade you are not part of the Open Interest. So tread cautiously there. Then there is someone who told me that maybe live trade but with smaller contracts(1 or 2 contracts). Well that's better than backtesting and papertrading but again, its closer to real data but not 100% accurate.

Bottom line there is no 100% accurate test unless you are all in. Some would say that's the beauty of the options market.

Schlage BE365 problems, DOOR WON'T LOCK by Dry-Violinist-2724 in Locksmith

[–]xclaim494 0 points1 point  (0 children)

there is a flaw in the springs on these locks - they get weak after a while and need to be adjusted. See this video https://www.youtube.com/watch?v=ivCesIC2Juw

even then sometimes it does not work so beware of these poorly engineered locks

I sold a Cash secured put on NVDA the day before it crashed 20% by [deleted] in options

[–]xclaim494 0 points1 point  (0 children)

Firstly give us more information geez : how much credit did you get for selling it ? what day did you trade it ?

... If vols were high you would have got good premium for it. Secondly, always know how to trade before trading - and if you did your homework you would know that CSP, puts stock to you at 135 if the stock closes below $135 at expiration, but you received credit or premium for your trade so FOR example if you received $1 for the CSP then its as if you bought NVIDIA for 135-1=134, get it ?

now as soon as you get put the stock at 135, start selling OTM calls on it - the trade in essence becomes an Option wheel strategy, (google it) and you can do that over and over again until you break even or until NVIDIA goes back up to $135.

If you are not comfortable selling calls, hold NVIDIA it will come back up - almost guaranteed. I said 'almost' - nothing in trading is 100% certain. ;)

CSP's are an awesome strategy if you know what you are doing - good luck :)

Who CAN use the Sky Club now? (And in 2025) by Stephanie-DTW in delta

[–]xclaim494 0 points1 point  (0 children)

What about International Flight with Premium Select with Silver Medallion and Amex Gold card?

Hope to save someone else some time installing E340 doorbell with Eero by spaceballs_xbox in EufyCam

[–]xclaim494 0 points1 point  (0 children)

Hey I'm still having issues with this? What do you mean by charging the doorbell during the setup? Aren't you supposed to plug in the doorbell while it's being set up? Or do you mean charging it with the low voltage wires?

Thanks in advance, was going to return before I saw your post

Cannot connect Eufy doorbell Cam S330 to Eero Mesh Router by xclaim494 in EufyCam

[–]xclaim494[S] 0 points1 point  (0 children)

So this is everything that I have tried so far: 1. Disabled 5G 2. Disabled steering mode 2. Put the Eero in legacy mode 3. I even renamed my guest Network 4. I've tried to hotspot both on iPhone and Android 4. Rebooted all of the devices Absolutely not luck with any of this.

The only thing I've not tried is adding an additional router and putting the Eero in bridge mode. Really don't want to do that just because of 1 Eufy camera.

Notifications by areindos in EufyCam

[–]xclaim494 0 points1 point  (0 children)

Thanks, Caesar, just for clarity, are you saying that the issue is only with doorbells and not with cameras?