GWalkey gwalkey

💭

SQL, Powershell, MongoDB, Azure, Performance Junkie

LitKnd / Swapping-In-Tables-With-Switch-Partition.sql

Last active August 4, 2023 15:35

	/* Note: don't run this all at once. There are prompts to run some queries in another session, etc. */

	WHILE @@trancount > 0
	ROLLBACK
	GO

	USE master;
	GO

	IF DB_ID('lockingtest') IS NOT NULL

jasmin-mistry / Create-SSRS_Subscription.ps1

Created July 12, 2016 09:17


	[string]$server = 'localhost'
	[string]$serverurl = "http://$server/ReportServer_SQL2014"

	$proxy = $null

	# namespace parameter only works for 2010 and not for 2005 but if you get the type after setting up proxy then both works

	$proxy += New-WebServiceProxy -Uri "$serverurl/ReportService2010.asmx" -UseDefaultCredential ; #-Namespace SSRS.ReportingService2010