Monthly Archives: May 2014

Doing something awesome

By | May 29, 2014

Do you get up in the morning thinking “It’s an awesome day. I feel like changing the world. I am going to do something amazing and it’s going to change the way I see the world and the world sees me”? If yes I know exactly how you feel, if not I have only one… Read More »

What’s next?

By | May 26, 2014

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 for it. Performance Resource Governor OLTP in Memory Tables Identifying IO Bottle necks Optimistic Concurrency Understanding execution plans Security Contained Databases SQL Injection Protecting against SQL Injection… Read More »

PART 2 -Upgrading the Amazon AWS Cloud EC2 instance

By | May 23, 2014

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. In this video we upgrade the server from the micro instance to the m1.small instance type. The link is provided below. Please ping me back if you… Read More »

Upgrading the Amazon AWS Cloud EC2 instance and Attaching a new volume.

By | May 23, 2014

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 more detailed description but I am off to Microsoft Ventures: ThinkNext & Demo Day and am already running late. Please enjoy the video and do ping me… Read More »

It’s OVER

By | May 22, 2014

Those who have been following the series of blogs today will notice a trend in the topics being picked up. These are all features that are launched in SQL 2012 but more importantly they all reflect the T-SQL equivalent of similar functionality available in SSAS. It makes sense considering the push MS has been making… Read More »

At long last Pagination

By | May 22, 2014

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 SQL server. Typically this was handled in the front end code by downloading the entire result set and then filtering as required based on client input however… Read More »

Video on MS SQL Server Partitioning

By | May 21, 2014

  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 multiple files and partitioning. It also touches upon the effects of proportional filing and its impact on IO throughput. More importantly it explains when to use… Read More »