Author: SQL Server Team

Feed: SQL Server Blog. Author: SQL Server Team. This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the April release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub. SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this April release is the fifth major ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. 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 ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. 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 ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. 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 ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Microsoft continues to embrace open source solutions. SQL Server 2017 brings the best features of the Microsoft relational database engine to the enterprise Linux ecosystem, including SQL Server Agent, Azure Active Directory (Azure AD) authentication, best-in-class high availability/ disaster recovery, and unparalleled data security. Note that SQL Server on Linux is not a port or rewrite. This is the same world-class Microsoft relational database management system (RDBMS) now available on more operating systems (like Red Hat ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Customers today demand the latest innovations in every solution you deliver. How can you make sure your data infrastructure not only keeps up, but drives innovation? Data is the core of modern applications. Two key trends that help organizations extract the most from their data are the adoption of cloud technologies and the ability to drive new customer experiences with artificial intelligence. Organizations that modernize and harness data, cloud, and AI outperform their competition and are becoming leaders in their field. The most digitally transformed enterprises earn an additional $100 million in ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server. We are excited to announce the January release of SQL Operations Studio is now available. Download SQL Operations Studio and review the release notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB, and SQL DW from Windows, macOS, and Linux. To learn more, visit our Github. SQL Operations Studio was announced for public preview on November 15, 2017 at Connect(), and this January release is ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the December release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub. SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this December release is the first major ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. SQL Server 2017, in addition to processing relational data, now fully integrates with graph database models, all on the same familiar system. This will bring clarity to the increasing amounts of data businesses generate every day. What’s the difference between graph and relational databases? Relational databases, like SQL Server, use foreign keys to manage relationships between entities and tables. Foreign keys adequately query one-to-many relationships; however, as relationships between various data entities become more complex, queries also become more complex and performance may diminish as a result. In these cases, developers may ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. It’s time to get excited—the Azure Database Migration Service Public Preview is here to help you move on-premises SQL Servers to the cloud with near-zero downtime. There’s never been a better time to start migrating your database to the cloud. Getting ahead in business today means moving to the cloud so that your company can grow and succeed. The Azure Database Migration Service Public Preview is the quickest and easiest way for businesses to migrate on-premises databases to the cloud. It’s a fully managed migration service designed to work together with our ... Read More