Tags : #sqlserver

25

Apr

Modernize to cloud with Azure SQL Database
Modernize to cloud with Azure SQL Database

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:

eliminate time spent managing “long tail” of applications – lift and shift to managed cloud, free up limited IT resources to drive transformation, and 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

24

Apr

SQL Server 2016 Service Pack 2 is now available
SQL Server 2016 Service Pack 2 is now available

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 teams 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

24

Apr

SQL Server 2016 Service Pack 2 is now available
SQL Server 2016 Service Pack 2 is now available

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

19

Apr

Replication Enhancement – Distribution Database in Availability Group

https://blogs.msdn.microsoft.com/sql_server_team/replication-enhancement-distribution-database-in-availability-group/Source: https://blogs.msdn.microsoft.com/sql_server_team/replication-enhancement-distribution-database-in-availability-group/   SQL Server replication uses the publisher, distributor, and subscriber paradigm to provide logical data replication capability between different SQL Server instances, and sometime with heterogeneous data source or data destination. Replication uses the distribution databases hosted on READ MORE

19

Apr

SQL Server 2017 on SUSE Enterprise Linux Server offer
SQL Server 2017 on SUSE Enterprise Linux Server offer

This post is authored by John JG Chirapurath, General Manager, Azure Data.

Since SQL Server 2017 on Linux was made generally available on October 2, 2017, we have seen tremendous growth in adoption. Weve had ~ 5 million Docker pulls for SQL Server 2017 on Linux and are seeing strong affinity with our customers who are on other database systems running on Linux as well as customers consolidating on Linux as their operating system. Additionally, weve had a great response from the open source developer community.

SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a Docker image, which can run on Docker Engine on Linux or Docker for Windows/Mac.

In the path forward to deliver choice, today Microsoft and SUSE are announcing some great offers for our mutual customers both on-premises and on Azure to adopt SQL Server 2017 on Linux as their database of choice.

Microsoft and SUSE have a decade long relationship, powering enterprises focused on interoperability and high-performance solutions. With SQL Server 2017 running on SUSE Enterprise Linux Server, we are bringing the most cost-effective path for our customers. If you combine

19

Apr

SQL Server 2017 on SUSE Enterprise Linux Server offer
SQL Server 2017 on SUSE Enterprise Linux Server offer

This post is authored by John ‘JG’ Chirapurath, General Manager, Azure Data.

Since SQL Server 2017 on Linux was made generally available on October 2, 2017, we have seen tremendous growth in adoption. We’ve had ~ 5 million Docker pulls for SQL Server 2017 on Linux and are seeing strong affinity with our customers who are on other database systems running on Linux as well as customers consolidating on Linux as their operating system. Additionally, we’ve had a great response from the open source developer community.

SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a Docker image, which can run on Docker Engine on Linux or Docker for Windows/Mac.

In the path forward to deliver choice, today Microsoft and SUSE are announcing some great offers for our mutual customers both on-premises and on Azure to adopt SQL Server 2017 on Linux as their database of choice.

Microsoft and SUSE have a decade long relationship, powering enterprises focused on interoperability and high-performance solutions. With SQL Server 2017 running on SUSE Enterprise Linux Server, we are bringing the most cost-effective path for our customers. If you combine

10

Apr

Celebrating 1M installations milestone for mssql extension for VS Code with another update

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce that a new update for the mssql extension for VS Code is now available on the VS Code Marketplace.

Use the mssql extension to turn VS Code into a powerful editor of T-SQL development, which supports SQL Server running on-prem, Azure SQL Database, and Azure SQL Data Warehouse.

Download the latest update from the VS Code Marketplace.

1M installations milestone

Thanks to your help, the mssql extension has hit an awesome milestone of 1 million+ downloads in less than a year since general availability announcement on May 1, 2017. Since GA, more and more VS Code users have downloaded the mssql extension through the recommended extensions experience as they write out T-SQL queries.

As our user base grows, we will continue to send updates from the high priority issues determined by the community. To make this meaningful for the community, we need your help to report and upvote your high priority features and issues on our Github Issues page. Over the past year, the SQL Tools team has prioritized bringing our new tools open source, and using the Github Issues page to

10

Apr

Celebrating 1M installations milestone for mssql extension for VS Code with another update

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce that a new update for the mssql extension for VS Code is now available on the VS Code Marketplace.

Use the mssql extension to turn VS Code into a powerful editor of T-SQL development, which supports SQL Server running on-prem, Azure SQL Database, and Azure SQL Data Warehouse.

Download the latest update from the VS Code Marketplace.

1M installations milestone

Thanks to your help, the mssql extension has hit an awesome milestone of 1 million+ downloads in less than a year since general availability announcement on May 1, 2017. Since GA, more and more VS Code users have downloaded the mssql extension through the recommended extensions experience as they write out T-SQL queries.

As our user base grows, we will continue to send updates from the high priority issues determined by the community. To make this meaningful for the community, we need your help to report and upvote your high priority features and issues on our Github Issues page. Over the past year, the SQL Tools team has prioritized bringing our new tools open source, and using the Github Issues page to

10

Apr

Cloud data and AI services training roundup
Cloud data and AI services training roundup

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free data and artificial intelligence (AI) sessions in one convenient post.

SQL Server 2017

Whether on Windows, Linux, or Docker containers, you have the flexibility of leveraging SQL Server 2017’s industry-leading performance and security wherever you like. Heres a rundown of recent and upcoming training sessions to help you learn more.

Complying with GDPR on Microsoft SQL-based technologies

Extended support for SQL Server 2008 and 2008 R2 is coming to an end on July 9, 2019, which means its time to choose your path to modernization. Without support, security updates will no longer be available, and you may run the risk of non-compliance with industry regulations such as GDPR (General Data Protection Regulation). Join this detailed training session on demand to understand how to begin your migration journey today.

Move your transactional workloads to the cloud with Azure SQL Database

Moving your on-premises database to the cloud has never been easier. Join this demo-filled training to learn how Azure SQL Database helps you unlock the potential of your database (and your people) without changing your application

10

Apr

Cloud data and AI services training roundup
Cloud data and AI services training roundup

To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free data and artificial intelligence (AI) sessions in one convenient post.

SQL Server 2017

Whether on Windows, Linux, or Docker containers, you have the flexibility of leveraging SQL Server 2017’s industry-leading performance and security wherever you like. Here’s a rundown of recent and upcoming training sessions to help you learn more.

Complying with GDPR on Microsoft SQL-based technologies

Extended support for SQL Server 2008 and 2008 R2 is coming to an end on July 9, 2019, which means it’s time to choose your path to modernization. Without support, security updates will no longer be available, and you may run the risk of non-compliance with industry regulations such as GDPR (General Data Protection Regulation). Join this detailed training session on demand to understand how to begin your migration journey today.

Move your transactional workloads to the cloud with Azure SQL Database

Moving your on-premises database to the cloud has never been easier. Join this demo-filled training to learn how Azure SQL Database helps you unlock the potential of your database (and your people) without changing your application architecture. Specifically, we cover how