JayHollingum

## extended-event-queries-completed.sql
IF EXISTS (select * fROM sys.dm_xe_sessions where name = 'QueriesCompleted')
BEGIN
	DROP EVENT SESSION [QueriesCompleted] ON SERVER
END
GO

CREATE EVENT SESSION [QueriesCompleted] ON SERVER
ADD EVENT sqlserver.rpc_completed(
    ACTION(
		sqlserver.client_app_name,

## alter-encoding.ps
Get-ChildItem -Path C:\some-dir\* -Include *.ext -Recurse | ForEach-Object {
	$content = Get-Content $_.FullName
	$content | Out-File -Encoding UTF8NoBOM $_.FullName
	#write-host "Encoding changed:" $_.FullName
}

## git-merge-all-their-changes
git merge -Xtheirs branch-to-merge

## bulk-move-to-sub-directory
git mv -k * ./dir-to-move-to

## git remove files with specific extension
git rm -r '*.ext'

## sql-server-edition-version.sql
select
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition,
	create_date AS 'SQLServerInstallDate',
	case
		when CAST(SERVERPROPERTY('Edition') as nvarchar(100)) like '% evaluation %' then
			DATEADD(day, 180, create_date) --evaluation periods for 180 days
		else
			''

## self-signed-cert.ps1
New-SelfSignedCertificate -FriendlyName "FTP Server" -CertStoreLocation cert:\localmachine\my -DnsName name.of.machine.com

## sql-server-db-list-state-recovery-mode.sql
use [master]
select
	db.name,
	db.state_desc,
	db.recovery_model_desc
from
	sys.databases db
where
	db.name not in ('master','tempdb','model','msdb')

## sql-server-list-db-log-files-output-simple-mode-and-shrink.sql
select
	db.name,
	db.state_desc,
	db.recovery_model_desc,
	mf.type_desc,
	mf.physical_name,
	(mf.size * 8)/1024 as SizeMB,
	'USE [master]; ALTER DATABASE [' + db.name + '] SET RECOVERY SIMPLE WITH NO_WAIT; USE [' + db.name + ']; DBCC SHRINKFILE (N''' + mf.name + ''' , 0, TRUNCATEONLY);' as SQLOutput
from
	sys.databases db

## gist:7a61430929bfb822eef59dea08d444e7
<PropertyGroup>
  <UseRazorSourceGenerator>false</UseRazorSourceGenerator>
</PropertyGroup>
	IF EXISTS (select * fROM sys.dm_xe_sessions where name = 'QueriesCompleted')
	BEGIN
	DROP EVENT SESSION [QueriesCompleted] ON SERVER
	END
	GO

	CREATE EVENT SESSION [QueriesCompleted] ON SERVER
	ADD EVENT sqlserver.rpc_completed(
	ACTION(
	sqlserver.client_app_name,
	Get-ChildItem -Path C:\some-dir\* -Include *.ext -Recurse \| ForEach-Object {
	$content = Get-Content $_.FullName
	$content \| Out-File -Encoding UTF8NoBOM $_.FullName
	#write-host "Encoding changed:" $_.FullName
	}
	select
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition,
	create_date AS 'SQLServerInstallDate',
	case
	when CAST(SERVERPROPERTY('Edition') as nvarchar(100)) like '% evaluation %' then
	DATEADD(day, 180, create_date) --evaluation periods for 180 days
	else
	''
	use [master]
	select
	db.name,
	db.state_desc,
	db.recovery_model_desc
	from
	sys.databases db
	where
	db.name not in ('master','tempdb','model','msdb')
	<PropertyGroup>
	<UseRazorSourceGenerator>false</UseRazorSourceGenerator>
	</PropertyGroup>