Import-Module SQLPS -DisableNameChecking

#out of the box, the SQLBrowser is disabled. To enable:
Set-Service SQLBrowser -StartupType Automatic

#sql browser must be installed and running for us
#to discover SQL Server instances
Start-Service "SQLBrowser"

$instanceName = "localhost"
$managedComputer = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $instanceName

#list server instances
$managedComputer.ServerInstances

Import-Module SQLPS -DisableNameChecking

#you can replace localhost with your instance name
$instanceName = "localhost"
$managedComputer = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $instanceName

#list services
$managedComputer.Services |
Select-Object Name, Type, ServiceState, DisplayName |
Format-Table -AutoSize

$verbosepreference = "Continue"
$services = @("SQLBrowser", "ReportServer")
$hostName = "localhost"

$services |
ForEach-Object {
   $service = Get-Service -Name $_
   if($service.Status -eq "Stopped")
   {
      Write-Verbose "Starting $($service.Name) ...."
      Start-Service -Name $service.Name
   }
   else
   {
      Write-Verbose "Stopping $($service.Name) ...."
      Stop-Service -Name $service.Name
   }
}
$verbosepreference = "SilentlyContinue"

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

#Explore: get all properties available for a server object
#see http://msdn.microsoft.com/en-us/library/ms212724.aspx

$server |
Get-Member |
Where-Object MemberType -eq "Property"

#The Information class lists nonconfigurable
#instance settings, like BuildNumber,
#OSVersion, ProductLevel etc...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

<#
run value vs config value
config_value," is what the setting has been set to (but may or may not be what SQL Server is actually running now. Some settings don't go into effect until SQL Server has been restarted, or until the RECONFIGURE WITH...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

#replace this with your instance name
$instanceName = "localhost"
$server = New-Object -TypeName Microsoft.SqlServer...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

#replace this with your instance name
$instanceName = "localhost"
$server...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

#database TestDB with default settings
#assumption is that this database does not yet exist
$dbName = "TestDB"
$db = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Database($server, $dbName)
$db.Create()...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

#database
$dbName = "TestDB"

#we are going to assume db exists
$db = $server.Databases[$dbName...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

$dbName = "TestDB"

#need to check if database exists, and if it does, drop it
$db = $server.Databases[$dbName]
if ($db)
{
      #we will use KillDatabase instead of Drop
      #Kill database will drop active connections before
      #dropping the database
      $server.KillDatabase($dbName)
}

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

#create database handle
$dbName = "TestDB"
$db = $server.Databases[$dbName]

#display current owner
$db.Owner

#change owner...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

$dbName = "AdventureWorks2014"
$db = $server.Databases[$dbName]
$viewName = "vwVCPerson"
$view = $db.Views[$viewName]

#if view exists, drop it...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

$dbName = "AdventureWorks2014"
$db = $server.Databases[$dbName]

#storedProcedure class on MSDN:
#http:/...

#import SQL...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

$dbName = "AdventureWorks2014"
$db = $server.Databases[$dbName]

$tableName = "Person"
$schemaName...

#import SQL Server module
Import-Module SQLPS -DisableNameChecking

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

$dbName = "AdventureWorks2014"
$db = $server.Databases[$dbName]

#execute a passthrough query, and export to a CSV file

#line continuation in code below only happens at
#the pipe (|) delimiter
Invoke-Sqlcmd -Query "SELECT * FROM Person.Person"
-ServerInstance "$instanceName" -Database $dbName...