Source code control of programmatic and other objects for MS SQL server

Простой вариант контроля кода для ms sql:
Source code control of programmatic and other objects for MS SQL server

Ansible task to create vm snapshot on ESXi host without vCenter

- hosts: localhost
   tasks:
   - name: Create snapshot
     vmware_guest_snapshot:
       datacenter: esx15
       hostname: esx15.domain.local
       username: uname
       password: upass
       validate_certs: false
       name: GuestMachineName
       folder: /
       state: present
       snapshot_name: snapName
       memory_dump: false
       description: snapDescription
     delegate_to: localhost

Ansible Docs

Repair MS SQL after upgrade crash(2008 to 2014)

ERROR: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.backupset' and the index name 'backupsetMediaSetId'. The duplicate key value is (

1. Run ms sql with trace flag:
   sqlservr.exe -sServerName -T 902
2. Connect to ServerName over sql client and manual change data. Find you error script in update scripts. Typycaly path to update script is "C:\Program Files\Microsoft SQL Server\MSSQL12.EVMVC\MSSQL\Install"