Modernize to cloud with Azure SQL Database

Modernize to cloud with Azure SQL Database

April 26th, 2018

Companies are embracing digital transformation by migrating to the cloud. IT organizations are continuously looking for new ways of optimizing how they use the data that fuels their operations. Modernizing to the cloud offers the right mix of operational efficiencies and business enablement to drive continued growth. IT optimization now requires new perspectives to consider:

  1. eliminate time spent managing “long tail” of applications – lift and shift to managed cloud,
  2. free up limited IT resources to drive transformation, and
  3. migrate business critical apps to the cloud – extend and innovate

One way IT organizations can confront challenges on their transformation journey is by adopting a PaaS (Platform as a Service) solution like Azure SQL Database. Azure SQL Database is a fully-managed relational database-as-a-service that provides the best and most economical cloud destination for your SQL data. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.

Within SQL Database, there is a new deployment option called Managed Instance that enables you to quickly and confidently move your SQL Server data (2005 and newer) at scale to the cloud. SQL Database shares a common code base with SQL Server and supports most of the same features at both the database and instance level, so you can reduce or eliminate the need to rearchitect your apps for the cloud.

Now is the perfect time to start your migration. Not sure how? Sign up for our webinar on April 26th to learn how you can start your migration journey to Azure SQL Database and learn how Managed Instance works. We’ll discuss the new innovations in SQL Database, security, enhanced performance and analytics built-in to modernize your business. Register today!

Source: Microsoft Blog – SQL Server News – Modernize to cloud with Azure SQL Database

SQL Server 2016 Service Pack 2 is now available

April 25th, 2018

The SQL Server team is excited to bring you the second service pack release for SQL Server 2016. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2016 deployments.

SQL Server 2016 Service Pack 2 (“SP2”) contains a roll-up of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on feedback from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics. It also showcases the SQL Server product team’s commitment to providing continued value into in-market releases.

SQL Server 2016 Service Pack 2 includes:

  • Performance and scale improvements for SQL Server, such as improved database backup performance on large memory machines and added backup compression support, which helps performance of almost all databases.
  • Supportability and diagnostics enhancements, such as improved troubleshooting and additional information about statistics used during query plan optimization.
  • New improvements based on Connect feedback items filed by the SQL Server Community.
  • Some improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2012 SP4.

Find more information on SQL Server 2016 SP2 in our KB article and Release Notes, and download today by visiting the links below:

If you have a question or would like to make a suggestion, you can let us know through UserVoice. We look forward to hearing from you!

Source: Microsoft Blog – SQL Server News – SQL Server 2016 Service Pack 2 is now available

We provide excellence in Database Administration

Let's work together