Product: SQL Server 2019
-
-
What’s new with SQL Server 2019 Linux features
With SQL Server 2017, Microsoft entered the world of multi-OS platform support for SQL Server. For many technical professionals, the ability to run SQL Server on the same open source operating system as the rest of the application stack is not just a goal, but a dream that Microsoft made come true. With the release -
How to configure persistent memory for SQL Server on Linux
With the release of SQL Server 2019 on Linux, Microsoft introduced persistent memory (PMEM) support on Linux. This is an exciting development, as previous versions of SQL Server on Linux didn’t support PMEM. Let’s look at how to configure the PMEM for SQL Server on Linux. SQL Server 2016 introduced support for non-volatile DIMMs and -
How to deploy SQL Server 2019 Big Data Clusters
SQL Server 2019 Big Data Clusters is a scale-out, data virtualization platform built on top of the Kubernetes container platform. This ensures a predictable, fast, and elastically scalable deployment, regardless of where it’s deployed. In this blog post, we’ll explain how to deploy SQL Server 2019 Big Data Clusters to Kubernetes. First, the tools Deploying -
Reflections on PASS Summit 2019 from the SQL Tools Team
Last September at Microsoft Ignite 2018, Rohan Kumar, Corporate Vice President of Azure Data, announced the general availability of Azure Data Studio. This month, a little over a year later, Azure Data Studio took PASS Summit 2019 by storm, from keynote demos to community sessions to customer conversations at the Microsoft booth, we experienced overwhelming -
Five essential skills for today’s database administrators
DevOps, the cloud, and new database technologies mean our jobs as database administrators (DBAs) are changing at an ever-faster pace. If you’re fascinated by data and all the things you can do with it, it’s a thrilling time to be in the business. Here are five of the skills we see as essential parts of -
Build an intelligent analytics platform with SQL Server 2019 Big Data Clusters
In the most recent releases, SQL Server went beyond relational data and enabled support for graph data, R, and Python machine learning, while making SQL Server available on Linux and containers in addition to Windows. At the same time, organizations are challenged with the amount of data stored in different formats, in silos, and the -
The November 2019 release of Azure Data Studio is now available
Today we are announcing the November release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Please note: After downloading Azure Data Studio, say Yes to enabling the preview features so that you can use the extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals -
SQL Server Management Studio 18.4 and sqlpackage v18.4 generally available
Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.4. This update has full support for SQL Server 2019 capabilities as well as some bug fixes. You can download SQL Server Management Studio 18.4 today and review SQL Server Management Studio release notes for details. In addition, we’re also announcing sqlpackage v18.4 is -
Gain intelligence over data with SQL Server 2019, now generally available
Today we’re announcing that SQL Server 2019 is generally available. It’s been an amazing journey with a tremendous response from customers. Ever since we announced preview of SQL Server 2019 at Ignite 2018, it has seen 50 percent more adoption than SQL Server 2017, our highest performing SQL Server release to date. SQL Server 2019 -
SQL Server 2019 is now generally available
As you saw from our launch announcement earlier today, over a year ago at Microsoft Ignite we announced our first preview of SQL Server 2019 and today our latest release is now generally available. You have told us that in today’s demanding world of massive data, wide variety of data sources, and expectations of near -
Unify your data lakes with HDFS tiering in SQL Server Big Data Clusters
As the volume and variety of data has risen, it has become more common to store the data in disparate and diverse data sources. A challenge many organizations face today is how to gain insights from all of their data across many different data sources. With SQL Server 2019 Big Data Clusters, through innovative enhancements, -
New high availability and disaster recovery benefits for SQL Server
Business continuity is a key requirement for planning, designing, and implementing any business-critical system. When you bring data into the mix, business continuity becomes mandatory. It’s an insurance policy that one hopes they never have to make a claim against in the foreseeable future. SQL Server brings intelligent performance, availability, and security to Windows, Linux, -
Introducing the SQL Server 2019 video learning series
SQL Server 2019 is the new data platform to solve the challenges of the modern data professional including capabilities and solutions such as: SQL Server Big Data Clusters combining the power of SQL Server, Hadoop, Apache Spark™, and Kubernetes to provide an end-to-end data and machine learning platform. Data virtualization through Polybase Intelligent query processing -
Microsoft Azure Data loves PASS Summit 2019!
This year’s event is gearing up to be a monumental occasion as we plan to make some exciting product announcements. Listen from some of our leading keynote speakers, including Azure Data CVP Rohan Kumar, as they share their knowledge on Microsoft’s data platform products and services, and how to stay on the edge of the