Monthly Archives: February 2016

SQL Execution plan deep dive (02-Basics II)

This blog is a continuation to SQL Execution plan deep dive (01-Basics I) which explains what an execution plan is and different execution plan components. How to view different execution plan details: Execution plan can be viewed in 3 different … Continue reading

Posted in Execution Plan, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

SQL Execution plan deep dive (01-Basics I)

Majority of DBAs and Developers think about converting Scan into Seek after analyzing execution plan. This is a good start but is not sufficient to address most of the performance problems. I will start with basics in this blog and … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , | 2 Comments

Basics of Modules in Powershell

A Module is a set of Powershell functionalities grouped together which can be shared across, installed and reused. Typically Microsoft publishes different modules for each of its products (Example: Azure, Active Directory, SQL, etc…) A module can technically be only … Continue reading

Posted in Azure, Uncategorized | Tagged , | Leave a comment

Execute As in SQL (Similar to Runas in Windows context)

When we need to execute any SQL statement with other user context we have to use EXECUTE AS statement to impersonate other user access. Impersonation can be done as different login or different user.This is similar to RunAs in windows … Continue reading

Posted in Referene, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a 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