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 [...]
Hi Friends, In this video, I am demonstrating how you can figure out the SQL Server 2014 new System Objects 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 (presentation [...]
Hi Friends, In this post I'm going to talk about SQL Server 2014 Resource Governor IO throttled. Resource Governor was introduced as an Enterprise Edition feature in SQL Server 2008 allowing DBAs to control/throttle CPU & Memory usage for a given workload or a set of workloads. There has been incremental enhancements to this feature [...]
Hi Friends, In this post I want to show you how you can find out SQL Server 2014 New System Objects, 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 sql14_objname ,a.xtype [...]
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 [...]
Hi Friends, Are you sure you have tested SQL Server 2014 In-Memory OLTP the right way? In one of my recent conversations with a customer, a senior DBA from the customer side expressed that he does not see ‘exponential’ performance when he converts on-disk tables to In-Memory tables. He further expressed that performance by ‘leaps [...]
