A short SQL in Sixty Seconds video introduction to delayed durability in SQL Server 2014, in simple words, with code from my earlier example.
SQL SERVER – Live Plan for Executing Query – SQL in Sixty Seconds #073
A quick SQL in Sixty Seconds video on the live plan in SQL Server 2014, which uses sys.dm_exec_query_profiles to show a query plan while it still runs.
SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072
A quick SQL in Sixty Seconds video that explains cardinality estimation and performance in SQL Server 2014 in simple words, and how the new logic helps.
SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course
Learn SQL Server 2014 online with my latest Pluralsight course, SQL Server 2014 Administration New Features, covering what is new for DBAs in just over four hours.
SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift
Today is my birthday, and my gift to you is my latest course, Play by Play with Pinal Dave, where I show how I tune SQL Server performance.
SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071
Finding object dependencies in SSMS takes one right click on View Dependencies. I show how in this short SQL in Sixty Seconds video.
SQL SERVER – Difference Between SQL Login and SQL User – SQL in Sixty Seconds #070
What is the difference between a SQL Login and a SQL User? In simple words, a login is for authentication and a user is for authorization. A short video.