Sayham Chowdhury sayham-sjb

List all modified file names
- git whatchanged --since '12/01/2016' --oneline --name-only --pretty=format: | sort | uniq
- git log --since="4 day ago" --name-only --pretty=format: | sort -u
- git whatchanged --since '12/01/2016' --until '12/06/2016' --oneline --name-only --pretty=format: | sort | uniq
Stash
- git stash
- git stash list (Get all stash(s))
- git stash pop (Reapply stash and remove)
git stash apply (Reapply stash and keep copy)

	function HumanDogYears(form) {
	var HumanYears = form.inYears.value;
	if (HumanYears >= 21) {
	dy = (HumanYears - 21) / 4 + 2;
	} else {
	dy = HumanYears / 10.5;
	}
	var hdy = 0;
	if (HumanYears >= 2) {
	hdy = 21 + ((HumanYears - 2) * 4);


	USE {PublicationDatabaseName}
	GO
	EXEC sp_droppublication @publication = N'<Publication name>'

	USE master
	GO
	EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

	SELECT publisher_db, COUNT(1) FROM distribution.dbo.MSarticles
	GROUP BY publisher_db
	ORDER BY COUNT(1), publisher_db

	<center><div style="padding-right: 74px;">
	<a href="https://twitter.com/sayham28" class="twitter-follow-button" data-size="large" data-show-count="false">Follow @sayham28</a><script async charset="utf-8"></script></div></center>

	USE master
	SELECT * FROM msdb.dbo.restorehistory WHERE destination_database_name LIKE '%DBNm%' ORDER BY restore_date DESC

	PRINT 'Backing Up DBName'
	BACKUP DATABASE {DBName} TO DISK = 'D:\BackupFolder\DBName_Restore.bak';