The SQL Server team is excited to bring you the third service pack release for SQL Server 2014. This service pack is now available for download from the Microsoft Download Center as well as the Microsoft Update Catalog, Microsoft Developer Network, Microsoft Evaluation Center, MBS Partner Source, and the Volume Licensing Service Center. As part of our commitment to software excellence, this upgrade is available to all customers with existing SQL Server 2014 deployments.
SQL Server 2014 Service Pack 3 (SP3) features improvements centered around performance, scalability, and diagnostics based on the feedback from customers and the SQL community. These improvements enable SQL Server 2014 to perform faster and scale out-of-the-box on modern hardware design.
Key aspects of this release include: Improved database backup performance on large memory machines and improved database restore performance for compressed backups Support enhancements for CLONEDATABASE with a new DBCC option and Service Broker support Support enhancements for Showplan XML in scalar user-defined functions and exposed information about memory fractions
This release includes over eight improvements and 21 support and diagnostic enhancements.
Find more information on SQL Server 2014 SP3 in our KB article, and download the new server pack today by visiting
We are very excited to announce the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, etc.
You can download SSMS 18.0 Public Preview 5 here.
New features include: Static Data Masking Query Tuning Assistant Ability to launch Azure Data Studio from SSMS SSMS improvements include: SSMS – Exposed “Maximum size for error log files” under “Configure SQL Server error logs” SSMS/Object Scripting – Adding new menu items for “CREATE OR ALTER” when scripting objects Database Compatibility Level Upgrade New option under <Database Name> Tasks> Database Upgrade. This will start the new Query Tuning Assistant to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level Upgrading to the desired database compatibility level Collecting a second pass of performance data over the same workload Detecting workload regressions and providing tested recommendations to improve workload performance
SSMS Query Store Improved usability of some reports New Query Wait Statistics report
Vulnerability Assessment – Enabled Vulnerability
Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a paradigm shift in data management where data in different silos are being brought together to create high-value data sets that are used to drive critical business divisions in industry verticals like retail, banking, healthcare, and more.
SQL Server 2016 introduced a new feature called PolyBase that enables your SQL Server instance to process Transact-SQL queries that read data from Hadoop. The same query can also join with relational tables in your SQL Server. SQL Server 2019 CTP 2.0 introduces new connectors for PolyBase including SQL Server, Oracle, Teradata, MongoDB, Azure SQL DB, Azure SQL DW, Cosmos DB, and virtually any ODBC-accessible data source.
The arrival of the new connectors enables customers to leverage PolyBase for creating a virtual data hub for a wide variety of data sources within the enterprise. Its very common to find an enterprise scenario where data from an Oracle database needs
We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database. We are beginning with support for the R language in this preview release and will be adding Python language support in a future update.
End to end machine learning with R in Azure SQL Database
Using Machine Learning Services with R support in Azure SQL Database, you can
Run R scripts to do data preparation and general purpose data processing You can now bring your R scripts to Azure SQL Database where your data lives, instead of having to move data out to some other server to run R scripts. You eliminate the need for data movement and associated problems related to latency, security, compliance, etc. Train machine learning models in database You can train models using open source algorithms or Microsoft’s scalable algorithms in RevoScaleR and MicrosoftML packages in database. You can easily scale your training to the entire dataset rather than relying on
Today Im excited to give the Day 1 keynote at PASS Summit v.20, a gathering of our longtime community of SQL Server users and data professionals. PASS Summit is an amazing chance to see the faces of old and new friends. Its a place to meet with customers and fans to continually learn about their evolving needs and to help us grow as a SQL community and develop the best data platform products in the market.
Hybrid connects all your data
Now more than ever, we are architecting for hybrid, because we are hearing from customers that they will be running data workloads on-premises and in the cloud rarely just one or the other. We believe that the value Microsoft can add is to provide a great and consistent experience wherever they deploy. One example of this commitment is Azure SQL Database Managed Instance, which was recently made generally available. Managed Instance enables organizations to migrate their SQL Server workloads to Azure with zero code changes and offers an easy path to the cloud at an incredible value and with security, intelligent performance and management tools that are unique to our cloud database services. The end of extended support for
We are excited to announce the November release of Azure Data Studio (formerly known as SQL Operations Studio) is now available.
Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to the latest version, follow these instructions. When you download Azure Data Studio, remember to enable preview features by default at first launch, and then you can disable in settings if you dont need it otherwise. By not enabling the preview features, you will be missing preview experiences like Query Plans, certain extension support, and more.
Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our Github.
Azure Data Studio was announced Generally Available at Microsoft Ignite 2018. If you missed it, catch up by reading the GA announcement on the SQL Server blog. You wont want to miss the great orthogonality matrix included comparing SSMS and Azure Data Studio and answers to many of your questions.
In Novembers version of the monthly release
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 2019
SQL Server 2019 brings innovative security and compliance features, industry-leading performance, mission-critical availability, and advanced analytics to all your data workloads, now with support for big data built-in.
More than 12,000 of you signed up for this unveiling of Microsoft SQL Server 2019, now in public preview. See what all the buzz is about in the on-demand guided tour. Easily integrate data from multiple sources, including Oracle, MongoDB, and Teradata, without moving your data via ETL. Learn how enhanced security, performance, scalability, and availability of the SQL Server database engine helps you manage critical applications and data warehouses.
Azure SQL Database Managed Instance
Azure SQL Database is a fully managed relational database-as-a-service, which means you wont need to manage virtual machines, worry about scalability or availability, or deal with database and security upgrades.
Learn how Azure SQL Database Managed Instance, the latest deployment option, allows you to seamlessly lift-and-shift your on-premises SQL Server applications
https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/Source: https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/ In the recent announcement at Ignite 2018 on the release of SQL Server 2019 CTP 2.0, the new Big Data Clusters, data virtualization, support for UTF-8, and Intelligent Query Processing were highlights. But we have also previewed READ MORE
Sounds like there should be a punchline right? Well, there is. Microsoft will be in full force at PASS Summit 2018, and this is the third blog post in a series describing the involvement of the Microsoft SQL Server engineering team there. You can read more about our keynotes and our Modernizing pre-conference seminar from this series. In this post, Ill talk more about the SQL Server engineering team sessions and participation in the famous Data Clinic (aka the SQL Clinic) covering everything from SQL Server 2019 to the practical and to the modern.
SQL Server 2019
You may have seen the buzz about the launch of SQL Server 2019 preview a few weeks ago. Our team will immerse you in the strategy and the details of SQL Server 2019 with the following sessions:
The Roadmap of SQL Server This is your one stop shop for SQL Server 2019 all-up. The Future of SQL Server and Big Data Spark, SQL, and HDFS in the box. Is this even possible? Come find out how. Whats New in SQL Server on Linux and Containers People still dont believe SQL Server runs on Linux. See whats new in SQL Server on Linux
https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-ctp-2-0-new-features-columnstore-support-for-sp_estimate_data_compression_savings/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-ctp-2-0-new-features-columnstore-support-for-sp_estimate_data_compression_savings/ Next up for new Storage Engine area features in SQL Server 2019 is an update to the sp_estimate_data_compression_savings stored procedure to add support for both columnstore and columnstore archive compression. This stored procedure has been around since READ MORE