Monthly Archives: March 2015

Configuring User Defined Server Roles in MS SQL Server

By | March 21, 2015

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. https://www.youtube.com/watch?v=uCDn9KwNUm8

Video on how to use Schema Compare Option available in SSDT

By | March 21, 2015

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. http://youtu.be/rNL3Ieev2CQ… Read More »

Training MSBI professionals in Wells Fargo (MAR)

By | March 19, 2015

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… Read More »

Performance Tuning CPU issues in MS SQL Server – Indexes

By | March 18, 2015

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… Read More »

Which is better Delayed Durability or Optimistic Concurrency

By | March 10, 2015

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… Read More »

Sometimes common sense takes a back seat to BI

By | March 9, 2015

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… Read More »