AshFlaw

kill <SPID>
USE [master]
ALTER DATABASE <DBName>
SET MULTI_USER
GO

AshFlaw

$server = ""
$app = Get-WmiObject -Class Win32_Product -computer $server | Where-Object {$_.Name -match "Microsoft Monitoring Agent"}
$app.Uninstall()

AshFlaw

$Instance = ""
Set-DbaDatabaseOwner -SqlServer $Instance
Remove-SqlOrphanUser -SqlServer $Instance
Set-DbaQueryStoreConfig -SqlServer $Instance `
                        -State ReadWrite `
                        -FlushInterval 600 `
                        -CollectionInterval 10 `
                        -MaxSize 100 `
                        -CaptureMode All `
                        -CleanupMode Auto `

AshFlaw

USE UserIPAudit
GO
CREATE TRIGGER LogonTrigger ON ALL SERVER FOR LOGON
AS
BEGIN
   DECLARE @data XML
   SET @data = EVENTDATA()

   INSERT INTO UserIPAudit.dbo.[UserIPLog]
     (

AshFlaw

CREATE DATABASE UserIPAudit
GO

USE UserIPAudit
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON

AshFlaw

$ErrorActionPreference = "Continue"
$computers = Get-ADComputer -Filter 'ObjectClass -eq "Computer"' | Select-Object -Expand DNSHostName

Function DisableDefrag 
{
    If ((Get-ScheduledTask -TaskName 'ScheduledDefrag').State -eq 'Ready') 
    {
        Disable-ScheduledTask -TaskName 'ScheduledDefrag' -TaskPath '\Microsoft\Windows\Defrag'
        Write-Output "$env:computername Scheduled defrag disabled"
    }

AshFlaw

Function Install-EXE 
{
  Param 
  (
    $Command
  )
    $processID = (Invoke-WmiMethod -class Win32_process -name Create -ArgumentList $Command -ErrorAction Stop).processid
    Wait-Process -Id $processID
}

AshFlaw

$ServiceName = "MsDtsServer130" #SQL 2016 SSIS Service Name
$SSIS_Service = Get-WmiObject win32_service | where-object {$_.Name -eq $ServiceName}
If ($SSIS_Service -ne $null)
{
    $SSIS_AppDesc = "Microsoft " + (Get-Service $ServiceName).DisplayName # Add the prefix which is not present in the service description
    $SSISAccount = $SSIS_Service.StartName.Split("\")
    $user = $SSISAccount[1]
    $domain = $SSISAccount[0]
    $appdesc = $SSIS_AppDesc
    $app = get-wmiobject -query ('SELECT * FROM Win32_DCOMApplicationSetting WHERE Description = "' + $appdesc + '"') -enableallprivileges

AshFlaw

Get-ADPrincipalGroupMembership username | select name

AshFlaw

function Test-SQLTableExists
{ 
    param ($Instance,$Database,$TableName)
    $Return = $SQL = $dataTable = $null
    $sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'$TableName'"
    $dataTable = Invoke-Sqlcmd2 -ServerInstance $Instance -Database $Database -Query $sql
    if ($dataTable) {$return = $true}
    else {$return = $false}
    $Return
}