Azure SQL and Storage now uses VNet
A huge security improvement for Azure SQL and Azure Storage. Service Endpoints now allow you to connect these resources to your VNet rather than directly accessible on the Internet. Also, […]
sql
Azure Maintenance, DDoS, File Sync, SQL Security announcements at Ignite 2017
A few exciting new additions announced at Ignite 2017… Azure DDoS Protection – a service that works with your virtual network https://azure.microsoft.com/en-gb/blog/azure-ddos-protection-service-preview/ Improved Planned Maintenance experience – Better control, […]
TDE with BYOK support for Azure SQL Databases
Store master keys in Azure Key Vault for Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) support when using Azure SQL Databases. A solution for data at rest […]
Autofailover Azure SQL Databases
Azure SQL Databases geo-replication now offers auto-failover including connection strings that don’t change – in preview. https://azure.microsoft.com/en-gb/blog/azure-sql-database-now-supports-transparent-geographic-failover-of-multiple-databases-featuring-automatic-activation/
R Services and Machine Learning optimisation
Optimisation tips and tricks with R Services on Azure SQL Server and any Machine Learning Services integrated with SQL Server. https://azure.microsoft.com/en-gb/blog/optimization-tips-and-tricks-on-azure-sql-server-for-machine-learning-services/
Azure Analysis Services now general availability
Azure Analysis Services, the OLAP engine and BI modeling platform, is now general availability. Consume data from Cloud sources such as Azure SQL Database and Azure SQL Data Warehouse and […]
Hybrid Azure SQL Databases and Azure SQL VMs
A very detailed article on hybrid SQL scenarios and how to get the data migrated into Azure. This showcases using Azure SQL Databases and Azure SQL VMs. https://azure.microsoft.com/en-gb/blog/azure-sql-hybrid-data-movement/
Backup SQL2016 data from the Azure Portal or Powershell
https://azure.microsoft.com/en-gb/blog/auto-backup-for-sql-server-2016-azure-virtual-machine/ A great feature and time saver to backup and manage SQL2016 user and system databases from the Azure Portal. You can restore to any point in time and all […]