Zapytania SQL na danych z pliku CSV https://til.simonwillison.net/sqlite/one-line-csv-operations

How to create a portable windows application without an installer from an electron project: Clone the electron-quick-start repo: git clone https://github.com/electron/electron-quick-start yarn Make your application - probably edit main.js to navigate to some URL yarn add electron-packager Edit package.json - update the ’name’ and add a new script ‘packager’: { "name": "my-app-name", ... "scripts": { "start": "electron .", "packager": "electron-packager ./ --platform=win32" } } ’npm start’ will bring up the application ’npm run packager’ will package the app for windows. You will see a new directory ‘my-app-name-win32-x64’ in the top directory of the project, with a my-app-name.exe ...

git push do repozytorium non-bare Set receive.denyCurrentBranch to ignore, warn or updateInstead (according to your needs) in the remote non-bare repository to allow pushing the current branch. # Config receive.denyCurrentBranch to ignore in the remote repository # The configuration is applied to only this respository. $ git config receive.denyCurrentBranch ignore # Config receive.denyCurrentBranch to updateInstead in the remote repository $ git config receive.denyCurrentBranch updateInstead

Jak szybko uruchomić serwer WWW z wiersza poleceń? kilka sposobów: PHP php -S 127.0.0.1:8080 -t ./www python # python 3.x python -m http.server 8080 # python 2.X python -m SimpleHTTPServer 8080 źródła https://gist.github.com/willurd/5720255 - Big list of http static server one-liners

<?php $serverName = "127.0.0.1,1433"; //serverNameinstanceName, portNumber (default is 1433) $connectionInfo = array( "Database"=>"demo", "UID"=>"sa", "PWD"=>"pass"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { echo "Connection established.<br />"; }else{ echo "Connection could not be established.<br />"; die( print_r( sqlsrv_errors(), true)); } ?>

Linki do materiałów dotyczących git-a https://stormit.pl/git/

MSSQL - rozmiar tabel SELECT DF.name as [Plik] --,[File_Location] = DF.PHYSICAL_NAME ,[Rozmiar (MB)] = CONVERT(DECIMAL(10,2),DF.SIZE/128.0) ,[Uzyte (MB)] = CONVERT(DECIMAL(10,2),DF.SIZE/128.0 - ((SIZE/128.0) - CAST(FILEPROPERTY(DF.NAME, 'SPACEUSED') AS INT)/128.0)) ,[Wolne (MB)] = CONVERT(DECIMAL(10,2),DF.SIZE/128.0 - CAST(FILEPROPERTY(DF.NAME, 'SPACEUSED') AS INT)/128.0) ,[Wolne (%)] = CONVERT(DECIMAL(10,2),((DF.SIZE/128.0 - CAST(FILEPROPERTY(DF.NAME, 'SPACEUSED') AS INT)/128.0)/(DF.SIZE/128.0))*100) FROM sys.database_files DF LEFT JOIN sys.filegroups FG ON DF.data_space_id = FG.data_space_id SELECT -- s.Name AS SchemaName, t.Name AS [Tabela], p.rows AS [Ilość rekordów], CAST(ROUND((SUM(a.total_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS [Rozmiar (MB)], CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS [Uzyte (MB)], CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) AS [Wolne (MB)] FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id INNER JOIN sys.schemas s ON t.schema_id = s.schema_id GROUP BY t.Name, s.Name, p.Rows ORDER BY [Rozmiar (MB)] DESC GO

Skanowanie sieci: nmap -sn 192.168.88.0/24 Skanowanie portow TCP: nmap -sT 192.168.88.0/24 Skanowanie portow UDP: nmap -sU 192.168.88.0/24

Błąd drukowania - EPrinter Printer is not currently printing Trzeba odinstalować aktualizacje: KB3177725 - dla Windows 7, 8 KB3176493 - dla Windows 10

PCMWin.exe -cpar"Baza=pcmarket;Id=ADMIN;Haslo=admin" -NoCparErr PcmEDI.exe -cpar"Baza=pcmarket;Id=ADMIN;Haslo=admin" -NoCparErr -silent