Author: SQL Server Team

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, Azure SQL DB, and Azure SQL DW from the command line. The DBFS tool enables DBAs and sysadmins to monitor SQL Server more easily by exposing live data from SQL Server Dynamic Management Views (DMVs) as virtual ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server 2017). Community Technology Preview (CTP) 2.1 is available on both Windows and Linux. In this preview, we added manageability features to make it easier to configure SQL Server in Docker containers. We’re also introducing some new command line tools for managing SQL Server in our GitHub repo. And, there’s a preview of SQL Server Integration Services on Linux to try! You can try the SQL Server 2017 preview in your choice of development and test ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Rohan Kumar, General Manager, Database Systems Group SQL Server 2017 makes it easier and simpler to work with data, with more deployment options than before and monthly preview releases offering regular innovation and improvements. The momentum behind these new options is clear. We are excited to mark a new milestone: Last week, SQL Server on Linux passed 1 million pulls of its container image! The image has been on Docker Hub for the six months since we first launched the SQL Server on Linux public preview in ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country’s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services. The firm handles logistics in a central location, where 200 dispatchers keep an eye on the movement of thousands of trucks and their cargo. Both drivers and dispatchers need the latest information to operate efficiently, so they rely on a ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Meet Bhagdev, Program Manager, Microsoft We are delighted to share the production-ready release of the SQL Server Command Line Tools (sqlcmd and bcp) on macOS El Capitan and Sierra. The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server. The utility is extremely useful for repetitive database tasks such as batch processing or unit testing. The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Have you ever seen a tree that simultaneously bears completely different species of fruit? It’s a real thing: apples, plums, oranges, lemons, and peaches all growing on the same tree. The growers have the advantage of a consistent environment (the same tree) that allows them to be efficient with resources, pick the type of fruit they need when they need it, and always have the right kind of fruit without having to invest in specialized plants. Those trees are like the consistent foundation shared by SQL Server 2016, Windows Server 2016, and ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Vin Yu, Program Manager, SQL Engineering Microsoft recently announced Community Technology Preview (CTP) 2.0, the first production-quality preview of SQL Server 2017. To help our independent software vendor (ISV) partners leverage the latest enhancements, we are expanding our Data Accelerator program to support SQL Server 2017 on Linux. Leverage the latest enhancements in SQL Server 2017 Both SQL Server 2016 SP1 and SQL Server 2017 include many performance and security innovations that can be leveraged with minimal changes to the application. These include features such as In-Memory ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Meet Bhagdev, Program Manager, Microsoft Hi, all. We are delighted to share the production-ready release of the Microsoft ODBC Driver 13.1 for macOS El Capitan and Sierra. The new driver enables access to SQL Server, Azure SQL Database and Azure SQL DW from any C/C++ application on macOS. Added Native install experience The driver can now be installed with brew. Instructions on how to do this are below. Azure AD support You can now use Azure AD authentication (username/password) to centrally manage identities of database users and ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Joseph Sirosh, Corporate Vice President, Microsoft Data Group This week at the annual Microsoft Build conference, we are discussing how, more than ever, organizations are relying on developers to create breakthrough experiences. With big data, cloud and AI converging, innovation & disruption is accelerating to a pace never seen before. Data is the key strategic asset at the heart of this convergence. When combined with the limitless computing power of the cloud and new capabilities like Machine Learning and AI, it enables developers to build the next ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Nikki Thomas Two weeks ago, we welcomed special guest performer Homer McEwen (aka KillaDBA) to SQL Saturday. The database administrator from Atlanta writes and records songs about SQL Server to help others gain a better understanding of the platform. And although his songs are innovative, engaging, and seriously catchy, it’s Homer’s down-to-earth personality and passion for music and technology that make him really stand out. Onstage, Homer performed four songs, including his latest “I’m in Love With an IT Girl.” He captivated the crowd with a mix ... Read More