potatoqualitee

# No longer used but didn't want to throw it away.
function Invoke-WsusDbQuery {
    [CmdletBinding()]
    param (
        [string]$ComputerName = $script:WsusServer,
        [PSCredential]$Credential = $script:WsusServerCredential,
        [string]$Pattern,
        [string]$UpdateId,
        [switch]$EnableException
    )

potatoqualitee

function Save-KBFile {
    <#
    .SYNOPSIS
        Downloads patches from Microsoft

    .DESCRIPTION
         Downloads patches from Microsoft

    .PARAMETER Name
        The KB name or number. For example, KB4057119 or 4057119.

potatoqualitee

Set-Content -Encoding UTF8 -Path C:\github\dbatools\allcommands.ps1 -Value "### DO NOT EDIT THIS FILE DIRECTLY ###"
Get-ChildItem -Path "C:\github\dbatools\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1
Get-ChildItem -Path "C:\github\dbatools\internal\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1

Remove-Item -Recurse C:\gallery -Force
mkdir C:\gallery\dbatools
robocopy c:\github\dbatools C:\gallery\dbatools /S /XF *.psproj* *.git* *.yml /XD .git .github Tests .vscode | Out-String | Out-Null

Remove-Item -Recurse C:\gallery\dbatools\bin\build -ErrorAction Ignore
Remove-Item -Recurse C:\gallery\dbatools\bin\projects -ErrorAction Ignore

potatoqualitee

{
    "Name": "AdventureWorks2014",
    "Tables": [
        {
            "Name": "Employee",
            "Schema": "HumanResources",
            "Columns": [
                {
                    "Name": "NationalIDNumber",
                    "ColumnType": "nvarchar",

potatoqualitee

{
    "Name": "AdventureWorks2014",
    "Tables": [
        {
            "Name": "AWBuildVersion",
            "Schema": "dbo",
            "Columns": [
                {
                    "Name": "Database Version",
                    "ColumnType": "nvarchar",

potatoqualitee

Set-Content -Encoding UTF8 -Path C:\github\dbatools\allcommands.ps1 -Value "### DO NOT EDIT THIS FILE DIRECTLY ###"
Get-ChildItem -Path "C:\github\dbatools\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1
Get-ChildItem -Path "C:\github\dbatools\internal\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1

Remove-Item -Path C:\github\dbatools\allcommands.zip -ErrorAction Ignore
Compress-Archive -Path C:\github\dbatools\allcommands.ps1 -DestinationPath C:\github\dbatools\allcommands.zip
Remove-Item -Recurse C:\github\dbatools\allcommands.ps1 -ErrorAction Ignore

Remove-Item -Recurse C:\gallery -Force
mkdir C:\gallery\dbatools

potatoqualitee

{
  "name": "search",
  "displayName": "dbatools simple search",
  "description": "search right from your code: dbatools, microsoft docs and google",
  "version": "1.0.0",
  "icon": "resources/search.png",
  "publisher": "dbatools",
  "engines": {
    "vscode": "^1.11.0"
  },

potatoqualitee

'
' USAGE:
'
' cscript filestream_enable.vbs [/Machine:<MachineName>] [/Instance:<InstanceName>] [/Level:<0|1|2|3>] [/Share:<ShareName>]
' from the codeplex site https://archive.codeplex.com/?p=sqlsrvengine
'

InstanceName = "MSSQLSERVER"
MachineName = "."
TargetLevel = 3

potatoqualitee

# from https://hic.dundee.ac.uk/Installers/RDMP/2.7.3.1/RDMPAutomationService/Microsoft.SqlServer.SqlEnum.xml
<doc>
    <assembly>
        <name>Microsoft.SqlServer.SqlEnum</name>
    </assembly>
    <members>
        <member name="P:Microsoft.SqlServer.Management.Smo.AvailableSQLServers.ResultTypes">
            <summary>
return what types of results does this object support
</summary>

potatoqualitee

function Get-Header ($text) {
    $start = $text.IndexOf('<#')
    $text.SubString(0, $start - 2)
}

function Format-Help ($text) {
    $start = $text.IndexOf('<#')
    $end = $text.IndexOf('#>')
    $help = $text.SubString($start + 2, $end - $start - 2)