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 expertise required to extract value out of the data. Through enhancements in data virtualization and platform management, Microsoft SQL Server 2019 Big Data Clusters provides an innovative and integrated solution to overcome these difficulties. It incorporates Apache Spark and HDFS in addition to SQL Server, on a platform built exclusively using containerized applications, designed to derive new intelligent insights out of data.
Modernize your data estate with a scalable data virtualization and analytics platform
Data integration strategies are based on extract, transform, and load (ETL) results in data duplication and transformations that diminish data quality, higher maintenance, and security risks. SQL Server 2019 has a new approach to data integration called data virtualization across disparate and diverse data sources, without moving data. Out-of-the-box connectors for data sources like Oracle, Teradata or MongoDB help you keep the data in place and secure, with less maintenance and storage cost.
https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/ At Microsoft Ignite 2019,weannouncedAzure Synapse Analytics,a major evolution of Azure SQL Data Warehouse.Thesame industry leading data warehousenow provides a whole new level of performance, scale, and analytics capabilities.One of these capabilities is SQL Analytics, which provides READ MORE
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