-
Powershell Create of the SSISDB Catalog
So when management gets this [insert explicative] idea to strip away my MSDN enterprise access, and I need to create an SSISDB catalog on my dev server- what the hell am I to do? Well, maybe not simple… I put on my PowerShell hack through hat. Shall we? In your favorite SQL instance (we’ll just use localhost for my examples) start with making sure you have CLR ENABLED first: EXEC sp_configure 'clr enabled', 1; RECONFIGURE; GO Do this in a query window in SSMS of course. Now the PowerShell: # Load the IntegrationServices Assembly [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices") # Store the IntegrationServices Assembly namespace to avoid typing it every time $ISNamespace =…
-
Powershell 6.x Profiles
Because I can never remember this: All Users, All Hosts $PsHome\Profile.ps1 All Users, Current Host $PsHome\Microsoft.PowerShell_profile.ps1 Current User, All Hosts $Home\Documents\PowerShell\Profile.ps1 Current user, Current Host $Home\Documents\PowerShell\Microsoft.PowerShell_profile.ps $Profile Current User, Current Host $Profile.CurrentUserCurrentHost Current User, Current Host (Yeah the same as above) $Profile.CurrentUserAllHosts Current User, All Hosts $Profile.AllUsersCurrentHost All Users, Current Host $Profile.AllUsersAllHosts All Users, All Hosts
-
Powershell 6 Core Like Install
As I re-tool (or is it update) my Powershell, I came across the simple one liner to do the install… nice: iex "& { $(irm https://aka.ms/install-powershell.ps1) } -UseMSI" Btw some neat changes in 6.2 PS… Some interesting settings: Enable-ExperimentalFeature -Name PSCommandNotFoundSuggestion Enable-ExperimentalFeature -Name PSTempDrive Enable-ExperimentalFeature -Name PSUseAbbreviationExpansion Read More: What’s New in PowerShell Core 6.2 What’s New in PowerShell Core 6.2 New features and changes released in PowerShell Core 6.2 Source: docs.microsoft.com/en-us/powershell/scripting/whats-new/what-s-new-in-powershell-core-62?view=powershell-6
