SQL Server 2014

/Tag:SQL Server 2014

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 [...]

By |September 3rd, 2014|SQL Server Videos|1 Comment

Free SQL video: SQL Server 2014 New System Objects

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 [...]

By |September 3rd, 2014|SQL Server Videos|0 Comments

SQL Server 2014 Resource Governor – Is Write IO throttled?

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 [...]

By |April 15th, 2014|SQL Server|1 Comment

SQL Server 2014 New System Objects – Figure It Out Yourself

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 [...]

By |March 15th, 2014|SQL Server|0 Comments

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 [...]

By |February 15th, 2014|SQL Server|0 Comments

SQL Server 2014 In-Memory OLTP – Have You Tested It The Right Way?

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 [...]

By |January 15th, 2014|SQL Server|4 Comments