Category Archives: knowledge

Delphix for SQL Server

I have learned about an interesting tool (https://www.delphix.com/) which is used to provide effective production copies to Developers in no time. This was implemented for Oracle environment for last couple of years. Now Delphix supports Always-On feature as well for … Continue reading

Posted in knowledge, SQL, Uncategorized | Tagged , | Leave a comment

Activedirectory – Group – user – membership validation tool

In any IT environment it is very important to understand how a distribution and security groups work. I have come across many employees with minimal knowledge on providing permissions to individuals and groups. I will just add very basic one … Continue reading

Posted in knowledge, Productivity, Uncategorized, Windows Server | Tagged , , , , | Leave a comment

(Free) Visual Studio Dev Essentials –SQL Developer Edition, 6 month Pluralsight subscription, and more…

I have installed SQL Server 2014 developer edition on my personnel laptop today. All you need to do is to join Visual Studio Dev Essentials and access benefits @ https://www.visualstudio.com/en-us/products/visual-studio-dev-essentials-vs.aspx. There are multiple other benefits also… Visual Studio team services … Continue reading

Posted in Azure, knowledge, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , , | Leave a comment

SQL Execution plan deep dive (03-Scan, Key Lookup)

Note: This blog is continuation to earlier 2 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) In the next few blogs, I will cover following topics which can be analyzed during … Continue reading

Posted in Execution Plan, knowledge, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

Isolation levels in SQL Server

I will try to explain Isolation Levels in simple language in this blog. Isolation level defines how a transaction must be isolated from resources or data modifications made by other transactions. Before we talk about different isolation levels we will … Continue reading

Posted in knowledge, SQL, SQL Server, Uncategorized | Tagged , | Leave a comment

Common uses of IDENTITY in SQL

In recent project I have used Identity column significantly, would like to write a small blog as quick reference: • Syntax: create table myTable(id int identity(1,1), name varchar(60)) • Seed and Increment value can be negative, default value of Seed … Continue reading

Posted in knowledge, Productivity, SQL Server | Tagged , , , , | Leave a comment

Quick File Compare tool (vim)

Yesterday, one of my developer modified huge script file but he used old version to modify. It was uphill task to understand the changes and correct it. I am not keen on any installations or add-in… vim (one of my … Continue reading

Posted in knowledge, Productivity, Windows Server | Tagged , , , | Leave a comment