Azure Backup now supports PowerShell and ACLs for Azure Files

Categories: Azure Tags:

Export data in near real-time from Azure IoT Central

Categories: Azure Tags: ,

Azure: Virtual Network Service Endpoints for serverless messaging and big data

Categories: Azure Tags: ,

From Bett: New tools for the visually impaired , Immersive Reader for VR, and Microsoft Teams gets new classroom features

Automation of SSRS Configuration

MSReportServer_ConfigurationSetting Class:

https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/msreportserver-configurationsetting-class?view=sql-server-2017

Powershell Example:

$wmiName = (Get-WmiObject –namespace root\Microsoft\SqlServer\ReportServer  –class __Namespace).Name
$rsConfig = Get-WmiObject –namespace "root\Microsoft\SqlServer\ReportServer\$wmiName\v11\Admin" -class MSReportServer_ConfigurationSetting  -filter "InstanceName=’SQLTFS’"

CheckHResult $rsConfig.SetVirtualDirectory("ReportServerWebService","ReportServer",0)
CheckHResult $rsConfig.ReserveURL("ReportServerWebService", "http://+:80", 1033)
CheckHResult $rsConfig.SetVirtualDirectory("ReportManager","Reports",0)
CheckHResult $rsConfig.SetDatabaseConnection($DatabaseInstance, $DatabaseName, 2, $SqlCredential.UserName, $SqlCredential.GetNetworkCredential().Password)
# force refresh
CheckHResult $rsConfig.SetServiceState($false,$false,$false)
Restart-Service $rsConfig.ServiceName
CheckHResult $rsConfig.SetServiceState($true,$true,$true)
# set key
& "$SQLBin\RSKeyMgmt.exe" -a -i SQLTFS -f $SSRSEncryptKeyFile -p $SSRSEncryptPassword
# join group
& "$SQLBin\RSKeyMgmt.exe" -j -m $workingNode -i SQLTFS -n SQLTFS

GitHub:

PowerShell/DscResources

PowerShell/SqlServerDsc

Configure Report Server URLs (SSRS Configuration Manager)

Categories: MS: SQL Tags: , ,

Announcing Personal Bookmarks in the Power BI Service

Categories: Azure, MS: SQL Tags: