Monthly Archives: March 2015

Configuring User Defined Server Roles in MS SQL Server

In this quick video I cover how to setup User Defined Server Roles in MS SQL Server, we use this feature to provide granularity to the DBA permissions based on the job role.

Video on how to use Schema Compare Option available in SSDT

In this video we cover how to use the Schema compare option within MS SQL Server Data Tools the Visual Studio IDE that comes as the replacement for BIDS. The video covers how to create a project followed by making changes and detecting the change and then how to sync or merge the changes.

Hope you enjoy the video and as always looking forward to any feedback

Training MSBI professionals in Wells Fargo (MAR)

Always looking forward to training BI professionals since I am fascinated by how data is getting used in the decision making process. And doing this training for Wells Fargo is even more special since we have a long standing relationship with the company. The training marks the start of a very busy schedule this year with training all over India and on almost every aspect of SQL Server.

Performance Tuning CPU issues in MS SQL Server – Indexes

In this video we cover how the correct use of Indexes can help elimintae CPU bottlenecks , we cover how to identify CPU issues and a few different ways the issues can be resolved.

Performance Tuning CPU issues

The video is ment to provide a starting place for novices to undertsand the role played by SQL Server indexes in improving performance as well as resource utilization.

PS:- there is a correction the column width is 512 bytes and not 512 KB

Which is better Delayed Durability or Optimistic Concurrency

A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down to the basic task at hand both essentially improve write (and in the latter’s case read) performance, so the question was can they be used together, do their performance improvements add up? If enabling delayed durability does it make sense to do it on tempdb or the user database? Some interesting results come out of this video and some weird behavior when MAXDOP =1 but more on that in the next video.

Here’s the link and please feel free to let me know your thoughts.

Sometimes common sense takes a back seat to BI

This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime back about game theory and how it can help decide the outcome of certain business cases. I came across two instances in the last week where game theory won over the end user. If you remember my last blog post you would be aware about how in economics the best thing for the industry is to pursue what’s best for the individual instead of the collective good. In other words, it pays to be selfish.

I was recently having a discussion where we were evaluating the cost benefit of having a Diesel generator vs. an invertor. Here are some facts

An invertor costs about 15000 INR + 1000 for maintenance every 2-3 years.

The table indicates a quick calculation done on the viability of a Genset

** fuel qty is in Ltrs

I have an invertor at home which has been used for 5 years now, the additional load of the invertor has increased the electricity bill by 200 INR/month which translates to 2400 INR per year (This is even when the power is out for 4-5 hours a day during peak summer).

Now here is my question:

If you live in an apartment with 250 flats and you have an invertor for personal use and a genset for common area (lighting, STP and Lifts) your bill would be 200 INR (inverter cost) + 133 INR (diesel costs) = 333 INR per month as opposed to 762 INR per month. In order words, you can buy a brand new invertor every 2.5 years. In addition to this, you also have the advantage of not having to pay the maintenance bill while you are away on vacation for a month or if you and the Mrs go to work during the day you don’t need to pay for the time the invertor is running during the day time which in Bangalore is when most of the power cuts happen.

Here are some more facts for your consideration, the price of diesel has almost doubled in the last 5 years

Avg duration of power cuts in Bangalore, you will notice I grossly underestimated the Avg to 1 hour per day when the truth is it’s typically 3 hours per day.

This is from an official government report published in 2013.

So in conclusion, fuel prices are going to go up, as summers get hotter the available water to run Hydel projects will reduce resulting in more frequent power cuts, the population of Bangalore will increase in the same rate as the last 3 years increasing the gap between supply and demand.

Now imagine if everybody who read this purchased an invertor and then went on to donate their invertor to a poor family after 3 years and bought a new one with the money saved. We could potentially rid Bangalore of an energy crisis within 10 years not to mention cleaner air with fewer gensets running.

So coming back to my question, Why do so many apartments have Genset instead of Invertors?