Open Terminal.
Create a fresh, bare clone of your repository:
git clone --bare https://github.com/user/repo.git
find . -depth -name "{{old}}" -type d -execdir bash -c 'mv {} {{new}}' \; |
python3 -m venv ~/.virtualenvs/my-venv |
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )" |
gpg --recipient "{{first}}" --recipient "{{second}}" --output file.txt.pgp --armor=ascii --encrypt file.txt |
select | |
* | |
,quotename(t.column_name) + ' ' | |
+ | |
case | |
when t.computed_column_definition is not null then 'as ' + t.computed_column_definition | |
else | |
quotename(t.data_type) | |
+ | |
case |
-- http://dba.stackexchange.com/questions/6996/how-do-i-truncate-the-transaction-log-in-a-sql-server-2008-database | |
ALTER DATABASE {{db}} SET RECOVERY SIMPLE | |
go | |
SELECT name | |
FROM sys.master_files | |
WHERE database_id = DB_ID('{{db}}') | |
go |
exec sp_configure 'show advanced options', 1; | |
go | |
reconfigure; | |
go | |
sp_configure 'clr enabled', 1; | |
go | |
reconfigure; | |
go | |
sp_configure 'show advanced options', 0; | |
go |
exec sp_configure 'show advanced options',1; | |
go | |
reconfigure; | |
go | |
sp_configure 'Ole Automation Procedures', 1; | |
go | |
reconfigure; | |
go | |
sp_configure 'show advanced options', 0; | |
go |
-- https://blogs.msdn.microsoft.com/psssql/2010/12/29/tracking-database-recovery-progress-using-information-from-dmv/ | |
USE Sandbox | |
GO | |
DROP TABLE [dbo].[tbl_recovery_tracking] | |
GO | |
DROP TABLE [dbo].[tbl_dm_tran_database_transactions] | |
GO | |
CREATE TABLE [dbo].[tbl_recovery_tracking]( | |
[runtime] [datetime] NOT NULL, | |
[command] [nvarchar](256) NOT NULL, |
Open Terminal.
Create a fresh, bare clone of your repository:
git clone --bare https://github.com/user/repo.git