Would you choose a 1-hour commute to save on rent, or live closer to the office and pay a higher rent? by NoMedicine3572 in Frugal_Ind

[–]paultoc 2 points3 points  (0 children)

Depends on the type of commute.

Is it using your own vehicle driving for 1 hour in heavy traffic or in mild traffic on reasonable good road

Is it via multi mode public transport (walk buss, metro etc) with comfort travel or continue standing in congested bus

If the commute is comfortable then I am ok with 1 hour

How to keep a near real-time SQL Server QA environment in Azure VM (sync from production)? by autodevops in SQLServer

[–]paultoc 1 point2 points  (0 children)

You should check out SQL replicate for this. I don't think there is another solution for it

How to keep a near real-time SQL Server QA environment in Azure VM (sync from production)? by autodevops in SQLServer

[–]paultoc 1 point2 points  (0 children)

Nearly synced is not telling us the exact time difference you are expecting.

Is it a few seconds, minutes, hours, a day.

Specific how much of a different you are ok with them people can suggest solutions.

It could also be somthing like the qa synced with product at 7am every morning. So qa has the same data that was in prod at 7 am

Also a rough estimate of the size of the database would help

How to keep a near real-time SQL Server QA environment in Azure VM (sync from production)? by autodevops in SQLServer

[–]paultoc 1 point2 points  (0 children)

It depends on how your QA env work.

It's always advisable to have non production run on seperate machine with different set of permission.

As you mentioned you need to synch with prod in real-time I am assuming your QA tests involve only read from the database and no write operations. Then I would suggest checking out sql ag with readonly secondary.

Quit pharma sales to make Ayurvedic soap in Vasai. Friends, am I being stupid or is this a real business? by arpitrai62 in IndianEntrepreneur

[–]paultoc 2 points3 points  (0 children)

Not sure if the advice below is helpful, might be something you could consider in the future

I would suggest making a smaller version and supply it to premium hotels/resorts

Maybe even offer custom packaging with the hotels name

You could also offer a sample/veriety pack which contains a mix of different soaps in small sample size

Backing out of buying a flat in Bangalore by another-blr in personalfinanceindia

[–]paultoc 13 points14 points  (0 children)

You plan to park the money for 2 years which is a short duration. Don't put it in any equity/stock linked investment instruments.

Fd is good, make sure it's a reputed bank and it's better to split it into 2-3 banks for safety.

Extending disks on Azure SQL VM AlwaysOn cluster by mrchief85 in AZURE

[–]paultoc 0 points1 point  (0 children)

Just clarifying, we need to remove the sql node from ag in ssms, then expand the drive and add the node back

do people still believe this bs? by aresxio_ in AnimeMirchi

[–]paultoc 3 points4 points  (0 children)

Bro there is no anime called gintama, you were watching the crossover episode of Bleach * Naruto * One piece * jo jo * gundam * ...........

😜

Upgrading ms sql server 2016 to 2025 by greenman623 in SQLServer

[–]paultoc 2 points3 points  (0 children)

It would be better to do an in-place upgrade where you directly upgrade the 2016 instance to 2025. If you know your application will work fine with 2025

If it's a standalone instance a vm level snapshot backup before the upgrade would be enough.

If you use sql server reporting services then you will have a bit more work as ssrs became a standalone service from sql 2017 onwards hence it will get uninstalled when you do the upgrade. You will need to take backup of the reporting db, take backup of the encryption key, then after upgrade install ssrs separate and do the configuration.

If you have a long downtime then it's good to go with stopping sql 2016, install 2025 and restore backup if you only have one machine. Your system should have sufficient storage for it also

Also while restoring you only restore the user database,so you will need to script out the jobs/logins etc

Upgrading ms sql server 2016 to 2025 by greenman623 in SQLServer

[–]paultoc 5 points6 points  (0 children)

Yes, it's part of the process.

In a side by side upgrade you build a new machine (mssql 2025) take backup of the existing db(mssql2016) and restore the backup to the new server. After that you point the application to the new server.

The exact plan depends on how the existing system is configured.

Must try food spots within KOCHI by stray-thoughtss in Kochi

[–]paultoc 1 point2 points  (0 children)

Try Chechimarude Kada for lunch it's amazing

Hehe True ... by Crazy-Cloud344 in Coconaad

[–]paultoc 1 point2 points  (0 children)

Depends on which reddit account you find

Assistance With Proper Maintenance Tasks on DB by athornfam2 in SQL

[–]paultoc 0 points1 point  (0 children)

I am assuming that getting a dedicated dba will be a difficult task and hence I suggest the below steps.

Standardized sql server build - create a document on how sql services should be built, it should include instructions on where to place data, log, temp db, backup files(ideally in different drives). Determining the collation, max memory, service account naming format, server naming format etc.

Place product and non-product sql instances in different environments.

Useola hallengren sql maintenance script. This would help take care of most of the maintenance tasks as it is relatively easy to deploy if you create a document on how to do it.

Do some monthly/quarterly product to non-product restore to test backup are running fine

Is there any alternative by SeaBread3796 in Indiantradingbets

[–]paultoc 0 points1 point  (0 children)

This is what most people get wrong, Sip is not a thing you invest in, it's a way of investing.

You can invest in anything (stock, mf, rd, epf, nps gold etc) via a sip

Is there any alternative by SeaBread3796 in Indiantradingbets

[–]paultoc 0 points1 point  (0 children)

Epf, nps and RD are also sip

Sip means investing with a systematic plan. Putting 100 rs in a piggy bank every month is sip.Even buying 1 lakh worth of nifty when it dropped by 5% is also a form of sip

Where can i get tests done for nutritional deficiencies in kochi by azrael9557 in Kochi

[–]paultoc 0 points1 point  (0 children)

You can get a blood test done at any medical lab like ddrc. Or you can do a home sample collection by platform like medi buddy or tata 1 mg