Send SQL query results/output as attachment(csv or text) with formatted data over email from Azure SQL managed instance/on-premises SQL server

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: We received a requirement from one of the our client to setup an automated email on Azure Managed instance which will enable DB email to …

Continue reading Send SQL query results/output as attachment(csv or text) with formatted data over email from Azure SQL managed instance/on-premises SQL server

What is IP address of Azure SQL managed instance

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Generally, on-premises SQL server, SQL on azure, it has fixed private IP address based on number of NIC has been installed/configured or assigned to the …

Continue reading What is IP address of Azure SQL managed instance

Trying to create E-mail alerts in Azure SQL managed instance but it’s fails.

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Setting up DB email and getting email delivered successful looks quite simple in on-premises SQL server. Even while configuring DB email on Azure SQL managed …

Continue reading Trying to create E-mail alerts in Azure SQL managed instance but it’s fails.

Set up and troubleshoot database mail for Azure SQL DB Managed Instance

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: The lack of DB Mail on Azure SQL DB Single Database or Amazon RDS is a major blocker to PaaS adoption. Now with Managed Instance, …

Continue reading Set up and troubleshoot database mail for Azure SQL DB Managed Instance

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: In this blog, we will take a look at why it is essential to leave AUTO CLOSE database option turned OFF for a Production or a Non-Production SQL Server …

Continue reading SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Why %string% Is Slow in SQL server, convert scan to seek

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Users expect every application to have a built-in blazing-fast search functionality.  To pull that off, developers build search queries that let users enter a string, …

Continue reading Why %string% Is Slow in SQL server, convert scan to seek

How to remove a bad execution plan from plan cache in SQL server on-premise and Azure SQL database (PaaS)

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: let us assume, everything is going well, your SQL server is with low CPU utilization, high Page Life Expectancy, few fragmented indexes and updated statistics …

Continue reading How to remove a bad execution plan from plan cache in SQL server on-premise and Azure SQL database (PaaS)

Troubleshoot orphaned users (SQL server &Azure Synapse Analytics)

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Orphaned users in SQL Server occur when a database user is based on a login in the master database, but the login no longer exists in master. This …

Continue reading Troubleshoot orphaned users (SQL server &Azure Synapse Analytics)

Always ON Endpoint: The server principal owns one or more endpoint(s) and cannot be dropped (Microsoft SQL Server, Error: 15141)

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: It is very common for a DBA to set up AlwaysOn in a SQL environment and whoever creates the Availability Group is, by default, the …

Continue reading Always ON Endpoint: The server principal owns one or more endpoint(s) and cannot be dropped (Microsoft SQL Server, Error: 15141)

SQL Server Always ON Replica can not Connect To The Availability Group

Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: SQL Server uses an ‘End Point’ To talk to other SQL Servers Replicas within an Always On Availability Group(AAG). The most common problem we notice …

Continue reading SQL Server Always ON Replica can not Connect To The Availability Group