If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it into a video. Just as a reminder, I will be delivering this presentation at the SQL Saturday in Columbus, Ohio on July 16th and then again…
Microsoft announced today that New MCSA certifications are out for both Windows Server 2016 http://bit.ly/295AIN0 and SQL Server 2016 http://bit.ly/295AWUG. Upgrade exams are also available for those who already have earned an MCSA on Windows Server 2012 or SQL Server 2012.
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…