SQL

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

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

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

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

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)

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

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

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

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

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 »

Beta – New version of Windows, SQL and Azure

As you may already know, if not this is it , Microsoft has made some major announcements last week about the future version of Windows Server (Windows Server 2012 R2), SQL server (SQL Server 2014), System Center (System Center 2012 R2) and Windows Azure. So, if you want to start evaluating these new coming version …

Beta – New version of Windows, SQL and Azure Read More »