System.IO.FileLoadException: could not load file or assembly…

Hi friends, in this article, we will be discussing about, how to resolve the below error, when working with CLR assemblies in SQL Server: An error occurred in the Microsoft .NET Framework while trying to load assembly id… The server may be running out of resources, or the assembly may not be trusted. Run the … Read more…

The Database Engine system data directory in the registry is not valid

Hi friends, in this article, we will be discussing about the case where you might be updating or patching a SQL Server instance, and under certain circumstances you get the error message: The Database Engine system data directory in the registry is not valid.   The Error Message The exact error message in the above … Read more…

SQL Server 2022: What’s New – New and Enhanced Features (Course Preview)

Hi friends, it is with great pleasure, that we are announcing today our brand new course, titled: “SQL Server 2022: What’s New – New and Enhanced Features“. In this article, you can learn more about the course and what you can learn by attending the course.   Introduction – What is this course about? SQL … Read more…

Comparison of SQL Server Deployment Options on the Azure Cloud Platform

Hi friends, in this article, we will be performing a comparison of the SQL Server deployment options on the Azure cloud platform.   Overview of SQL Server Deployment Option on Azure When it comes to options for deploying SQL Server databases on the Azure cloud platform, there are many options that can cover all needs. … Read more…

An existing History Table cannot be specified with LEDGER=ON – How to Resolve

Hi friends, in this post, we will be discussing about the SQL Server 2022 error message: An existing History Table cannot be specified with LEDGER=ON.   What are Ledger Tables in SQL Server 2022? Ledger tables are special tables originally introduced in SQL Server 2022. They constitute a major part of the security enhancements in … Read more…

initerrlog: could not open error log file. Operating system error=3 … – How to Resolve It

Hi friends, this post, discusses about how you can resolve the following SQL Server-related error message: initerrlog: could not open error log file ”. Operating system error=3 (The system cannot find the path specified).   What does the above error message mean? The above error message, as it describes, means that SQL Server cannot find … Read more…

SQL Server Lifecycle Information – New Free Service

Hi friends! Today, we are pleased to announce a new free online service on SQLNetHub, titled “SQL Server Lifecycle Information“. By using the free service “SQL Server Lifecycle Information“, as the name implies, you can easily get useful SQL Server lifecycle information such as: release date, mainstream support end date and extended support end date. … Read more…

Tip of the Week No.17 – Modern Servicing Model for SQL Server 2017 and Later

Check our Tip of the Week, where in this week, we discuss about the modern servicing model for SQL Server 2017 and later. Tip of the Week #17 Starting with SQL Server 2017, the servicing model for SQL Server has changed. One of the major changes, is that Microsoft releases a series of Cumulative Updates … Read more…

Frequently Asked Questions About SQL Server In-Memory OLTP

Hi friends! In this article, we will be answering different frequently asked questions about SQL Server In-Memory OLTP. We will begin with the basics and then move to more advanced-level questions. What is SQL Server In-Memory OLTP? SQL Server In-Memory OLTP, is a powerful engine, seamlessly integrated into the SQL Server Engine (version 2014 and … Read more…

Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve

Hi friends! In this post, which is related to SQL Server failover clustering, we will talk about how you can resolve the issue of not being able to add a node to a Server failover cluster, due to the fact that one of the service accounts (i.e. SQL Server or SQL Server Agent, or both) … Read more…

[Resolved] Operand type clash: int is incompatible with uniqueidentifier

When developing in SQL Server, under certain circumstances, you might get the error message: Operand type clash: int is incompatible with uniqueidentifier. In this article, we will be discussing about, why you got that message, what’s wrong in your T-SQL script and how to fix it.     About the above “Operand type clash: error … Read more…

How to Resolve: The feature “Scale-out deployment” is not supported in this edition of Reporting Services

Under certain circumstances, when upgrading SQL Server Reporting Services Standard Edition, for example from SSRS 2012 or 2014 to SSRS 2017 or 2019, you might get the following error message when trying to start the Reporting Services service: “The feature “Scale-out deployment” is not supported in this edition of Reporting Services“. But first, let’s discuss … Read more…