mattmc3

DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"

mattmc3

gpg --recipient "{{first}}" --recipient "{{second}}" --output file.txt.pgp --armor=ascii --encrypt file.txt

mattmc3

select object_id(quotename(isc.TABLE_SCHEMA) + '.' + quotename(isc.TABLE_NAME)) as MSSQL_OBJECT_ID
     , isc.TABLE_CATALOG
     , isc.TABLE_SCHEMA
     , isc.TABLE_NAME
     , columnproperty(object_id(quotename(isc.TABLE_SCHEMA) + '.' + quotename(isc.TABLE_NAME)), isc.column_name, 'ColumnId') as MSSQL_COLUMN_ID
     , quotename(isc.table_schema) + '.' + quotename(isc.table_name) as FULL_TABLE_NAME
     , isc.COLUMN_NAME
     , isc.ORDINAL_POSITION
     , isc.DATA_TYPE
     , case when isc.DATA_TYPE in ('binary', 'char', 'nchar', 'nvarchar', 'varbinary', 'varchar')

mattmc3

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

mattmc3

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

mattmc3

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

mattmc3

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

mattmc3

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

mattmc3

https://help.github.com/articles/changing-author-info/

Step 1

Open Terminal.

Step 2

Create a fresh, bare clone of your repository:

git clone --bare https://github.com/user/repo.git

mattmc3

#!/usr/bin/env python
# -*- coding: utf-8 -*-

"""
DOCSTRING
"""

from __future__ import print_function
from __future__ import unicode_literals
from __future__ import division