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

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 Oops !!! we forgot the link last time BTW Did you check out our new website !!! built in 24 hours it reflects our new design philosophy

Part 1 Buffer pool extension SQL 2014

In this series I am going to cover the feature Buffer pool extension in MS SQL Server. Now before we can discuss this feature it might be a good idea to define what a buffer pool is and why it needs extensions in the first place. The buffer pool is that part of the RAM…

Why I Train

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings from former participants who have taken the time to get back to me I have mentioned one such email below. Hi Jayanth,  This is Raja from Cognizant…

MUMBAI 18th Aug to 20th Aug

Training DBAs in Mumbai on MS SQL Server 2012 HA. Visiting the city after a short while hope to do more sightseeing this time around.

One of the best graphical representations I have seen in a while

A picture is worth a thousand words, a decent chart is probably worth a million. I have been conducting trainings on MS SQL Server Reporting services recently and an important point I can’t over emphasize is the look of the report. Creating the report is fine, anybody can do it, but the true developer is…