Everything SQL related and then some
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the series). In the first video we explored how Mary uploaded her bank statement into SQL Server and started her first analysis of the accounts. PART 1 http://www.youtube.com/watch?v=m4WXmhopmQQ…
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…
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…
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…
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…
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…
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…
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 made from a list. So the question is where and how will we use it. A common scenario where CHOOSE syntax would be helpful is when navigating…
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 format as oppsed to the mm/dd/yy format followed in the US. Till now we used to rely on the convert syntax to change the date into a…
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 what….