How Can I Check the Isolation Level for a Specific SQL Server Database?

You can easily get details about the isolation level for a given SQL Server database by using the below T-SQL script: USE [DatabaseName]; GO DBCC USEROPTIONS; GO   Example from our Demo Environment:   Enroll to our Online Course and Learn More about SQL Server Administration Check our online course on Udemy titled “Essential SQL … Read more…

Within Which Context Does SQL Server Access Network Resources?

In this post, we discuss about the context within which SQL Server accesses network resources via the Database Engine and SQL Agent.   How Does SQL Server Access Network Resources When you run adhoc queries (i.e. execute stored procedures, use OPENROWSET, etc.) targeting resources outside the scope of the SQL Server instance (i.e. a file … 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.18 – Benefits of Using Database Stored Procedures

Check our Tip of the Week, where in this week, we discuss about the benefits of using database stored procedures. Tip of the Week #18 Using stored procedures in your database processes, can be very beneficial, not only for performance, but also for security and code reuse. Below, we list some of the main benefits, … 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…

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…

How to Fix SQL Server Agent Not Showing in a Failover Cluster

Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI). SQL Server Agent not showing in Failover Cluster If you have a SQL Server failover cluster, and you cannot see SQL Server Agent … Read more…

Tip of the Week No.9 – SQL Server Service Account Info using T-SQL

Hi friends! This week’s tip, is about how you can easily retrieve, SQL Server service account info, using T-SQL.   Tip of the Week #9 An easy way to find the service accounts for the main SQL Server services such as Database Engine and SQL Server Agent, is to execute the below T-SQL statement within SSMS: … Read more…

SQL Server replication requires the actual server name to make a connection to the server – How to Resolve it

When working with SQL Server replication and you try to add a new subscription under a local publication, under certain circumstances you might end up with the error message: Cannot connect to … SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name (Replication.Utilities).   … 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…

Tip of the Week No.6 – About SQL Server Temporary Tables

Check our Tip of the Week, about SQL Server Temporary Tables.   Tip of the Week #6 Local temporary tables in SQL Server, are defined by using the # (single hash) sign and they are only available for the session in which they were created in. After the session ends, local temporary tables are automatically … Read more…

New Free Service: SQL Server OS Requirements Info

Hi friends! Today we announce another new free online service just for you, the SQL Server Community! This new service is titled “SQL Server OS Requirements Info“, and as the name implies, by using this service, you can quickly retrieve useful information, about the OS requirements for any version and edition of SQL Server! You … Read more…