SQL: Different ways to generate sequence

There was a question from the op regarding adding a new column to a query output by generating the cyclic...

SQL Server 2016: JSON integration

Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...

SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)

Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...

My Interview published on Microsoft Technet Blog

Wish you a Happy New Year to all the readers and technical enthusiasts!!!
https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/
My interview is published on the Microsoft Technet blog...

PowerShell : Monitoring and Notification – Disk Space Alerts

“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”

Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...

SQL Server: Discuss Execute(SQL) At LinkedServer

Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...

SQL : How to Find Unused Indexes details

The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track  index usage details of the database. This DMV gives an information about...

PowerShell : CSV – Disk Space Report – Excel

Abstract
Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve...

PowerShell: Extending Modules – System Parameter measurement

The Microsoft Technet Guru Award  (August 2016) winning article  – Silver
PowerShell: Extending Modules – System Parameter measurement

PowerShell: Extending Modules – System Parameter measurement

Abstract
The...

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Table of Contents
IntroductionPre-requisitesData flowEnable xp_cmdshellDownloadSQL CodeOutputConclusionReferencesSee Also
Introduction
This article talks about one of SQL method to fetch the disk usage details...