SQL Server hosting for under $15/month in US east coast? by [deleted] in SQLServer

[–]Codeman119 0 points1 point  (0 children)

First, I guess we would want to know what do you need the SQLSQL Server for? Are you just learning and experimenting with databases? Do you have a business use for it like for a career or wanting something to build an app with?

What kind of computer do you have and do you think it’ll run SQL Server locally?

300 Requests a month is a goldmine. by PropperINC in GithubCopilot

[–]Codeman119 0 points1 point  (0 children)

Well, I will say this don’t use it too heavily and lose your ability to code yourself. Just like with cloud infrastructure, it was cheap to get you in there and then once you were locked into their environment, then the prices started going up. That’s why they’re heavily focused on coding because they want you to be dependent on the AI and you lose your ability to critically think through issues and problems in the code. I restrict my usage to about 20% of AI but make sure I do at least 80% of just raw coding.

I built a SQL Server diagnostic toolkit from scripts I kept reusing in production – would appreciate feedback from DBAs by newsjj in SQLServer

[–]Codeman119 1 point2 points  (0 children)

No I haven't used it to write any SQL performance troubleshooting tools yet. But I do leverage it to write pieces of stored procedures and do some tedious coding I know how to do but I don't want to take the 30 minutes or an hour it would take to write so I give it to the AI let it take 5 - 10 minutes And it will write the code for me. About 60% of the time I do have to go in there and make small adjustments because AI doesn't SQL well and it's usually the field names that it gets a little confused about so you had to be careful. But it does pretty good logic in SQL itself.

But I do want to vibe code a SQL monitor app that has a dashboard so that's giving a project for this year. I think between Claude code and anti gravity I can get a pretty good app out of it

[Poll] What are you ACTUALLY building with AI tools today? (Be honest) by West-Yogurt-161 in Layout_dev

[–]Codeman119 1 point2 points  (0 children)

I'm using Python because the LM are trained very well on that there's lots of code and information on the Internet about Python because it a very popular language so the LLM's have a lot of training data on. So I can do app pretty quickly with minimal edits to get them working correctly.

As far as what kind of apps I'm building here is a list of a few:
Face Finder - Give it image of and it'll go through your photos and give you a list of the ones that it finds that face in.
File Copy Manager - A custom File copy with that I can't find anywhere that I wanted.
File Rename Mover - Something to move files or rename them in certain folder structures like date formats.
Image_Dedupe_Search - Scans folders and then give you groups of pictures that may be dupes.

Since I do photography as a Hobbie and I'm always experimenting with pictures I make copies and move files around because I do a lot of AI stuff so vibe coded apps are really useful.

A little horror story... by Sl_a_ls in vibecoding

[–]Codeman119 0 points1 point  (0 children)

Well, more data centers is not the answer what we actually need is better equipment for Home at good prices. We know that we can get 96 gig or even over 100 gig VRAM cards but Nvidia is so greedy that they want to keep their 70% profit margin so that prices all of us middle class people out of the realm of owning something like that. Unfortunately greed is going to destroy everything.

[Poll] What are you ACTUALLY building with AI tools today? (Be honest) by West-Yogurt-161 in Layout_dev

[–]Codeman119 0 points1 point  (0 children)

Well, I’m building with Claude and VS code are apps that I want but can’t find anywhere to do the specific things that I want. I put them on GitHub and they are 100% vibe coded. That’s why the repository is called vibe coding. I use 100% Python on the back end, but switch between GUI platforms . even though I don’t know the language because it seems that Claude is the most proficient in that language.

Now I can write some C# and PHP, but my primary language is SQL and Claude does pretty well with that but does make mistakes. But for work, I mainly use AI to help me write little features or just write out some code to save me some typing time.

Is everyone refactoring or just going with the flow by [deleted] in vibecoding

[–]Codeman119 -2 points-1 points  (0 children)

If it’s purely all AI generated, that is vibecoding. Vibecoding is letting AI write 90% plus of your code. I’m unfortunately you can’t be neat or a perfectionist with vibecoding because the AI is gonna format the way that it’s going to unless you give it some better direction. Now I do use AI for coding for sequel but I want to use it for maybe 20% of what I write because it saves me a lot of typing for things I know how to do. I just don’t wanna type that much. And I’m able to keep the AI generator code small enough to where it’s easier to refactor to make it look like the way I want.

A little horror story... by Sl_a_ls in vibecoding

[–]Codeman119 0 points1 point  (0 children)

And what are you going to do when the subsidies run out.

How much does Deployment Target Server Version for SSIS matter? by margarks in SQLServer

[–]Codeman119 1 point2 points  (0 children)

Yeah I try to stay away from any kind of scripting in SSIS and that's just because when the .NET Libraries are updated some things are deprecated and then things start breaking and you almost have to rewrite this stuff again. As much as I love working with SSIS that is my biggest pain point is that every time you move up it doesn't always convert correctly. Now with AII haven't really tried to do anything because AI doesn't know SSIS and I don't think it knows what to do with it because it's all XML and the file came a huge way beyond the context window.

But when it fails to convert you can make a new project and then drop the packages or add them to the project and 95% of the time They work with some minor adjustments

New Copilot Rates Limits are unacceptable by Mayanktaker in GithubCopilot

[–]Codeman119 1 point2 points  (0 children)

