Raimund Andrée [MSFT] raandree

## DscAppPoolRecyclingIssue.ps1
$pullServer = Get-LabVM -Role DSCPullServer
$sqlServer = Get-LabVM -Role SQLServer2016

$before = Invoke-LabCommand -ActivityName 'Get Row Count' -ComputerName $sqlServer -ScriptBlock {
    Invoke-Sqlcmd -Database DSC -Query "SELECT COUNT(*) AS Count FROM StatusReport"
} -PassThru

Invoke-LabCommand -ActivityName 'Backup DSC Database' -ComputerName $sqlServer -ScriptBlock {
    mkdir C:\SQLBackups -Force
    $backupCmd = "BACKUP DATABASE [DSC] TO  DISK = N'C:\SQLBackups\DSC {0:yyMMdd-hhmmss}.bak' WITH NOFORMAT, NOINIT,  NAME = N'DSC-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10" -f (Get-Date)

## Show-Tree.ps1
using namespace System.Collections.Generic
function Show-Tree
{
# .SYNOPSIS

#     Print a tree given a key property and parent property
#
# .PARAMETER InputObject
#
#     The object to print.

## DSC Pull Scenario 1 with SQL Server.ps1
throw "NotImplementedYet"
	$pullServer = Get-LabVM -Role DSCPullServer
	$sqlServer = Get-LabVM -Role SQLServer2016

	$before = Invoke-LabCommand -ActivityName 'Get Row Count' -ComputerName $sqlServer -ScriptBlock {
	Invoke-Sqlcmd -Database DSC -Query "SELECT COUNT(*) AS Count FROM StatusReport"
	} -PassThru

	Invoke-LabCommand -ActivityName 'Backup DSC Database' -ComputerName $sqlServer -ScriptBlock {
	mkdir C:\SQLBackups -Force
	$backupCmd = "BACKUP DATABASE [DSC] TO DISK = N'C:\SQLBackups\DSC {0:yyMMdd-hhmmss}.bak' WITH NOFORMAT, NOINIT, NAME = N'DSC-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10" -f (Get-Date)
	using namespace System.Collections.Generic
	function Show-Tree
	{
	# .SYNOPSIS

	# Print a tree given a key property and parent property
	#
	# .PARAMETER InputObject
	#
	# The object to print.