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: Searching a query result from the table with LIKE operator with string in %% always takes a huge time. This happens because, A LIKE with a leading % cannot …
Continue reading Like operator searching so slow in 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: SQL Server 2008 introduced something that’s called “Slipstream Installation” and it’s exactly what you need – a way for you to deploy a SQL Server instance …
Continue reading Slipstreaming easy steps from SQL Server 2012 onwards
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 purpose of writing this post on what SQL version supported with what Windows version is because one of onshore client wanted to migrated its …
Continue reading Working versions of SQL Server on Windows 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 …
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
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.
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
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
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
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 …
ADsql-Tech Forever 
You must be logged in to post a comment.