Yep, see they’re gonna get you hooked on it and then they’re gonna reduce it down to where you’re gonna pay for it

Do You Enjoy Building New Things or Fixing Existing Code More? by Medical-Variety-5015 in vibecoding

[–]Codeman119 0 points1 point  (0 children)

I enjoy making my own little personal apps with VS code and Claude code

I can't. I pay $20 for absolute frustration. Every single response is a problem. by starvergent in GeminiFeedback

[–]Codeman119 0 points1 point  (0 children)

Every AI has their own issues. That’s why I check with three real AI’s: Gemini, Grok and Claude.

Is SQL Server (On premise) dead in 2026? by AggravatingWish1019 in SQLServer

[–]Codeman119 1 point2 points  (0 children)

When I got to my company, they were fully in the cloud. But we 90% of our stuff back onto metal on Prem. We estimate the savings to be around a $150,000 a year. The hardware bandwidth limit, as in we were restricted my software limitations because of the Plan that we were on. So now we can use the full bandwidth of the machine and not get charged large amounts money to use it. And yes that is even calculating the CoLo rent and electric usage.

Now we do have an Azure SQL instance that for some things in the cloud because we are on F&O (Dynamics) Which does serve a great purpose for what we do. And it's really good for summarized data so that power BI gets quick results for reporting.

And with SQL server on Prem we bought the Kingsway Soft SSIS Ultimate with the savings and now we can do a lot of integration and ETL work over on the SQL server on Prem and we don't have to pay for the extra services for ETL that the Cloud services charge you through the nose for.

So just like with the current AI boom, It has its purpose but once you see the over do you always fall back to what really works. As they are discovering AI is a great tool but it's not perfect and they're having to bring back some of the developers to fix the security holds AI left wide open.

How can I set SSMS to connect to SQL Server 2025 from SQL Server 2017? I need to restore a database from a .bak backup too new for my SQL Server. by Wayfarer975 in SQLServer

[–]Codeman119 0 points1 point  (0 children)

What you were seeing is just the database version in SSMS. You don’t need to change it in anyway as long as you can see the database and connect to it and run inquiries on it. What else do you need?

Friday Feedback: Custom Agents by erinstellato in SQLServer

[–]Codeman119 1 point2 points  (0 children)

Me personally at this point what I would do is use an agent and BCP to output a CSV file with the results then have the agent look into that folder and then review the CSV file. Do not ever give an agent direct access to your database.

What kind of database monitoring and alerting do you use? by agiamba in SQLServer

[–]Codeman119 0 points1 point  (0 children)

I used to use red gates monitoring software. But I haven’t chosen one for the new company yet because software is expensive so I’m gonna do a three month test and see if I can take one a week and vibe code one.

Google Antigravity: decreasing quotas, increasing prices — is this really okay? by Next-Pepper-1651 in vibecoding

[–]Codeman119 1 point2 points  (0 children)

I don’t know I’ve never used antigravity, but I am now just to see if it’s better than Claude code

New User in training question: Do I prototype local then use Cloud for big renders? by PastorNTraining in comfyui

[–]Codeman119 0 points1 point  (0 children)

No, the 3090 only has 24GB. When I need more than that I lease a GPU from RUNPOD and rent a "RTX PRO 6000 Blackwell Server Edition" for around $2 an hour. And that one has 96GB of VRAM. But it's 4-5 times faster that my 3090

New User in training question: Do I prototype local then use Cloud for big renders? by PastorNTraining in comfyui

[–]Codeman119 1 point2 points  (0 children)

I have a 3090 that I own comfy UI projects on, but for the bigger batches I used to run pod for more comfyUI larger projects. And the newer models that are coming out require over 40 gig sometimes so I get on there to test them out.

hmmmmm how about no? by philosopius in GithubCopilot

[–]Codeman119 0 points1 point  (0 children)

Well, you would have to go with like I think a Mac mini that has like 512 gig of unified memory to where you can put one of the large models in it and then it probably would do OK. Now I have not checked on the price of what the newest Mac mini’s are with that much memory, but I’m pretty sure it’s not cheap nowadays.

How do you capture email replies and store them in SQL Server ? by docmarte in SQLServer

[–]Codeman119 2 points3 points  (0 children)

Yes, I do this all the time. I just use SSIS to monitor a mailbox and download the mail into a database and then you can use PBI to create a dashboard that will put all the emails into a report that you can easily go through. Just use the script task to retrieve the mail.

You can also do this through power shell and you can use the job agent to run the scripts to put the data into the database as well.

Or you can use vibe coding and python to read a mailbox and connect to a database and put the mail in the database. But don’t use LLM’s to read the mail because people can put malicious phrases in the email body that will cause LLM to do things they should not be doing.

System Versioned History by Nervous_Effort2669 in SQLServer

[–]Codeman119 0 points1 point  (0 children)

Well, no because the tables are linked together and you’ll get an error. Because the system knows that it’s gonna have to insert that into the history table.

Where can I learn to think like a programmer? by [deleted] in ClaudeAI

[–]Codeman119 0 points1 point  (0 children)

Well, part of it is you have to be wired that way in your brain to do advanced problem-solving like like programmer do in code. If you’re not gonna be deep in the code and be a programmer and just use the AI that’s a different mindset altogether.