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
SQL Server Availability group is HA and DR method configured on production server to offload the primary server performance and make databases available in case of disaster. SQL Server AG is available from SQL Server 2012. To configure SQL Server AG, we need to configure SQL cluster between two nodes which are part of SQL … Read more
This article describes, How to shrink log file in SQL server? or Shrink SQL log file SQL servers have two database file 1. MDF (Data File) and 2. LDF (Transaction Log file). LDF is SQL database transaction log file and when data operation happen data getting inserted into SQL server log file (LDF). Log files … 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
This article describes Creating a SQL Login with SQL Server Availability Groups or How do I create a login in SQL Server Availability Group? Logins in SQL Server: There are 2 types of logins can be created in SQL Server. Login with windows authentication: These users first need to be created in Active Directory and … Read more
This article describes about, How do I find backup history in SQL Server? or Last backup of SQL database in sql server What are Backups in SQL Server? SQL Server contains three type of backup which help you to recover data in case of disaster. SQL Server has FULL, Differential and T log Backup. Full … Read more
This Article guides, How to configure database mail SQL Server? or Configure Database Mail – SQL Server. Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine or Azure SQL Managed Instance. Your applications can send e-mail messages to users using Database Mail via an external SMTP server. The … Read more