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 […]
Which is better Count (*) or Count (id)?
While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]
SQL Server DEV and SSDT – MINDTREE – CHN – DEC
Some feedback from the training What did you like most about the training? Knowledge on SQL Trainers end to end knowledge about the tool. Explained concepts with hands […]
SQL 2012 Administration Societe Generale – JAN
Some feedback from the training What did you like most about the training ? Trainer’s skill and experience in technology Skilled knowledge pool of the Trainer