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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Using MS SQL Server to work with assemblies (CLR)
A brand new video uploaded on YouTube on how to use CLR assemblies in MS SQL Server. Please share and like and we look forward to comments. https://www.youtube.com/watch?v=5sOlIIC-UXg […]
Helpful post on changing wordpress site file upload limit
Recently while migrating a client’s wordpress site from wordpress.com to Amazon AWS we encountered a peculiar problem which should not happen in the real wolrd. The client blog […]
Training DBA from other countries
Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep […]