sayham-sjb

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'

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)

sayham-sjb

<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>

sayham-sjb

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

sayham-sjb

     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);

sayham-sjb

--Check for Replication
EXECUTE sys.sp_helpreplicationdb @dbname = {DBName}, -- sysname
                                 @type = pub    -- sysname

sayham-sjb

USE master
GO
DECLARE @kill varchar(max) = '';
SELECT @kill = @kill + 'KILL ' + CONVERT(varchar(10), spid) + '; '
FROM master..sysprocesses 
WHERE spid > 50 AND dbid = DB_ID('DATABASENAME')
EXEC(@kill);

GO
SET DEADLOCK_PRIORITY HIGH

sayham-sjb

--Set offline and rollback
ALTER DATABASE {DBName} SET OFFLINE WITH ROLLBACK IMMEDIATE

--Then SET it online
ALTER DATABASE {DBName} SET ONLINE

sayham-sjb

function chrCntMtd(what) {
        var FormCntChrWrd = what.form.chrCntTxt.value;
        what.form.disChrCnt.value = FormCntChrWrd.length;
    }

sayham-sjb

/*!
 * jQuery JavaScript Library v1.4.2
 * http://jquery.com/
 *
 * Copyright 2010, John Resig
 * Dual licensed under the MIT or GPL Version 2 licenses.
 * http://jquery.org/license
 *
 * Includes Sizzle.js
 * http://sizzlejs.com/