fitomkarofficial@gmail.com

microsoft sql server error 1412 always on | Always on Error – The remote copy of database “DB Name” has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

by

This article guides to resolve, microsoft sql server error 1412 always on Why we receive SQL Server Error Message 1412 alwayson in sql server? Sometime database’s part HA stopped synchronizing. When we try to resume data movement we get SQL Server Error Msg 1412 or microsoft sql server error 1412 always on – The remote … Read more

create sql user azure sql | GRANT Database Permissions | AZURE sql system catalog views

by

This article guides to, create sql user azure sql or AZURE sql system catalog views When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin. SQL Azure does not allow the USE Transact-SQL statement,which means that you cannot create a … Read more

Troubleshoot Azure backup conflict with SQL database backup chain | Cannot perform a differential backup because current backup does

by

This Article guide to resolve, SQL Database backup failure due to AZURE VM Backup or Cannot perform a differential backup because current backup does not exist This article has step by step process of Troubleshoot Azure backup conflict with SQL database backup chain What is AZURE VM Backup? Azure Backup provides independent and isolated backups … Read more

How Do I shrink TempDB database? | TempDB not shrinking in SQL server

by

This article guides to resolve, How Do I shrink TempDB database? or empDB not shrinking in SQL server Temp DB is SQL server system database used for sorting, temp table creation, index maintenance jobs to rebuild index and many more. Sometime creation of temp table to sort data in large processing tempdb grow huge and … Read more

How to fix Error 9002 alwayson in sql server? | Resolve Always On availability databases in Recovery Pending or Suspect state in SQL Server

by

This article helps to resolved How to fix Error 9002 alwayson in SQL server? or Resolve Always On availability databases in Recovery Pending or Suspect state in SQL Server Whenever you see Database recovery pending SQL server error in always on in SQL server, SQL database went in to suspect mode or in recovery mode. … Read more

Get azvm size using PowerShell | How to get VM size on AZURE?

by

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

How to create Linked Server on SQL Server for azure SQL database? | create linked servers on SQL Server for in azure SQL database

by

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 service won’t start due to certificate issues| SQL service not starting | SQL Always ON issue

by

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

How do I copy files using AzCopy? | How to copy files from one container to another in Azure storage using AzCopy?

by

This Article describe, How do I copy files using AzCopy? or how to copy files from one container to another in Azure storage using AzCopy? AzCopy is a command-line utility designed for copying data to/from Microsoft Azure Blob, File, and Table storage, using simple commands designed for optimal performance. It can be used to transfer … Read more

How to eliminate duplicate records into result set in SQL? | Clear duplicate records from SQL server table | SQL drop duplicate in table

by

This article is about, How to eliminate duplicate records into result set in SQL? or Clear duplicate records from SQL server table As DBA we get requirement to clean up or remove duplicate records from SQL server database. This is required to free up some disk space or may be due to SQL server database … Read more