Here are lists of topics we are planning to include in the upcoming blogs. If you would like to see any topics added or covered sooner, please vote […]
PART 2 -Upgrading the Amazon AWS Cloud EC2 instance
The days almost over but we just managed to finish uploading Part 2 of the video on how to upgrade the instance type of your Amazon EC2 instance. […]
Upgrading the Amazon AWS Cloud EC2 instance and Attaching a new volume.
Today’s video explains how to implement a new volume and upgrade an existing instance of AWS EC2 to a higher hardware configuration. Sorry I couldn’t put in a […]
At long last Pagination
MS SQL Server 2012 introduced a very nice feature for developers with the PAGINATION OFFSET Syntax. It has always been a challenge to work with pagination in MS […]
CHOOSE, Is MS really giving a choice?
In this blog we are going to talk about a little known T-SQL Command called CHOOSE. As its name suggests it allows some kind of selection to be […]
Working with FORMAT
For a developer working on MS SQL server the correct formatting of data has always been a challenge. In India when working with dates we follow the dd/mm/yy […]
Video on MS SQL Server Partitioning
As promised here is a short video to start of the series on SQL Server partitioning. The video covers the difference between simply placing files in Filegroups with […]
MS SQL Performance tuning: – Partitioning explained
Today I am going to do a quick one hour session explaining partitioning. We will cover the difference between partitioning and placing tables in Filegroups, How to implement […]
In Memory OLTP – New feature in SQL 2014
We saw this coming with the demand for highly transaction database becoming more frequent clubbed with the need to store data in very large sets. Naturally one precludes […]