SQL

Azure – You can now use Azure Update Manager to update SQL Server on Azure VM (preview)

Leave a Comment / Beta / Preview, Microsoft Azure / / / , , , , ,

Ensuring your virtual machine and workloads running on it is an important task to maintain your security posture. You probably know that you can manage updates management on Azure using Azure Update Manager (https://learn.microsoft.com/en-us/azure/update-center/overview?tabs=azure-vms). Well, Azure Update Manager can now be used to also update your SQL instance running on a virtual machine. To do […]

Azure – You can now use Azure Update Manager to update SQL Server on Azure VM (preview) Read More »

Azure – You can now run the SQL best practices assessment for SQL virtual machine from the portal

1 Comment / Microsoft Azure / / / , ,

As you know, Azure SQL is available either as PaaS or IaaS. Well, you can now enable and run SQL best practices assessment on SQL server running on virtual machine. To do so, you need: to have deployed an Azure SQL virtual machine the SQL virtual machine must be with the SQL Server IaaS extension

Azure – You can now run the SQL best practices assessment for SQL virtual machine from the portal Read More »

Azure – Maintenance window is available for SQL Database and SQL Managed Instance

Leave a Comment / Microsoft Azure / / / , ,

As you know the beauty of the PaaS is you don’t have anymore to manage the underlying infrastructure (patching OS for example) as this the responsibility of the cloud provider. Well, while this is very interesting you lose a little bit of control, especially when it comes to maintenance. Well, you can now manage the

Azure – Maintenance window is available for SQL Database and SQL Managed Instance Read More »

SQL – Azure Data Studio is now installed automatically with SQL Management Studio

Leave a Comment / SQL / / / , , , , ,

The latest version of SQL Management Studio (SSMS) – 18.7.1 – available for download here https://aka.ms/ssmsfullsetup – is now installing automatically Azure Data Studio. If you don’t know what is Azure Data Studio, this is a cross platform database management tool available on Windows, Linux or MacOS, allowing you managing on-premises and cloud data. You

SQL – Azure Data Studio is now installed automatically with SQL Management Studio Read More »

Azure – You now have a centralized hub to manage all Azure SQL resources

Leave a Comment / Microsoft Azure, SQL / / / , , , ,

As you know, Microsoft Azure provides you the ability to host SQL resources, from SQL database to Elastic Pools or SQL running on a virtual machine (not comprehensive). This makes it a little bit difficult to have a comprehensive view of all the Azure SQL resources you may be running as you have to switch

Azure – You now have a centralized hub to manage all Azure SQL resources Read More »

Azure – Automated SQL Databases backup (Preview)

Leave a Comment / Beta / Preview, Microsoft Azure, SQL / / / , , , , , , ,

Following the announcement of Azure Backup for SQL Server on Azure VM (see https://azure.microsoft.com/en-in/blog/azure-backup-for-sql-server-on-azure-vm-public-preview/) a new backup capability has been added. As you know, when a new SQL database is being added onto your Azure SQL VM instance you have to rediscover the database and then configure the protection for this new database. Now, with

Azure – Automated SQL Databases backup (Preview) Read More »

Azure – Azure Backup Server now support SQL 2017 and Windows Server 2019

Leave a Comment / Microsoft Azure, SQL, Windows / / / , , , , , , , , ,

Microsoft Azure Backup Server (MABS) v3 now support SQL 2017 workloads and can be installed on Windows Server 2019. In addition MABS v3 introduces support for TLS 1.2 and support for VMware VM backup (vCenter and ESXi 6.5 and auto-protection when new VMWare VM’s are added to a protected folder) You can get here https://docs.microsoft.com/en-us/azure/backup/backup-azure-microsoft-azure-backup#software-package

Azure – Azure Backup Server now support SQL 2017 and Windows Server 2019 Read More »

Azure / Sql – New offers and capabilities for SQL 2008 Server

Leave a Comment / Microsoft Azure, SQL / / / , , , ,

As you may know (otherwise, this is it, you know ), SQL Server 2008/2008 R2 is going out of support in July 2019 (https://support.microsoft.com/en-us/lifecycle/search/14917), while Windows Server 2008 is going to be out of support in January 2020 (https://support.microsoft.com/en-us/lifecycle/search/12925). To help you migrate your workloads still running on these systems, Microsoft is extending the security

Azure / Sql – New offers and capabilities for SQL 2008 Server Read More »

Azure – Data classification and protection now available for SQL

Leave a Comment / Microsoft Azure, SQL / / / ,

SQL Information Protection now includes new capabilities to help identify, classify or monitor data stored in your SQL databases.   Use on Azure SQL To start using these new capabilities, go to your Azure ARM portal (https://portal.azure.com) and reach your SQL Server blade. Then access the SQL database you want to Advanced Threat Protection configuration

Azure – Data classification and protection now available for SQL Read More »

Azure – SQL Vulnerability Assessment

Leave a Comment / Microsoft Azure, Security, SQL / / / , ,

Microsoft has introduced a new feature to help you ensuring your Azure SQL services are secured. This feature is called SQL Vulnerability Assessment and is available on preview; the good news is you can also use it with your on-premises SQL servers. It has been designed in a way that even non security/SQL expert can

Azure – SQL Vulnerability Assessment Read More »