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 big data enthusiast with more than 10 years of hands-on experience in database administration. Also, I am a Certified Microsoft Trainer (MCT) and Certified Microsoft Database Administrator (MCSA, MCSE) with a Master‘s degree in Information Technology.
read moreAuckland SQL Group
MSDN PROFILE
