-
![]()
How to select first row in each group ordered by some columns
I'm just gonna show you an example how to select first row in each group of logins ordered by IsActive and Created columns, hope you will realise how it works. For example i have a table: Id | Login | IsActive | Created 1 | test1 | 1 | 2016-01-01 2 | test1… -
![]()
Automate your work on Mac
Hello! I always wanted to use my macbook more effectively and do more tasks then I do right now. And I have found how to make it possible! Automator You already have this program on your Mac, no need to install something, just type Automator in search and use it ;) So, you can automate… -
![]()
Adding Resharper Code Quality Analysis to TFS/VSTS
To improve code qulaity of your project is't good to check every build with some analyzing tool such as Resharper Code Quality Analysis. Install Resharper Code Quality Analysis Now you have to add additional step to the build definition of your project after build step, like this: Then you need to set "Path to .sln… -
![]()
Allow ssh password authentication on remote server
1. Connect to the server and check ssh properties: sudo nano /etc/ssh/sshd_config # Change to no to disable tunnelled clear text passwords PasswordAuthentication yes PasswordAuthentication should be set to yes. 2. Now restart ssh service: service ssh restart 3. Try to make ssh connection with authentication by password: ssh username@domain Don't forget to replace username and domain… -
![]()
Create admin user in ubuntu linux
1. Login as super user: sudo su 2. Run the following command: adduser username Don't forget to replace username with the name of user that you want to create. 3. Add the user to the sudo group: usermod -aG sudo username 4. Switch to the new user: su username 5. Check that new user has admin rights:… -
![]()
Reset password and give admin rights to redmine account
First of all run mysql: mysql --user=root --password=your_password You can find your connection parameters in {your redmine folder}/htdocs/config/database If credentials are correct you will see hello message from MySql console: Now you need to reveal all databases on current mysql server, run this command: SHOW DATABASES; You will see something like this: We need to… -
![]()
How to generate and copy SSH key in Mac OS
Generate SSH key First of all, open terminal window. I personally use iTerm2. To generate SSH keys , enter the following command in the Terminal window: ssh-keygen -t rsa You will need to answer some questions during ssh key generation process. Left destination as Default, other questions answer as you want. Copy SSH key to… -
![]()
Compare Azure virtual machine pricing across different regions
Sometimes it doesn't matter where to place virtual machine, so you just need to find the best price. I prefer to use Microsoft Azure for my projects, so I can place VM in various number of places. Price for the same VM differ across regions and it's usually a headache to find out what region… -
![]()
Migrate from tfs to git
First of all download git-tfs from there: http://git-tfs.com Right click on My Computer -> Properties -> Advanced system settings -> Environment variables -> System variables -> Path Add ;C:\TfsMigration\GitTfs-0.25.1 to the end of Path variable. Open Command Prompt as Administrator and exec following commands, don't forget to change commands with your variables: git tfs clone http://myserver:8080/tfs/DefaultCollection… -
![]()
Highlight overdue issues in redmine
To higlight overdue issues in redmine, add following styles to your application.css file: tr.issue.overdue td.id a, tr.issue.overdue td.subject a, .issue.overdue td.due-date { color: #f00; } tr.private td.subject a:before { content: ''; display: inline-block; margin: 0 3px 0 -5px; height: 11px; vertical-align: middle; border-left: 2px solid #d22; border-right: 1px solid #d22; } Original article: http://www.redmine.org/issues/20812
Loading posts...
