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
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 describes, Connect azure sql database using azure active directory user or cannot connect to XXXXXX.database.windows.net error 18456 SQL Server Authentication Method : There are 2 types of authentication mode in SQL server Virtual Machines. Windows AuthenticationIn Windows Authentication mode, when you’re using SQL Server from the same computer as where it’s installed, SQL … 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 describes, Detach And Attach Database in SQL Server or Detach multiple databases using sp_detach_db What happens when you detach a SQL database? If you want to move database from one SQL server instance to another SQL Server instance, we can use detach method. We can use SSMS to detach database from SQL Server. … Read more
This Article Describe, how to list all file names from a folder and sub-folders? or SQL Server Query to List Files Most of the time as DBA we get request to restore multiple databases. We can perform SQL Server database restore using SSMS or T-SQL Restore commands.Doing this database restore task in SSMS, we need to restore database … 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
This Article guides, How do I create a disk space alert in SQL Server? or How to solve disk space issue in SQL Server? Many time we face disk space issue on SQL Server on Azure managed instance. If we configured alert for low disk space this can help to avoid database getting down. SQL … Read more