Why SQL is beating NoSQL, and what this means for the future of data
https://blog.timescale.com/blog/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a/
Archivo de la categoría: Windows
Azure Data Studio for linux macos windows
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15
restore database TSQL
SQL Query for Counting Records per Day
This SQL query will add up the record count per day based on a column called “Timestamp.” Transact SQL SELECT DATEPART(YEAR, Timestamp) AS ‘Year’, DATEPART(MONTH, Timestamp) AS ‘Month’, DATEPART(DAY, Timestamp) AS ‘Day’, COUNT(*) AS ‘Visits’FROM tblVisitsGROUP BY DATEPART(DAY, Timestamp), DATEPART(MONTH, Timestamp), DATEPART(YEAR, Timestamp)ORDER BY ‘Year’, ‘Month’, ‘Day’ Results The results of this query will appear… Leer más »
Fixing a SQL Server That Wont Start Due To Max Memory Being Set Too Low
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason it was having problems was that it had been set to a max memory of 10mb. At this point I was unable to change the max memory setting because I couldnt bring the instance online.… Leer más »
How can I monitor the number of users logged in to Windows? PRTG
https://kb.paessler.com/en/topic/69346-how-can-i-monitor-the-number-of-users-logged-in-to-windows This article applies to PRTG Network Monitor 16.2.23 or later Monitoring the Number of Logged in Windows Users The Windows Logged In Users sensor is one of the sensor types that we remove in context of the The PRTG Sensor Cleanup. You could use this sensor to monitor the number of users logged in to a Windows… Leer más »
Combina Filas Duplicadas Y Suma Los Valores Con La Función Consolidar
Consolidar es una herramienta útil para consolidar múltiples hojas de trabajo o filas en Excel, por lo que con esta función también podemos resumir varias filas en función de los duplicados. Por favor haz los siguientes pasos: 1. Haga clic en una celda donde desea ubicar el resultado en su hoja de trabajo actual. 2.… Leer más »
Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the .xlsx file because the format or extension is not valid
Last Updated: June 11, 2019 ISSUE You may receive an unexpected prompt to Grant Access to files when you try to open a file or do «Save as…» or «Save a copy». When this happens, Excel may become unresponsive and you will need to force quit the application to recover. STATUS: WORKAROUND We are investigating… Leer más »
mount NFS windows 2008 r2
at cmd prompt >mount -o anon \\192.168.1.1\srv\share z: z: is now successfully connected to \\192.168.1.1\srv\share The command completed successfully.
Use the System File Checker tool to repair missing or corrupted system files
source: https://support.microsoft.com/en-us/help/929833/use-the-system-file-checker-tool-to-repair-missing-or-corrupted-system Applies to: Windows 8.1Windows 8.1 EnterpriseWindows 8.1 Pro More System File Checker is a utility in Windows that allows users to scan for corruptions in Windows system files and restore corrupted files. This article describes how to run the System File Checker tool (SFC.exe) to scan your system files and to repair missing… Leer más »