EitanBlumin

----------------------------------------------------------------
-------- Ultimate Compression Savings Estimation Check ---------
----------------------------------------------------------------
-- Author: Eitan Blumin | https://www.eitanblumin.com
-- Create Date: 2019-12-08
-- Source: http://bit.ly/SQLCompressionEstimation
-- Full Link: https://gist.github.com/EitanBlumin/85cf620f7267b234d677f9c3027fb7ce
-- GitHub Repo: https://github.com/MadeiraData/MadeiraToolbox/blob/master/Utility%20Scripts/ultimate_compression_savings_estimation_whole_database.sql
-- Blog: https://eitanblumin.com/2020/02/18/ultimate-compression-savings-estimation-script-entire-database/
----------------------------------------------------------------

EitanBlumin

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

***********************************************************************************/
-- TODO: Rename the _NEW object names to their original names (primary key, default and check constraints)
-- TODO: Identify constraints with NOCHECK
GO
IF OBJECT_ID('tempdb..#PrintMax', 'P') IS NOT NULL DROP PROCEDURE #PrintMax;

EitanBlumin

/**************************************************************************
	Check Index Fragmentation based on Page Fullness and Fill Factor
***************************************************************************
Author: Eitan Blumin | https://www.eitanblumin.com
Version History:
	2020-10-20	Added @MaxDOP parameter, and better comments & indentation
	2020-01-07	First version

Description:
	This script was inspired by Erik Darling's blog post here:

EitanBlumin

/*
Author: Eitan Blumin | https://www.eitanblumin.com
Create Date: 2020-03-18
Description:
  This script will detect currently running sessions in your database which are running DBCC SHRINK commands.
  It will also output the name of any tables and indexes the session is currently locking.
  
  Use this query to find out what causes a SHRINK to run for too long.
  You may need to run it multiple times to "catch" the relevant info.
  Optionally, set @RunUntilCaughtLockInfo to 1 to continuously run until a session with object lock info was caught.

EitanBlumin

-------------------------------------------------------
------ Generate Clustered Index Recommendations -------
-------------------------------------------------------
-- Author: Eitan Blumin | https://www.eitanblumin.com
-- More info: https://eitanblumin.com/2019/12/30/resolving-tables-without-clustered-indexes-heaps/
-------------------------------------------------------
-- Description:
-- ------------
-- This script finds all heap tables, and "guestimates" a clustered index recommendation for each.
-- The script implements the following algorithm:

sql-williamd

############## 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\'

EitanBlumin

 ----------------------------------------------------------------------------------
 -- Author: Eitan Blumin (t: @EitanBlumin | b: eitanblumin.com)
 -- Date: 26/06/18
 -- Description:
 --		Compares server level objects and definitions as outputted by the first script (InstancePropertiesGenerateForCompare.sql).
 --
 -- Instructions:
 --		Run InstancePropertiesGenerateForCompare.sql on each server. Save output to a CSV file.
 --		Use this script ( InstancePropertiesComparison.sql ) to load the files into a table, and output any differences
 --		Don't forget to change file paths accordingly.

jpvelasco

# Adventure Works SQL Database Project Build Configuration

trigger:
- master

pool:
  vmImage: 'VS2017-Win2016'

variables:
  solution: '**/*.sln'

EitanBlumin

CREATE EVENT SESSION [TrackFailedLogins] ON SERVER 
ADD EVENT sqlserver.error_reported(
    ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.nt_username,sqlserver.database_id,sqlserver.session_id)
    WHERE (([severity]=(20) OR [severity]=(14) OR [severity]=(16)) 
    AND ([error_number]=(18056) 
    OR [error_number]=(17892) 
    OR [error_number]=(18061)
    OR [error_number]=(18452)
    OR [error_number]=(11248)
    OR [error_number]=(17806)

EitanBlumin

-- Author: Eitan Blumin (t: @EitanBlumin | b: eitanblumin.com)
-- Date: 2020-05-31
-- Last Update: 2021-04-22
-- Description: Collect T-SQL Events using an Extended Events Buffer

SET NOCOUNT ON;

DECLARE
  @SourceLinkedServer SYSNAME
, @MinimumDurationMilliSeconds BIGINT