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…

How To Manually Remove a Report Server Instance from a Power BI Report Server Scale-Out Deployment Configuration

Hi friends. In this article, we will be discussing about, how you can manually remove a Report Server instance from a Power BI Report Server Scale-out deployment configuration.   Why Manually Removing a Report Server Instance from a Power BI Report Server Scale-Out Configuration? There can be many reasons for doing that. However, the most … Read more…

Happy New Year 2022!

Hi friends, A new year has come! We would like to wish to you and your loved ones, Happy New Year 2022! At SQLNetHub, we will continue providing you with high quality technical articles, videos, online courses, and other resources! Best wishes, for a healthy, creative new year! Best Regards, Artemakis

Tip of the Week No.21 – Intelligent Performance Features for Azure Database for MySQL

Hi friends! Check our Tip of the Week, where in this week, we discuss about the Intelligent Performance Features for Azure Database for MySQL. Tip of the Week #21 The two main intelligent performance features for Azure Database for MySQL are Query Performance Insight and Performance Recommendations. With Query Performance Insight, you can get quick … 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…

Tip of the Week No.19 – What is the Database First Workflow in Entity Framework?

Check our Tip of the Week, where this week, we discuss about the Database First workflow in Entity Framework. Tip of the Week #19 Based on the Database First workflow in Entity Framework, you create an Entity Data Model (EDM) by reverse-engineering an existing database. The workflow is: You first create a new .NET application … 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…

How to Build a Simple Image Viewer with .NET WinForms and C# in Visual Studio

Hi friends! In this post, which is actually a 30-min video guide, we will see together, step-by-step, how you can easily build a simple image viewer with .NET WinForms and C# in Visual Studio. Our Simple Image Viewer App’s Functionality The functionality of the simple image viewer app we will be developing in Visual Studio, … Read more…

Tip of the Week No.16 – Available Visual Studio Editions

Check our Tip of the Week, which this week discusses about the available Visual Studio editions and discuss about their main differences. Tip of the Week #16 There are 3 Visual Studio editions. There are: Community Edition (free) In comparison with the other editions, the Community Edition of Visual Studio lacks some features, mainly about: … Read more…

Tip of the Week No.15 – Main Data Structures in C#

Check our Tip of the Week, which this week discusses about the main data structures in C#. Tip of the Week #15 Data Structures, are data organization and storage formats, that are used in different programming languages for storing data, define attributes between data, and apply different operations on this data. The main data structures … 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…