Category Archives: knowledge

Onenote weekly backup

I have created Onenote on sharepoint, shared it across virtual team. All members of the project were actively using this. To my horror, I realize one of the section was accidentally deleted 😦 By default Onenote will be backed up … Continue reading

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

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