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…
This article, discusses about PowerPivot and explains how you can enable PowerPivot in Excel 2016 or later, via a step by step guide. PowerPivot is an add-in for Excel that enables you to import and process millions of records from various sources right into Excel very fast. For old versions of Excel (i.e. version 2010) … Read more…
This article suggests how to fix the issue “This device can’t use a Trusted Platform Module” when enabling BitLocker encryption in Windows 10. If you try to turn BitLocker on for your OS drive in Windows 10 and thus encrypt the system drive, under certain circumstances, you might get the below error message: This device … Read more…
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…
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…
Hi friends! In this post, we will talk about how you can resolve the error 0xE0434352 in Windows Task Scheduler. About the 0xE0434352 Error When you schedule a task in Windows Task Scheduler and you try to run it, under certain circumstances, you might get the the 0xE0434352 error/status in the “Last Run Result” column. … Read more…
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
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…
Check our Tip of the Week, where in this week, we discuss about SQL Server’s Surface Area. Tip of the Week #20 Surface Area is a term that is usually used to describe the surface area of attack in terms of computer security. In SQL Server, it refers to the number of SQL Server components … Read more…
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…
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…
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…
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…
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…
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…