SQL Server CLR Function on Azure SQL Server Managed Instance

SQL Server Code

When you need to deploy an assembly (.net DLL) SQL Server CLR Function on Azure SQL Server Managed Instance, you have to do it slightly differently. I’ll show you how to do this with the least amount of effort! On a locally hosted or native installation of SQL Server, you would reference the assembly locally. […]

SQL Server Managed Instance IO Performance

SQL Server Managed Instance IO Performance is dependant on a few settings. Service Tier vCore Count  File Sizes !! Yes, File Sizes. A quick explanation, if you have a small database < 128GB your not going to get much data throughput. Only around the 500 IOPS or 100 MB/s. It’s all explained here. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits You […]

Upload Multiple Files to Azure Storage with PowerShell

A simple code example that takes a pipeline input of file names, appends an optional date stamp and uploads the file(s) to Azure Storage. It needs the new Azure Az Module. You can install that here. Install-Module Az -AllowClobber -Scope CurrentUser Install-Module Az -AllowClobber -Scope CurrentUser Here is the PowerShell Script. Copy-ItemToAzStorage.ps1 param ( [Parameter(Mandatory […]

Azure & Office 365 IP Address Ranges Reference

Quick Reference to where the latest various Azure IP ranges are located across the Microsoft documentation Resources. I’ll keep this post updated as they change. Azure IP Ranges and Service Tags – Public Cloud General: https://www.microsoft.com/en-us/download/details.aspx?id=56519 US Gov: http://www.microsoft.com/en-us/download/details.aspx?id=57063 Germany: http://www.microsoft.com/en-us/download/details.aspx?id=57064 China: http://www.microsoft.com/en-us/download/details.aspx?id=5706 Azure CDN https://docs.microsoft.com/en-gb/azure/cdn/cdn-pop-list-api Logic App https://docs.microsoft.com/azure/logic-apps/logic-apps-limits-and-config#configuration Office 365 https://docs.microsoft.com/en-us/office365/enterprise/urls-and-ip-address-ranges