Video: SQL Server Backups And Restore (Part1 - Backup)

It is hard to imagine not backing up the production databases periodically. This facilitates recovery from accidental data deletion or complete database corruption. BUT only when you excellently know which type of Backup or combination of Backups you really need.

This video focus on all four types of backups in Microsoft SQL Server.

SQL Server Backups And Restore (Part1 - Backup) from aasim abdullah on Vimeo.

Video:SQL Server Performance Tuning with Wait Statistics (PageLatch - PageIOLatch - Latch)

3rd video of our Waits and Queues series. Latch waits are common and could be an indication of serious performance issues, but understanding these waits was never  that simple...

SQL Server Performance Tuning with Wait Statistics (PageLatch - PageIOLatch - Latch) from aasim abdullah on Vimeo.

Video: SQL Server Performance Tuning with Wait Statistics (CXPACKET)

CXPACKET is a common wait type, resulted by parallel query execution. But does occurrence of CXPACKET wait is always a sign of performance problem???

A lot more written. But here is our second animated video to learn it in a very simple way.

SQL Server Performance Tuning with Wait Statistics (CXPACKET) from aasim abdullah on Vimeo.

Video: SQL Server Performance Tuning with Wait Statistics (Introduction)

To investigate performance bottleneck, Wait Statistics is a power full tool which a DBA like to use on priority. Understanding waits is not that difficult but the way books and blog entries describe, makes it more complicated.

This is first out of 5 videos series. A simple way to understand internals of WAITS and how they can effectively be used to resolve SQL Server performance problems.

SQL Server Performance Tuning with Wait Statistics (Introduction) from aasim abdullah on Vimeo.

Video: SQL Server 2014 - In Memory OLTP (Data Durability)

SQL Server 2014 - In Memory OLTP as per its name, keeps all the rows for memory optimized tables inside memory. What would happen, if hardware fails. Don't worry SQL Server 2014 take cares… Checkout our third and last animated video of this series.

SQL Server 2014 - In Memory OLTP (Data Durability) from aasim abdullah on Vimeo.

----------------------------------------------------------------------------------------
Don't miss other videos of this series
----------------------------------------------------------------------------------------
SQL Server 2014 - In Memory OLTP (Overview)
SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control)

Video: SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control)

SQL Server 2014 - In Memory OLTP is 30X faster then existing versions, because of its new in memory ROW structure. Lets have a look, how concurrency for these in memory rows is controlled. 



SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control) from aasim abdullah on Vimeo.

----------------------------------------------------------------------------------------
Don't miss other videos of this series
----------------------------------------------------------------------------------------
SQL Server 2014 - In Memory OLTP (Overview)
SQL Server 2014 - In Memory OLTP (Data Durability)

Thin Black Lines: SQL Server 2014 - In Memory OLTP (Overview)

Its true that our mind create pictures to understand and remember things. Then why just describe complex SQL Server internals in words. Here is our first video from our new project named "Thin Black Lines". Lets start a new era and learn these complex concepts through animated videos.

Learn SQL Server 2014 - In Memory OLTP, in just less than 5 minutes.



SQL Server 2014 - In Memory OLTP (Overview) from aasim abdullah on Vimeo.

----------------------------------------------------------------------------------------
Don't miss other videos of this series
----------------------------------------------------------------------------------------
SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control)
SQL Server 2014 - In Memory OLTP (Data Durability)

SQL Server Denali: Partition Limit Enhancement

Microsoft SQL Server Denali (CTP 3) supports up to 15,000 partitions by default. In earlier versions (upto SQL Server 2008), the number of partitions was limited to 1,000 by default. Though partition number was enhanced in SQL Server 2008 SP2, but for only Enterprise Edition.

------------------------------------------------------------------------------------
Read More about SQL Server 2012 (Code Name: Denali) 

·         Introducing New Edition "Business Intelligence"

·         Changing Backup Files Default Path is More Easy Now

·         New Backup/Restore Options

·         CTP 3 Product Guide Released

·         TRY_CONVERT(), a Good Addition

·         Format(), a Most Wanted Function

·         Get Date/Time from Parts

·         New Function to Get Last Date of Month

·         IIF Logical Function

·         A New More Flexible Create Index Dialog box