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: 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

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: 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

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

SQL Server Architecture – THE LIFE CYCLE OF A QUERY-Part 2

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. Lets Begin:- In this series, we will walk through life cycle of SQL server. Its SQL server 2012 architecture, we have many more new and advanced …

Continue reading SQL Server Architecture – THE LIFE CYCLE OF A QUERY-Part 2

SQL Server Architecture – THE LIFE CYCLE OF A QUERY-Part 1

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. Lets Begin:- In this series, we will walk through life cycle of SQL server. Its SQL server 2012 architecture, we have many more new and advanced …

Continue reading SQL Server Architecture – THE LIFE CYCLE OF A QUERY-Part 1

Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 5

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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 5th part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 5

Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 4

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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 4th part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 4

Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 3

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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 3rd part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 3

Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 2

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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 2nd part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 2

Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 1

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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 1st part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 1