Eitan Blumin EitanBlumin

## Parse Vulnerability Assessment Scan Json File.sql

DECLARE @j NVARCHAR(MAX)

SELECT @j = BulkColumn
FROM OPENROWSET (
BULK 'C:\Temp\vat_example_results_file.json'
, SINGLE_NCLOB) FileName

IF ISJSON(@j) = 1
	PRINT N'Imported JSON is valid'

## trello_cards_to_github_issues.ps1
param (
[Parameter(Mandatory)][string] $GitHubToken,
[Parameter(Mandatory)][string] $GitHubOwner,
[Parameter(Mandatory)][string] $GitHubRepo,
[Parameter(Mandatory)][string] $SourceTrelloJsonFile,
[string[]] $TrelloLists,
[bool] $UpdateExistingIssuesByTitle = $true,
[bool] $AddNonExistingIssues = $true,
[bool] $Logging = $true
)

## PrintMax Minified Temporary Procedure.sql
IF OBJECT_ID('tempdb..#PrintMax') IS NOT NULL DROP PROC #PrintMax;
GO
CREATE PROCEDURE #PrintMax @str NVARCHAR(MAX)
AS
BEGIN
 IF (@str IS NULL) RETURN;
 DECLARE @LBindex INT,@len INT;
 SET @len = 4000;
 WHILE (LEN(@str) > @len) BEGIN
  SET @LBindex = CHARINDEX((CHAR(10) + CHAR(13)) COLLATE database_default, REVERSE(LEFT(@str, @len)) COLLATE database_default);

## FilterParseJsonParameters.sql
/*
	Fully Parameterized Search Query
	--------------------------------

	Copyright Eitan Blumin (c) 2018; email: eitan@madeiradata.com
	You may use the contents of this SQL script or parts of it, modified or otherwise
	for any purpose that you wish (including commercial).
	Under the single condition that you include in the script
	this comment block unchanged, and the URL to the original source, which is:
	http://www.eitanblumin.com/

## Generate Procedure Unit Test with Auto-Comparison.sql

/**************************************************************************************************/
/*					Generate Procedure Unit Test with Automatic Comparison						  */
/**************************************************************************************************/
--	Author: Eitan Blumin
--	Date:	2018-11-21
--	Description: Use this script to generate and run a "unit test" for two stored procedures.
--			Each procedure is considered to be affecting one or more database tables.
--			The contents of these tables can be compared before and after each unit test,
--			and the results of each of the two stored procedures can be compared.

## Get Recent SQL Error Log Errors.sql
DECLARE @MinutesBackToCheck INT = 10;

SET NOCOUNT ON;
DECLARE @start DATETIME;
SET @start=DATEADD(MINUTE,-@MinutesBackToCheck,GETDATE());

DECLARE @errors AS TABLE
(
	ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
	LogDate DATETIME,

## Find Orphaned Records By Foreign Key.sql
/************** Find Orphaned Records **************
Author: Eitan Blumin
****************************************************/
DECLARE
	@ForeignKeyName SYSNAME = 'FK_MyTable_MyOtherTable'
	, @PrintOnly		BIT			= 0

DECLARE
	@FKId INT,
	@ChildTableID INT,

## Data Driven Alternative Email and File Share.sql
-- Based on script by Jason Selburg
-- https://www.sqlservercentral.com/Forums/Topic279460-150-1.aspx
-- http://www.sqlservercentral.com/scripts/Miscellaneous/31733/
USE ReportServer
GO

IF OBJECT_ID(N'[dbo].[data_driven_subscription]', 'P') IS NOT NULL
DROP PROCEDURE [dbo].[data_driven_subscription]
GO

## Review SQL Instance Best Practices.sql
DECLARE
	@NumOfMinutesBackToCheck INT = 360,
	@MinutesBackToCheck INT = 360,
	@DaysBackToCheck INT = 10,
	@MinAdHocSizeInMB INT = 200,
	@MinAdHocPercent INT = 25,
	@FreespaceMinimumMB INT = 1024,
	@FreespaceMinimumPercent INT = 10,
	@UnsentLogThresholdKB INT = 2048,
	@UnrestoredLogThresholdKB INT = 2048,

## Online Index Operations without Enterprise.sql
/***********************************************************************************

				Copyright: Eitan Blumin (c) 2018
	https://gist.github.com/EitanBlumin/79222fc2be5163cec828d0a69270a0ab

***********************************************************************************/
GO
IF OBJECT_ID('tempdb..#PrintMax', 'P') IS NOT NULL DROP PROCEDURE #PrintMax;
GO
-----------------------------------------------------------------------------------------------