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…
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…
Do you want to learn what all the different pieces of Azure are available. Well, here is a Clickable version of the Azure Periodic table. This is an excellent resource to get you started in the Azure world.
SQL Server 2016 public preview now available! Three weeks ago at Microsoft Ignite the next major release of Microsoft’s flagship database and analytics platform was announced. Today over at the SQL Server Blog they are announcing the first public Community Technology Preview (CTP2) for SQL Server 2016. This public preview gives…
Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world. The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Find out more…