Eitan Blumin EitanBlumin
🕵️♂️
EitanBlumin
/ SQLDatabaseYAMLBuildConfiguration.yml
Last active
May 8, 2022 08:20
— forked from jpvelasco/SQLDatabaseYAMLBuildConfiguration.yml
SQL YAML Build Configuration for Azure Pipelines
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # SQL Database Project Build Configuration | |
| trigger: | |
| - master | |
| pool: | |
| vmImage: 'VS2017-Win2016' | |
| variables: | |
| solution: '**/*.sln' |
EitanBlumin
/ sp_DBPermissions.sql
Last active
August 20, 2021 17:51
— forked from sqlstudent144/sp_DBPermissions.sql
sp_DBPermissions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF OBJECT_ID('tempdb..#sp_DBPermissions') IS NOT NULL DROP PROCEDURE #sp_DBPermissions | |
| GO | |
| /********************************************************************************************* | |
| sp_DBPermissions V6.1 | |
| Kenneth Fisher | |
| http://www.sqlstudies.com | |
| https://github.com/sqlstudent144/SQL-Server-Scripts/blob/master/sp_DBPermissions.sql | |
| This stored procedure returns 3 data sets. The first dataset is the list of database |
EitanBlumin
/ sp_SrvPermissions.sql
Last active
May 5, 2021 19:29
— forked from sqlstudent144/sp_SrvPermissions.sql
sp_SrvPermissions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF OBJECT_ID('#sp_SrvPermissions') IS NOT NULL DROP PROCEDURE #sp_SrvPermissions | |
| GO | |
| /********************************************************************************************* | |
| sp_SrvPermissions V6.1 | |
| Kenneth Fisher | |
| http://www.sqlstudies.com | |
| https://github.com/sqlstudent144/SQL-Server-Scripts/blob/master/sp_SrvPermissions.sql | |
| This stored procedure returns 3 data sets. The first dataset is the list of server |
EitanBlumin
/ Relocate AG Database Files.ps1
Created
January 14, 2021 14:38
— forked from sql-williamd/Relocate AG Database Files.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ############## Setup ############## | |
| $AGName = '' | |
| $AGPrimary = '' | |
| $AGSecondary = '' | |
| # This allows you to process just a subset of databases using the name (wildcards are possible) | |
| $DBNamePattern = 'AdventureW*' | |
| $TargetFolder = 'K:\Data\' |