Goal: open command prompt in a folder 1. By mouse right click – open the folder in the windows explorer – hold the shift + right click – in the context menu you will see a new option: Open command window here [ or in windows 10 Open PowerShell window here ] 2. type cmd […]
open command prompt in the actual folder
7:18 |
windows |
716 views
disable CompatTelRunner.exe – Microsoft Compatibility Telemetry
7:10 |
windows |
826 views
The problem is given, this exe consuming a lot of resources. Let’s disable it in the Task Scheduler 1. WIN + R 2. taskschd.msc 3. on the left find the route Task Scheduler Library > Microsoft > Windows 4. click on Application Experience tag 5. check the middle of the window, we are looking for […]
The problem is given, this exe consuming a lot of resources. Let’s disable it in the Task Scheduler 1. WIN + R 2. taskschd.msc 3. on the left find the route Task Scheduler Library > Microsoft > Windows 4. click on Application Experience tag 5. check the middle of the window, we are looking for […]
print or save to pdf div content
16:01 |
tricky |
785 views
Sometimes we need only a part of a web page to print or to save to pdf. Here is a simple solution: add these lines to the page stylesheet where the #content is the id of the target DIV.
Sometimes we need only a part of a web page to print or to save to pdf. Here is a simple solution: add these lines to the page stylesheet where the #content is the id of the target DIV.
get the jQuery version number
18:48 |
jquery |
825 views
Simple way to get the jQuery version number put this into the console window
Simple way to get the jQuery version number put this into the console window
update semi-incremental column
15:16 |
mssql |
953 views
To add incremental numbers into a column (not an auto increment column) is easy with a stored procedure but we can use a simple update also. done.
To add incremental numbers into a column (not an auto increment column) is easy with a stored procedure but we can use a simple update also. done.
isset short way
18:45 |
php |
858 views
How we can check if variable is defined or if not than get a default value? The general answer is isset and ternary operator let’s simplify this! or after PHP 7.0.1 you can use this shorter way
How we can check if variable is defined or if not than get a default value? The general answer is isset and ternary operator let’s simplify this! or after PHP 7.0.1 you can use this shorter way
mssql – custom start value for identity column
20:55 |
mssql |
869 views
You can give an initial value for the identity column when you are creating the new table. If you want an identity column which one is starts from zero If the table already created you can override the identity column startValue with the following command: where the tableName is the target table name startValue is […]
You can give an initial value for the identity column when you are creating the new table. If you want an identity column which one is starts from zero If the table already created you can override the identity column startValue with the following command: where the tableName is the target table name startValue is […]
Excel – insert current date – [ ctrl+; ] not working
20:14 |
excel, tricky |
966 views
Goal: sometimes the current date insert not working. Find a way to solve this I don’t know why and how but sometimes the ctrl + ; stopping to work. I tried to find solution. Many of forums suggest to reinstall the whole office package… Nope… or delete the normal.dot template… nope… or just start the […]
Goal: sometimes the current date insert not working. Find a way to solve this I don’t know why and how but sometimes the ctrl + ; stopping to work. I tried to find solution. Many of forums suggest to reinstall the whole office package… Nope… or delete the normal.dot template… nope… or just start the […]
javascript – Convert NodeList to Array
0:57 |
javascript |
1030 views
Goal: work with nodeList as an array The nodeList is great but sometime we need to convert it to an array for the easy processing. old method old method – short form ES6 way – shorter form ES6 way – the shortest form enjoy… One more thing is a little bit strange. Check the speed […]
Goal: work with nodeList as an array The nodeList is great but sometime we need to convert it to an array for the easy processing. old method old method – short form ES6 way – shorter form ES6 way – the shortest form enjoy… One more thing is a little bit strange. Check the speed […]
mysql date range creation
11:36 |
database, mysql |
1038 views
Goal: create a date range Simple question to create a date range from a start date to an end date. 1. date dimension table – previously created range Simple, let’s create a date dimension table filled up with the days from a specified day to the future(?). This is a very dangerous if we forget […]
Goal: create a date range Simple question to create a date range from a start date to an end date. 1. date dimension table – previously created range Simple, let’s create a date dimension table filled up with the days from a specified day to the future(?). This is a very dangerous if we forget […]