This article will guide you How to capture deadlock using extended events? What is deadlock? Deadlock is a situation in SQL Server where two or more transactions are waiting for each other to release a resource, such as a table or a row, that is locked by the other transaction. This results in a circular … Read more
This article guides. How to remove files from folder using PowerShell? or PowerShell delete files in folder older than specific date. Sometimes you need to delete old files from particular folder. There are many scenarios where you have to delete those files like deletion based on last modified or deletion based on file name etc. … Read more
This article guides to resolve, How to resolve Microsoft SQL Server, Error: 5120? | How to resolve CREATE DATABASE failed. Some file names listed could not be created. Sometimes you will get below error while attaching SQL Server database MDF file. This error cause due to file access issue. TITLE: Microsoft SQL Server Management Studio … Read more
This article guide to, Get azvm size using PowerShell or How to get VM size on AZURE? Many time we get requirement to Get all vms in subscription for audit purpose or to remove unwanted VM for cost saving purpose. We will have many virtual machines in different Azure subscription for all environment like PROD, … Read more
This article describes about, How to create Linked Server on SQL Server for azure SQL database? or create linked servers on SQL Server for in azure SQL database Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. SQL servers allow to do cross SQL queries between 2 databases present … Read more
This article provide guide for How to create SQL job in SQL server? Below script Create SQL job in SQL server using PowerShell. You can create same job on multiple SQL Server. This will automate process and reduce manual efforts to create same SQL Server jobs on Multiple SQL Server Instance. Step 1: Create List … Read more