Archivo del Autor: carlosap
t8-1 geekbench
How to run a stored procedure on a daily /weekly/monthly basis?
In SQL Server, you should use JOBS to run a stored procedure based on schedule. Open SQL Server Management Studio. Expand SQL Serve Agent. Right-click on jobs and select a new job. Provide a name for the job and description. Click on the steps option> click new. Write the name of the step. Select the type of… Leer más »
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 »
The ‘Allen Computer Organ’, Ralph Deutsch – Allen Organ Co, USA, 1971
The Allen Computer Organ was one of the first commercial digital instruments, developed by Rockwell International (US military technology company) and built by the Allen Organ Co in 1971. The organ used an early form of digital sampling allowing the user to chose pre-set voices or edit and store sounds using an IBM style punch-card system. The… 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 »
Useful LXD commands
Summarized from https://stgraber.org/2016/03/19/lxd-2-0-your-first-lxd-container-312/. Interestingly, the LXD command line client is named…. lxc! List available containers Launch a container This creates and starts a container. Create container Without starting it. Start/stop after creating it List local containers Available columns for the list command Rename Configuration Config changes are effective immediately, even if container is running. Enter the container… Leer más »
Commenting and Uncommenting Code in SQL Server Management Studio
To comment out lines of code in SQL Server Management Studio (SSMS) Query Window, select lines of code you want to comment out and hit the keyboard shortcut ‘CTRL+K’ followed by ‘CTRL+C’.
Solucionar «No se puede obtener acceso a esta carpeta compartida» Windows Server 2019 raspberry samba
A veces cuando tenemos una red de computadores en la que conviven sistemas GNU/Linux y Microsoft Windows, podemos presenciar una que otra actitud excluyente de la «ventanita» hacía el pingüino. Por ejemplo, si tenemos un servidor Samba compartiendo recursos en una red Microsoft Windows, puede que al intentar acceder a una carpeta compartida desde el Windows 10, éste nos niegue el acceso… Leer más »