AjaykumarAzure SQL — Elastic Job Agent to configure maintenance jobs for ALL Azure Single pool database or…SQL server agent is available only in managed instances and not in the single databases. To schedule and execute jobs on single databases…Apr 18, 2022Apr 18, 2022
AjaykumarAuto Scale Azure SQL DB using Azure Logic Apps PowerShell Script and SQL Agent .There are certain scenarios in our applications when there is more load on the systems and performance may take a hit during that time. In…Nov 19, 2021Nov 19, 2021
AjaykumarConfiguring AlwaysOn with Log Shipping solutLaunch 4 AWS EC2 machines .one for add and two server for Always on .one for DR server.Mar 11, 2021Mar 11, 2021
AjaykumarMail Configuration for AWS RDS (PASS) SQL server.Create SQL server user with same credentials (Ec2 Instance and RDS Instance same ) 2.Create linked server RDS to EC2 Machine. Link…Jan 25, 2021Jan 25, 2021
AjaykumarIf Model database corrupt in SQL Server How start SQL server.Model database importance ,what will happen if our Model database corrupt or any .mdf or .ldf missing .Model database is also most…Jan 12, 2021Jan 12, 2021
AjaykumarAWS Cloud SQL RDS backup and restore .Sql with rds backup and restoration : Prerequisite:Dec 9, 2020Dec 9, 2020
AjaykumarBasic performance Tunning Of Sql server.1. Use EXISTS instead of IN to check existence of data. 2. Avoid * in SELECT statement. Give the name of columns, which you require. 3…Dec 7, 2020Dec 7, 2020
AjaykumarTempDB Performance Recomendation and Tempdb Growing Out of Control for Alert.1.Use #temp tables and @table variablesSep 11, 2020Sep 11, 2020
AjaykumarComparing EC2 SQL SERVER (VM) VS RDS SQL(cloud database).SQL Server RDS features and disadvantages.Jun 1, 2020Jun 1, 2020