SQL Server 2016 is finally here. The quickest way to experience the magic of SQL Server 2016 is to create a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio…
Here is a Sneak Peek Preview of SQL Server 2016 and Cortana Intelligence by Tim Ford at SQL Server Magazine.The biggest features in the new edition of SQL Server are Always Encrypted, Stretch Database, integrated R language support in SQL Server, Cortana Intelligence, and the SandDance data visualization tool.
In this article Pankaj Kumar Choudhary explains some general purpose queries. Every developer should have knowledge of these queries. These queries are not related to any specific topic of SQL. But knowledge of such queries can solve some complex tasks and may be used in many scenarios.
SQL Server’s Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be…
This Data Driven session, goes over a brief overview of new featutes in SQL Server Management Studio and SQL Server Data Tools coming in SQL Server 2016. They also highlight topics such as new monthly updates, query analysis improvements, Wizard and Dashboard support for Standard Edition Availability Groups, the connection…
Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. This new ability is known as Stretch Database and the feature will be beneficial to those needing to keep transactional data for long periods of time and those looking to save…
Register and attend this live webcast on April 12th, 2016 hosted by Microsoft Technology Strategist Onur Dogruoz, You will learn about the enhanced performance features, complete cloud integration, and industry-leading security tools that are built in to SQL Server 2016. Stretch database: Migrate your historical data dynamically and transparently to the…
Exciting news! Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members. Microsoft is making this change so that all developers can leverage the capabilities that SQL Server 2014 has to offer for their data solution, and this is another step in making…
Companies that transform data into intelligent action are outperforming their competitors and will be the businesses of the future. Hear Microsoft CEO Satya Nadella and customers share how data insights are driving business transformation at the Data Driven Virtual Conference. Microsoft leaders will also share how customers are embracing data…
Microsoft announced plans to bring SQL Server to Linux. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. Microsoft is bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017. SQL Server on…