Blog

Sql Server Tutorials

How to add audit trigger on a list of tables

For audit purpose you may be requested to add ModifyDate and ModifyBy columns for all your tables and create an audit trigger to automatically update that columns as soon as record was updated or inserted. It is very easy to implement when you have one or two tables, but with 20-30 tables it may tak…

Read More
Git Tutorials

Most useful Git commands. Git tips

Over the last few years working with Git source control system, I found a number of useful git commands which helped me a lot to solve non-trivial tasks related to Git source control system. I don't use this tips every day, usually it's only one or two time I used them in total, but knowing those gi…

Read More
Git Tutorials

View changes before commit in Git

Usually before committing changes in Git developer verify one last time all changes he did. Normally we use git difftool command in order to do it. In that case git will ask you a question if you want to see changes before opening each file. When the number of changed files are big or when different…

Read More
Git Tutorials

How to create branch from tag name in Git

Usually after deployment to production environment a new tag created in git marking successful production deployment, so later when working on defects it would be much easy to investigate any issues, having the same code as deployed to production. The best way to work with git tags is to create a ne…

Read More
Yaplex - Freelance developer - white logo on black background

Yaplex is a custom software development company co-founded by full-stack .NET Software developer Alex Shapovalov who lives in Mississauga, ON and provides software development services in Mississauga and GTA.

Contact Information

Mississauga, ON, Canada
Phone: +1 647 328 3809
Email: alex@yaplex.com