Author: SQL Server Team

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Alan Yu, Program Manager, Microsoft SQL Server We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available. In addition to enhancements and bug fixes, SSMS 17.3 comes with two new exciting features: Import Flat File Wizard XEvent Profiler Import Flat File Wizard The Import Flat File Wizard streamlines ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of both. By taking advantage of SQL Server 2017 on Linux, you’ll get enterprise-grade features at open-source pricing — all backed by Microsoft support and security. It’s never been easier or more cost effective to make the move. SQL Server 2017 combines the best of databases and analytics into one product. New enhancements include real-time intelligence due to faster transactions with In-Memory OLTP, new T-SQL enhancements for in-memory tables and natively compiled stored procedures, ColumnStore performance improvements, ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. The SQL Server team is excited to bring you the final service pack release for SQL Server 2012. 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 2012 deployments. SQL Server 2012 Service Pack 4 (SP4) contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Data management is shifting away from on-premises towards the many benefits of the cloud. Data is the fuel that energizes businesses in today’s marketplace, and the cloud amplifies this energy. The question then arises — what’s the simplest way to take your data to the cloud? In this free webinar, our Azure experts share how and why migration to the cloud is now easier, faster, and more cost-effective. Discover how to: Realize cost savings by preserving your investment in already purchased on-premises licenses. Save four times the investment you made on cores, ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server’s BI offerings. SSAS 2017 brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights. SSAS 2017 introduces the 1400 compatibility level. Here are just some highlights of the new features: New infrastructure for data connectivity and ingestion into tabular ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Travis Wright, Principal Program Manager, SQL Server Engineering Today, October 2nd, we are excited to announce that SQL Server 2017 is generally available for purchase and download! The new release is available right now for evaluation or purchase through the Microsoft Store, and will be available to Volume Licensing customers later today. Customers now have the flexibility for the first time ever to run industry-leading SQL Server on their choice of Linux, Docker Enterprise Edition-certified containers and, of course, Windows Server. It’s a stride forward for our modern ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For this first version of this adaptive query processing feature family, we have three new improvements: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. Legacy optimization behavior During optimization, the cardinality estimation process is responsible for estimating the number of rows processed at ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Bob Ward, Principal Architect, Database Systems Group “I feel the need, the need for speed”. That is a quote from the character Maverick, played by Tom Cruise, in one of my favorite movies, Top Gun. It makes me think of one of the top reasons why someone chooses a database engine. It must be fast and perform to the needs of all types of workloads accessing data. SQL Server 2017 sets the standard when it comes to speed and performance. Based on the incredible work of SQL ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have rebranded ‘R Services’ to ‘Machine Learning Services’. SQL Server now supports the three most popular data science languages and enables you to use the latest AI and ML packages from the open source world in-database, across ALL ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by John ‘JG’ Chirapurath, General Manager, Data Platform Marketing. Microsoft has heard from you, our customers, that your data estate gets bigger, more complicated, and more diverse every year. You need solutions that work across platforms, whether on-premises or in the cloud, and that meet your data workloads where they are. Embracing this choice, earlier today we announced the general availability of SQL Server 2017 on Linux, Windows, and Docker on October 2, 2017. Today, Microsoft and Red Hat are delivering on choice by announcing the availability of Microsoft SQL Server ... Read More