akramarev

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE 
	database_id  = db_id('DBUser')
	AND login_name IN ('DBTest', 'DBServices')

EXEC(@kill);

akramarev

git config --global core.preloadindex true
git config --global core.fscache true
git config --global gc.auto 256

akramarev

DECLARE @Name NVARCHAR(776) = NULL;

EXEC sys.sp_rename 'dbo.MyUDT', 'zMyUDT';
GO

CREATE TYPE [dbo].[MyUDT] AS TABLE
(
[HierarchyId] [int] NOT NULL
)
GO

akramarev

Get-ChildItem | Where-Object { $_.PSIsContainer } | ForEach-Object { $_.Name + ": " + "{0:N2}" -f ((Get-ChildItem $_ -Recurse | Measure-Object Length -Sum -ErrorAction SilentlyContinue).Sum / 1MB) + " MB" }

akramarev

wget -qO- https://get.docker.io/gpg | sudo apt-key add -
sudo sh -c "echo deb http://get.docker.io/ubuntu docker main > /etc/apt/sources.list.d/docker.list"
sudo apt-get update
sudo apt-get install lxc-docker