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 […]
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 […]
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
SQL 2014 ADMIN, DEV – Wells Fargo – JAN
Some feedback from the training What did you like most about the training? -Quite impressed by the way Jayant taught Performance tuning -In depth explanation of all […]
Storing the MDF and LDF files of SQL Server on Azure Storage Part 2
In this second part on the series of how to add mdf and ldf files to Azure Storage we need to create a credential in the database in […]