Dynamic Management Views Archives - SQL Server Training, SQL Server Video Courses, SQL Server Learning Kits, Online Classes, Hands On Labs

Free SQL video: New SQL Server 2014 Dynamic Management Views and Functions

Hi Friends, In this video, I am demonstrating how you can figure out the new SQL Server 2014 Dynamic Management Views in any version of SQL Server, yourself! Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources [...]

SQL Server 2014 new DMV – Figure It Out Yourself

Hi Friends, In this post, I am demonstrating how you can figure out SQL Server 2014 new DMV, yourself! From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box) And execute the following script: SELECT a.NAME sql2014 ,b.NAME FROM sys.sysobjects a [...]