This week we’re announcing the general availability of SQL Server 2019, a significant milestone for Azure Data and for SQL Server customers. This presents a good moment to give an update on the state of tooling for SQL Server.
Since SQL Server 2016, the tools for SQL Server have been released independently “out of box” from the server product. This allows us to be more agile to the needs of our users, get both features and bug fixes shipped more quickly, stay aligned with the more continuous release cycle of Azure SQL, and in general allows the tools team to innovate in exciting ways. However, one side effect is that it can be difficult to understand what’s happening across the tools landscape, as things change quickly in multiple products that are releasing as frequently as every month.
The SQL Server client tools cover the full breadth and depth of the product, and can be broadly categorized as follows:
SQL Server drivers and connectivity APIs, such as Microsoft.Data.SqlClient, ODBC, JDBC, etc.SQL Server tooling APIs and scripting support, including SQL Server Management Objects (SMO), DacFX, and PowerShellCommand line tools for SQL Server like sqlcmd, bcp, mssql-cli, and sqlpackageJupyter Notebooks, a new entrant in this space
https://cloudblogs.microsoft.com/sqlserver/2019/11/05/the-november-2019-release-of-azure-data-studio-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/05/the-november-2019-release-of-azure-data-studio-is-now-available/ Today we are announcing the November release ofAzure Data Studio is now available. Download Azure Data Studioand review therelease notesto get started. Please note: After downloading Azure Data Studio, say Yes to enabling the preview features READ MORE
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.
In addition, we’re also announcing sqlpackage v18.4 is now generally available. This means cross-platform support for sqlpackage is officially generally available.Download the latest release today.
In this blog, you will learn about the new features in these two exciting releases.
SQL Server Management Studio 18.4 featuresGeneral SQL Server Management Studio
SQL Management Objects and scripting
Supports the script of a materialized view in SQL Data Warehouse
Added support for a custom information protection policy for data classification
Added the “Max plan per query” value in the dialog propertiesAdded support for the new custom capture policies
Key bug fixes include:
General SQL Server Management StudioObject ExplorerFixed an issue where dropping an Azure SQL Database in Object Explorer was showing an inaccurate error message.SQL AgentFixed an issue where the agent operator UI would not update the operator name when it was changed in the UI and it wouldn’t be scripted. See the feedback forum to learn more.General SQL Server Management StudioFixed a long
PASS Summit has become an annual pilgrimage for thousands of SQL Server professionals from around the world to join together. My very first demo at PASS Summit was in 2010, and today marks the third time I’ve had the honor of being invited to deliver the day one keynote.
It has been incredible to reflect on how this event continues to support our community, providing unique opportunities for us to learn, connect, and share. The friends we make along the way, the networking and business opportunities that arise out of hallway meetings, the product announcements, and the technical deep dives are all focused on building and supporting the community. Because we are in this with you, PASS Summit provides us with the privileged opportunity to be able to listen to the community. To sit and understand your own firsthand experiences with the products and together embark on a journey of driving the industry forward to meet the expectations of an ever-changing tech landscape.
So to start off, a simple thank you to each one of you for spending the time, money, and energy to be a part of this amazing, open community of data friends and fans. It’s going to be a
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 delivers performance, security, and intelligence over all your data
SQL Server 2019 enables enterprises to gain intelligence over all data types, both structured and unstructured, by combining the power of new big data clusters with enhanced data virtualization. These powerful additions to SQL Server enable enterprises to not only store and query big data at scale but also combine it with structured data in whatever database it may reside such as SQL Server, Oracle, MongoDB, PostgreSQL, and others.SQL Server also includes built-in AI capabilities to enable comprehensive analytics and AI solutions for all your data needs.
Customers like Dr Foster, a Telstra and healthcare analytics company, are delighted to have this capability built into SQL Server 2019.
“Dr Foster required a solution that would help limit the amount of data movement, reduce duplication of data sets across the estate, and surface all of our business-critical relational data via a
https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/04/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 READ MORE
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, were extending the data virtualization capabilities even more with a new feature called HDFS tiering.
HDFS tiering allows you to easily integrate and gain insights from all of your data by accessing unstructured data stored on remote data lakes. This can be done by mounting the remote HDFS/S3 compatible data source to your local HDFS data lake.
This new functionality is Microsoft’s latest major contribution to the Apache Hadoop open source project and will be available in the market first in SQL Server 2019 Big Data Clusters.
Before we look closer at HDFS tiering, lets quickly look at SQL Server Big Data Clusters as a data platform.
SQL Server Big Data Clusters
SQL Server Big Data Clusters is a complete data platform for analytics and AI with a local HDFS data lake built-in for storing high volume and/or unstructured data. In the big data cluster, you can use two different
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, and containers and can tackle any data workload from BI to AI from online transaction processing (OLTP) to data warehousing. You get mission-critical high availability and disaster recovery features that allow you to implement various topologies to meet your business SLAs. A customer with SQL Server licenses with Software Assurance has historically benefited from a free passive instance of SQL Server for their high availability configurations. That helps to lower the total cost of ownership (TCO) of an application using SQL Server.
Today, we are enhancing the existing Software Assurance benefits for SQL Server which further helps customers implement a holistic business continuity plan with SQL Server.
Starting Nov 1st, every Software Assurance customer of SQL Server will be able to use three enhanced benefits for any SQL Server release that is still supported by Microsoft:
Failover servers for high availability – Allows customers to install and run passive
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 PolybaseIntelligent query processing to gain performance with no application changesMission critical security with Always Encrypted with Secure EnclavesMaximum database availability with accelerated database recoveryHosting your data on the platform of your choice with compatibility whether that be Windows, Linux, Containers, or Kubernetes
While you can read all about what’s new with SQL Server 2019 in our documentation, why not also learn at your pace and by example with videos? And who better to learn about SQL Server 2019 than the engineering team that built the product. We’re excited to announce our new SQL Server 2019 video learning series all taught by members of the SQL Server Engineering Team.
Start your journey by listening to Travis Wright tell you the story of the SQL Server 2019 product in this video:
This learning series covers the SQL Server 2019 product end-to-end using a series of short videos with demonstrations. Each video is taught by a member
This years 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 Microsofts data platform products and services, and how to stay on the edge of the changing data landscape.
Only PASS Summit gives you a unique opportunity to hear from industry leaders, as well as Microsoft product teams providing you with deep dives into data solutions.
Make sure you register ASAP and be sure to sign-up to the Data + AI sessions and clinics that are scheduled across the Summit program.
Pro-tip: access the Conference Sessions and get ready to be informed and inspired.
Recieve a $200 off discount with code: MSLOVEPASSPre-Conference activitiesNov 4th: SQL Server 2019 workshop: Bob Ward will give a comprehensive hands-on experience to try all the new features in SQL Server 2019. He will lead you through a day-long workshop on how to maximize the new capabilities of SQL Server 2019. You will walk away from this workshop knowing what Bob knows so that you can modernize your skills with SQL Server and teach others in your community or company why SQL