Kevin-Bronsdijk

Import-Module SQLPS -DisableNameChecking

#replace this with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

$dbName = "DatabaseName"

$db = $srv.Databases.Item($dbName)
# Stops the all processes on the specified database.

Kevin-Bronsdijk

# Prerequisites
# Not required for Windows Server 2012

# Custom pre-installation scripts 

# Create Directories before running setup!
MD "X:\Program Files\Microsoft SQL Server"
MD "X:\Program Files (x86)\Microsoft SQL Server"

# Setup

Kevin-Bronsdijk

Gather SMO exception details
function SmoException
{
    $err = $_.Exception
    while ( $err.InnerException )
    {
        $err = $err.InnerException;
    };
    Write-Host $err.Message;
}

Kevin-Bronsdijk

#Gather SMO exception details
function SmoException
{
    $err = $_.Exception
    while ( $err.InnerException )
    {
        $err = $err.InnerException;
    };
    Write-Host $err.Message;
}

Kevin-Bronsdijk

Import-Module SQLPS -DisableNameChecking

#replace your with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

Kevin-Bronsdijk

Configuration MyName {
Node NameOfTheSystem {
#your instructions
}
}

Kevin-Bronsdijk

Import-Module SQLPS -DisableNameChecking

#replace your with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

#replace your with your user database name
$dbName = "name_user_db"
$db = $srv.Databases[$dbName]

Kevin-Bronsdijk

$instanceName = "!instanceName"
$databaseName = "!databaseName"

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

function ScriptObject($subject, $scripter)
{
   if ($subject.IsSystemObject -eq $false)
   {

Kevin-Bronsdijk

Import-Module SQLPS -DisableNameChecking

#replace your with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

Kevin-Bronsdijk

#Win Config
Install-WindowsUpdate -AcceptEula
Update-ExecutionPolicy Unrestricted
Set-ExplorerOptions -showHiddenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
Enable-RemoteDesktop

#Base Apps
choco install 7zip.commandline
choco install 7zip.install
choco install dropbox