Category Archives: knowledge

QueryStore – Regressed queries based on execution count

Posted on January 17, 2020 by vijred

Handy TSQL statement to find gergressed queries on a given time based on execution count. I had a scenario to validate if application is executing any statements more frequently on a given time. Following SQL can be used to find … Continue reading →

Posted in knowledge, Performance, Script, SQL, SQL Query, Uncategorized | Tagged , , , , , | Leave a comment

What is azure sql database elastic pool split instance problem

Posted on May 25, 2019 by vijred

Azure sql database elastic pool split instance problem is a very rare phenomena which could impact resource usage metrics of elastic pool. In this post I will cover how resource metrics are impacted, sample monitor, example of an impact. How … Continue reading →

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

Onenote weekly backup

Posted on September 28, 2017 by vijred

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

Posted on June 2, 2016 by vijred

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

Posted on April 21, 2016 by vijred

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 , , , , | 1 Comment

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

Posted on April 7, 2016 by vijred

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)

Posted on March 3, 2016 by vijred

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

Posted on February 5, 2016 by vijred

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

Posted on August 12, 2015 by vijred

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)

Posted on June 24, 2015 by vijred

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