Scripts and tips
Obtain SQL Server port
To obtain the TCP / IP port of a SQL Server database, several solutions are possible. Via a request on the server. Using the following query: SELECT DISTINCT local_tcp_port FROM sys.dm_exec_connections WHERE...
WGET and CURL on Windows
wget and curl are two programs present mainly on Linux focusing on downloading files from the command line. They have been adapted under Windows and offer the same commands as their equivalents under Linux.
Use accents in a batch file
If in a Batch file you have variables that contain accents, the system will not display them due to encoding. Using UTF-8 or ANSI will not solve the problem. So: set myFolder="c:\Pêche" Will display : To solve this...
Delete a file with a long filename
If you have a problem deleting a file or a group of files, you may get the following message: "The source file name(s) are larger than is supported by the file system", like in the capture below: Solution 1. Here is...
Avoid too large MySQL logs
You can quickly have your hard drive flooded with files mysql-bin.xxxxxx (mysql-bin.000001...). These files are MySQL logs which trace all the modifications to the database.It is best to disable them by modifying...
| ← Previous page | Page 4/4 |
Search in this website
  |  RSS |  Informations |