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…4 min read·Apr 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…5 min read·Nov 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.6 min read·Mar 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…2 min read·Jan 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…2 min read·Jan 12, 2021----
AjaykumarAWS Cloud SQL RDS backup and restore .Sql with rds backup and restoration : Prerequisite:2 min read·Dec 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…3 min read·Dec 7, 2020----
AjaykumarTempDB Performance Recomendation and Tempdb Growing Out of Control for Alert.1.Use #temp tables and @table variables5 min read·Sep 11, 2020----
AjaykumarHow to Migrate Database From Higher version to Lower version.Step1:4 min read·Jul 9, 2020----
AjaykumarComparing EC2 SQL SERVER (VM) VS RDS SQL(cloud database).SQL Server RDS features and disadvantages.3 min read·Jun 1, 2020----