User, group, or role already exists in the current database

You moved the database to another instance and created a new login for this database instead of moving the login from the old instance to the new instance. I recommend that you read my article “How To Move Logins To Another Instance(sp_help_revlogin)”. You may receive this error when you want to authorize the login that you created for the database… Leer más »

 rsync runs by using a lock file crontab

You can ensure that only one instance of that rsync runs by using a lock file. util-linux includes a file locking wrapper called flock, which you can use in your crontab like so:

NASA’s Kepler Space Telescope discovered an Earth-like planet circling a nearby star within the Goldilocks zone of our galaxy. 

NASA’s Kepler Space Telescope discovered an Earth-like planet circling a nearby star within the Goldilocks zone of our galaxy.  Kepler-186f is around 500 light-years from Earth in the Cygnus constellation. The habitable zone, also identified as the Goldilocks zone, is the area around a star within which planetary-mass objects with enough atmospheric pressure can sustain… Leer más »

SQL query to get start and end date from a result set

-1 I am working on one of requirement the raw data is in following format Requirement – Startdate should be the date when status changed to 1 and enddate should be the 1st date after the record status changed from 1 to any other number. Customer Status Date A123 0 7/2/2021 A123 0 7/15/2021 A123 0… Leer más »