Fix: HTML5 Video not playing when deployed to azure

The HTML5 video added in the webpage was playbacking successfully in my developer environment. But, why deployed to client's Azure web app it was not playing at all. I suspected for any script errors but browser's console window was empty. Later I figured out that we need to specify mime type in web.config of the website for this to work.

Below is a quick peek of web.config file.

<configuration>
	<system.webServer>
		<staticContent>
			<remove fileExtension=".mp4" />
			<mimeMap fileExtension=".mp4" mimeType="video/mp4" />
			<remove fileExtension=".webm" />
			<mimeMap fileExtension=".webm" mimeType="video/webm" />
			<!-- Add your mime type here -->
		</staticContent>
	</system.webServer>
</configuration>



 

Hope this helps.

Mixed Reality Techday event at Kochi

It's always great when you work with state-of-the-art technology. HoloLens is one such device. A unique, one of it's kind device. And more greatful when you share the knowledge with the community and mentor them.

I am part of technology community - K-MUG. Last month, we decided to take break from all seasoned topics and shifted gears to bring exciting and state-of-the-art technology to passionate audience. We hosted an exclusive event on Augmented Reality and Mixed Reality titled - Mixed Reality TechDay. I had unique opportunity to address an awesome crowd of technology enthusiasts - engineers, professionals, students and all passionate individuals.

We are overwhelmed to go house full.

An event that we dare claim went over the moon based on the feedback and the smiling faces of 60+ attendees.

More photos are available in our Facebook community page. Feel free to join and attend our next events.

Thanks.

 

Paging re-imagined in SQL Server

When we have huge records in database, it is always wise to implement paging instead of querying all the data at once. Gone are the days were we wrote long line of code to implement paging. With SQL Server 2012, we can do that in just few lines. Here is a quick sample script to query 10 records after 50th record.

 
Declare @PageIndex Int    -- current page index
Declare @PageSize Int    -- fetch this much record
Declare @Offset Int    -- number of rows to skip
 
Set @PageIndex=5
Set @PageSize=10
Set @Offset = @PageIndex * @PageSize
 
Select * From DemoUser
    Order By Id Offset @Offset Rows
    Fetch Next @PageSize Rows Only

 

Reference: OFFSET FETCH Clause

Hope this helps.