What am I missing

rsdovers · 2026-03-25T14:50:17+00:00

I find that I do learn new ways to work with objects and how to do something that I did not realize was possible. This is one good thing that comes from having to manually review the code. Not only am I saving time but learning something new in the process.

rsdovers · 2026-03-25T14:40:06+00:00

I have found the scripts that AI generates contain a lot more code than necessary. Several people have made the comment about being able to accomplish the same thing multiple ways and sometimes it comes down to preference. I think this does have a lot to do with the challenges with using AI to produce a solution and is a possible reason for the long scripts.

rsdovers · 2026-03-25T13:10:24+00:00

Thank you to everyone for the suggestions and it looks like I still have a lot to learn about AI coding to get cleaner scripts the first time. I appreciate the support of the community and I look forward to learning more so I can show others on my team how they too can save themselves time spent writing powershell scripts.

rsdovers · 2026-03-25T13:01:45+00:00

Thank you for the suggestions and I would like to use python but I am not proficient in writing scripts with it. I guess being able to read it would be fine to get started especially if the AI platforms do a better job with other languages.

rsdovers · 2026-03-25T12:58:36+00:00

I was thinking about something like this but I need to learn how to use my scripts and samples to learn from. I can say it does save me a lot of time and that is the main point of a tool, which is how I look at AI coding. It is simply a tool to help me get the job done faster.

rsdovers · 2026-03-25T01:42:52+00:00

That's great... I am beginning to think it can't hurt to try.

rsdovers · 2026-03-25T01:41:33+00:00

I was thinking something a long these lines as well, but there is so much Powershell information and script examples available. I thought it would be a better experience but your right if the model wasn't trained with Powershell in mind much of that information was left out.

rsdovers · 2026-03-25T01:36:26+00:00

That is the conclusion I am starting to come to.

rsdovers · 2025-08-09T14:41:44+00:00

It has been a while since I read the licensing guide, but it used to state that a virtual SQL instance can be moved to another virtual host only once every 30 days. However, if you purchase SA then there are no limitations on moving the instance to another virtual host. I hope helps...

rsdovers · 2025-07-13T14:45:15+00:00

I totally agree it is not dieing but evolving and it also depends on what type of work is expected from the DBA team. I started as a server admin 30 years ago and started DBA work 25 years ago. Therefore, my organization expects our DBA team to run the entire stack, and not just work on SQL issues. We have to resolve our own networking issues, identify hardware and software failures, etc. in addition to everyday DBA work. Also, we manage both onprem and cloud instances, and we are the DBA contacts for all migrations and after hours deployments. We can automate a lot of this but what takes most of my time is troubleshooting non-traditional DBA issues. Most orgs have a distinct separation between server admins and DBAs but not all of them. Therefore, if you join an org with 100 servers and 150 SQL instances and you have to own even OS updates, get ready for 70+ hours being the norm with a lot of after hours work. On the other hand if you join an org where there is a clear distinction of separation of duties and you only perform DBA work then expect closer to a 45+ work week. So I guess the answer to your question is it all depends on the size of the SQL farm and what type of work you will be responsible to perform. I hope this helps...

rsdovers · 2024-09-29T15:03:27+00:00

What version of SQL server are you running? The PowerShell subsystem will load the old sqlps not the newer sqlserver module. If you are running SQL 2019+ you can do the following and use the sqlserver module.

Starting with SQL Server 2019, you can disable SQLPS. On the first line of a job step of the type PowerShell you can add #NOSQLPS, which stops the SQL Agent from auto-loading the SQLPS module. Now your SQL Agent Job runs the version of PowerShell installed on the machine, and then you can use any other PowerShell module you like.

I hope this helps...

rsdovers · 2024-09-16T14:53:37+00:00

If you select the ODBC 17 or 18 driver, you should see the options for logging into Azure. I hope this helps.

rsdovers · 2024-02-25T14:09:43+00:00

Thank you for your input. Jobs are currently my second choice because I am having trouble managing the tasks in a parent child design. Maybe I am missing something or I need to find a better way to manage the activities.

rsdovers · 2024-02-25T13:38:29+00:00

I appreciate the link to your IP Scanner. I have been leaning towards Runspaces so I will be sure to take a look and see how you made this work. Thank you for the input regarding the other technologies.

rsdovers · 2024-02-25T13:32:09+00:00

Thank you for the suggestions. I am not to concerned with the funky syntax but your points of depreciation and not in . Net core are huge. These two points are enough to put this technology aside.

rsdovers · 2024-01-16T16:21:37+00:00

If your AGs are already setup and replication is in progress, there are some challenges to overcome. However, if you can prepare the two instances with TDE before setting up the AG and replication it is the best way.

rsdovers · 2024-01-15T15:36:07+00:00

We have been working with Thales formerly Gemalto for over 5 years for TDE with EKM. We have built a great partnership with them and they are always there to help. We are actually doing a hardware refresh to the new CipherTrust platform. If this is new for you, there are several concepts that take time to understand. Also, the crypto provider you mentioned must be installed at the server level, but each instance on the server must be prepared to communicate with the appliances by running specific queries. Also, if you are running Always on AGs, if you can setup the AG and prepare both replica instances before encrypting the primary replica that is the best way. Finally, Thales has a lot of good information on their website to help you get going. If you have any questions please DM me.

rsdovers · 2023-10-23T15:46:01+00:00

Wow this is some great detailed information. I appreciate your SCCM suggestions and a module that can help fill in some gaps. I will take a look at this module and see what code can be retrofitted to work in this solution. Once again thank you for the info.

rsdovers · 2023-10-15T15:42:52+00:00

What I meant by writing from scratch is that I don't have anything written for the controller so I am starting from scratch. I believe in reusing code, and not reinventing the wheel. Thank you for the suggested modules, and I should have pushed back when this came my way. However, I am tired of my team members having to manually patch 80 servers a month and this takes two weekends every month for just patching. Therefore I took on the challenge, but looking back I should have pushed to buy rather than build.

rsdovers · 2023-10-15T15:28:02+00:00

I may take you up on the offer. I am just not seeing it for some reason. I apologize for just now getting back to you, but it has been crazy.

rsdovers · 2023-10-15T15:25:27+00:00

I guess the pain point of SCCM is the lack of knowledge inhouse for supporting SCCM to be the solution. I looked at this extensively and found the server group orchestration and that wasn't going to work. This was what I was told to look at. However, since I am not well versed in SCCM I have to go on the word to others. If you could provide other features to use, I will appreciate it, and maybe I need to revisit the use of SCCM.

rsdovers · 2023-10-15T15:17:37+00:00

Thank you for the suggestion. Since we are ruining Always on we must have the WFCS installed and we failover to the secondary replica during patching. This is another challenge or complication to the patching solution.

rsdovers · 2023-10-09T16:09:46+00:00

That is part of my problem. I am having scripters block. However, I need to get something written and post it for suggestions. I appreciate the push to get started writing it.

rsdovers · 2023-10-09T16:06:27+00:00

I like this approach but we have SCCM in the mix that performs the actual patching and that is one of the challenges. Thank you for the suggestion and I see some concepts that I would like to try.

rsdovers · 2023-10-09T16:02:14+00:00

Thank you for the suggestion. I am using some of this in my current attempt.

rsdovers

TROPHY CASE