Currently Browsing: Powershell
Powershell / Credentials / Connect to SQL Server with PowerShell
Posted by Barac in Powershell, SQL Server on Nov 10th, 2017 | 0 comments
How to login using SQL Server Management Object (SMO) For windows authentication #################################################################### ####################### Windows Authentication ##################### #################################################################### [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-Null $s = new-object ('Microsoft.SqlServer.Management.Smo.Server') "InstanceName" $s.ConnectionContext.LoginSecure=$true $s.Databases | select name, size, status #################################################################### ...
Powershell / Backup SQL Server DBs to Azure Storage with Powershell script
Posted by Barac in Azure, Powershell, SQL Server on Oct 4th, 2017 | 2 comments
With this simple script, you can backup all databases to Azure daily, you can hardcode the parameters values or you can use task manager to pass them to the PS script. You need to have Azure PowerShell modules installed on your machine (how to). First off all, let’s try just to connect to your Azure Storage Account You can use azure credential-publishsettings file to do that, or putting the variables with access key, subscription and storage account name as in this example: #Variables param ( [string]$AzureKey= "AzureStorageAccessKey", [string]$AzureSubs= "YourSubscription", [string]$AzureStor=...
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a database specialist with more than 10 years of hands-on experience in database administration and optimisation. Also, I am a Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert with a Master‘s degree in Information Technology.
read moreAuckland SQL Group
MSDN PROFILE
