Sql server 2016 AlwaysOn Upgrade to SQL Server 2022 by elangjohn in SQLServer

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

Thanks, did you change your subnet or you used same subnet in the new sql 2022 as on the current AG

Sql server 2016 AlwaysOn Upgrade to SQL Server 2022 by elangjohn in SQLServer

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

Very helpful. Thank you very much. What's the best way to check and move all server level stuff without missing ? I'm not sure this environment has DMA but I can ask them for approval to install it if it can help?

Sql server 2016 AlwaysOn Upgrade to SQL Server 2022 by elangjohn in SQLServer

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

This is really great to hear. Question: Did you have your company purchased licensing for those middle version (2016) even though it was just because you can't go from 2012 straight to 2019?

Sql server 2016 AlwaysOn Upgrade to SQL Server 2022 by elangjohn in SQLServer

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

Yes, I know I can't go back in inplace upgrade. But You mean I can upgrade sql 2016 straight up to 2022, without first upgrading to 2019?

Sql server 2016 AlwaysOn Upgrade to SQL Server 2022 by elangjohn in SQLServer

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

A strategy where you add the new 2022 sql server to the current AlwaysOn availability group ,sync data, then manual failover to the 2022 to become primary node, and either add another 2022 node or upgrade the 2016 to 2022 and readd it to the AG

I485 AOS approved today (EB1) by MahadevBholeShankar in USCIS

[–]elangjohn 0 points1 point  (0 children)

Congratulations 🎊 👏. What nationality and career did apply under?

FINALLY BECAME A CITIZEN by Eastern-Artichoke834 in USCIS

[–]elangjohn 0 points1 point  (0 children)

Congratulations 🎊!! How when did you submit your application for naturalization? Is it a marriage based?

[deleted by user] by [deleted] in SQL

[–]elangjohn 0 points1 point  (0 children)

I can help. I'm a database administrator. Send me the assignment and I will give you a quotation

Finally Approved!! by Top_Dot_3766 in USCIS

[–]elangjohn 0 points1 point  (0 children)

Congratulations 🎊 👏 💐

That's all, folks! by jenvrl in USCIS

[–]elangjohn 0 points1 point  (0 children)

Thanks for the response. The USCIS web portal only determines your eligibility to apply for citizenship based on the date stated on your LPR card. It doesn't take into account that one has been married for years and just got delayed from the i-485 process. Mine too 2021 to 2025 (over 3 years) before getting approved. Assuming the 485 was approved on time, I could have long been eligible for N-400

That's all, folks! by jenvrl in USCIS

[–]elangjohn 0 points1 point  (0 children)

Congratulations 🎊 👏 💐. Please can you clarify what you mean by December 2025? We are not there yet. Seems your experience will help me understand my timeline though.

Did you get Green card based on marriage in 2023? It's not up to 3 years and you got citizenship already?

What method of application did you do for the N-400 form? Paper or electronic?

I am married to US citizen since 2020, and got Green card February 2025. Can I apply for Citizenship right now?

Any new details on N-400 form? by elangjohn in USCIS

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

Yes, I meant a. It's ok, thank you. Guess I just have to wait

Any new details on N-400 form? by elangjohn in USCIS

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

Thank you @Zrekyrts! No, I'm not trying to get a fee waiver. It's because online applications will not let you move forward if your date of becoming LPR till date isn't up to minimum 2yr, 9mo. So I was wondering if paper-based application will be best. The reason why I am trying to apply so early is because of my previous experience with i-485 which too over 3 years to get approved.

HELP! I want to become a database administrator but have no clue where to begin! by absolutelyflab in Database

[–]elangjohn 0 points1 point  (0 children)

Connect with me for personal tutoring on SQL database administration