SQL

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 – Azure Recovery now supports SQL 2019 and restore as file

Azure Recovery Services is keeping up with the latest release of Microsoft SQL, SQL Server 2019, as it now supports backing up SQL Server 2019 data running on virtual machine. This also includes support for SQL Server 2019 running on Windows Server 2019. In addition of this support, you also now restore SQL backup as

Azure – Azure Recovery now supports SQL 2019 and restore as file 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 – Azure Backup for SQL Server 2008/2008 R2 is in preview

As you are aware, Windows Server 2008 R2 and SQL Server 2008/2008 R2 are reaching their end of life. Microsoft has offered to extend the support of these products if you moved them to Azure for an additional 3 years to give more time for migration. That said, once you have move your SQL Server

Azure – Azure Backup for SQL Server 2008/2008 R2 is in preview 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 »