Learn this article to get computer efficiency Tips in case you are less experienced user. As a relatively new computer user, you might find yourself unhappy with how you are using the device. It takes longer to carry out certain...
This article will help you fixing SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database. We were getting below error in our SQL Server error log for one of our login. Login Failed...
Most cloud storage services offer a certain amount of free space. Managing iCloud Storage can be rather difficult. On the surface, 5GB that Apple offers for free seems pretty decent, right? Well, user stance changes once they realize that these...
Today, we will talk about cloud secrets management tool Hashicorp vault in this article. As we know, cloud services providers have presented numerous inherent features and tools to protect the cloud environment. We have seen cloud tools for monitoring, audit,...
Recently, my company has migrated all critical SAP systems from on prem Linux based Oracle databases to Azure Cloud windows based SQL Server. These are very high end machines on which very large SQL Server databases are running with Alwayson...
Sometimes we get alwayson connection timeout errors on availability group replicas. Always on Connection timeout or alwayson session timeout is same and must be configured as per Microsoft recommendation. SQL Server Session timeout for availability replica is the time (in...
SQL BETWEEN operator is used to get values between a range of data inputs. We can use SQL BETWEEN operator with SELECT, UPDATE, INSERT and DELETE statements. Range can be defined based on text, date or numbers values. Here i...
Microsoft always releases new features and enhancements as part of preview features in Azure Data Studio before making it publicly available for general use. Users can go ahead and check these features, give their feedback to Microsoft and based on...
Yesterday one of my teammate got a weird error while executing a T-SQL script. We are talking about SQL Server error 121 the semaphore timeout period has expired. Error details are showing below: A transport-level error has occured when receiving...
Authentication is a process to establish a successful connection. SQL Server provides two types of authentication modes to connect to their database instances. Authentication Mode is configured while installing SQL Server instance. We can also change SQL Server authentication mode...
We receive SQL Server error 802 when buffer pool of SQL Server instance is full and cannot grow further. Here, i will discuss about this error 802 insufficient memory available in the buffer pool in this article along with its...
Update Statistics in SQL Server is very important maintenance activity to keep database’s statistics up to date. This helps SQL Server query optimizer to generate optimum query plan and improve database performance as well. Here, i will explain the best...
Here we are going to discuss about top Cloud Data Center locations. Best Cloud Service Providers ensure to meet or exceed Tier 3 levels of security for their Data Center. Security layer of Clod Service Provider’s (CSP) Data center comprises...
CCSK stands for Certificate of Cloud Security Knowledge. The CCSK Certification is an individual certification that any person can take if they want to make their carrier in Cloud security. What is CCSK? The Cloud Security Alliance (CSA) has established...
Microsoft introduces a new feature called
Hybrid Buffer Pool in SQL Server 2019 CTP 2.1. Read this article to understand this feature.
