In today’s article I will describe SQL Server Service Pack Upgrade Best Practice. Sometimes you may want to upgrade the service pack of the version …
Read More »MSSQL
What is Microsoft Azure?
In today’s article, we will look for an answer to the question of What is Microsoft Azure? Azure is Microsoft’s Public Cloud application and infrastructure …
Read More »How To List Object Level Permissions in SQL Server
Sometimes we may need to list object level permissions. I will share a script that list object level permissions in SQL Server in this article. …
Read More »Moving all Nonclustered Indexes to Another Filegroup
On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I …
Read More »How To Connect Azure Database From SQL Management Studio and from Azure Portal
We will learn how to connect azure database from sql management studio and from azure portal in this article. How to connect to azure sql …
Read More »SQL Server Configuration Manager Not Found
SQL Server Configuration Manager may not found on your server event if you installed SQL Server on that server. If you have installed any version …
Read More »SQL Server on Azure Kubernetes
In this article, I will be explaining how to create a Kubernetes cluster in Azure Kubernetes Service, and how to install SQL server on Azure …
Read More »Metricbeat MSSQL Dashboard
Metricbeat is a useful tool that enables us to get data from more than one data source and load ready dashboards or to create dashboards …
Read More »This secondary replica is not connected to the primary replica
If you get the error “This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED”, it means that you are …
Read More »How To Find Deleted Objects in SQL Server
This article contains script to find deleted objects in sql server. It happened to every database administrator. Application developers or your supervisors may ask you …
Read More »