To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Database Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so you can Read more
We have released our second major update for mssql-cli since our public preview announcement in December. You can view the public preview announcement here. mssql-cli is a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is part of the dbcli community. mssql-cli auto-completion in action In Read more
SQL Server 2017, in addition to processing relational data, now fully integrates with graph database models, all on the same familiar system. This will bring clarity to the increasing amounts of data businesses generate every day. What’s the difference between graph and relational databases? Relational databases, like SQL Server, use foreign keys to manage relationships Read more
Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to Read more
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 Read more
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 Read more
“Data is currency” is the rule of thumb in business. As with money, business data must be accessible, accurate, and usable across disparate contexts if an organization is to realize greater ROI while keeping costs under control. CIOs understand that the need to manage data—its location, composition, and utility—is as important as managing a balance Read more
This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in modern IT infrastructure in any public or private cloud. With support Read more
This means that you can choose a hybrid deployment and take advantage of any of the four basic options for hosting SQL Server: SQL Server in on-premises non-virtualized physical machines SQL Server in on-premises virtualized machines SQL Server on Azure Virtual Machine. This is SQL Server installed and hosted in the cloud on Windows Server Read more
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 Read more
This post was authored by the SQL Server Tiger Team Although SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and Read more
SQL Server is trusted by many customers for enterprise-grade, mission-critical workloads that store and process large volumes of data. Technologies like in-memory OLTP and columnstore have also helped our customers to improve application performance many times over. But when it comes to hierarchical data with complex relationships or data that share multiple relationships, users might Read more
