Missing parentheses in call to ‘print’. did you mean print(…) – How to Resolve in Python

Hi friends, in this short tip, we will be discussing how you can easily resolve the error message: missing parentheses in call to ‘print’. did you mean print(…). This is a common syntax error message you might get, when coding in Python.   Reproducing the “Missing Parentheses” Python Error In order to better understand the … Read more…

Resolve SQL Server CTE Error – Incorrect syntax near ‘)’.

Hi friends, in this post, we will be discussing about how you can resolve the SQL Server CTE Error: Incorrect syntax near ‘)’.   What are Common Table Expressions (CTEs)? In SQL Server and more specifically in T-SQL, a CTE is a temporary named result set, from which you can then select records. CTEs are … Read more…

What is Data Security and which are its Main Characteristics?

Hi friends. In this article, we will be discussing about Data Security and which are its main characteristics, within the context of Data Management.   What is Data Security? Data Security, is a term in Data Management, that is used for characterizing the processes, policies and controls for preventing “unauthorized access” to your data thus … Read more…

What is Data Management and why it is Important?

Hi friends, in this post, we will be discussing about Data Management and more specifically, we will be answering the question: “What is Data Management and why it is Important?”   About Data Management Data Management, is a set of practices and guidelines, that establish the proper procedures for: Acquiring data Storing and Organizing data … Read more…

Data Management for Beginners – Main Principles (Course Preview)

People and data are the two most important assets in any organization. By properly maintaining accurate and secure data, along with inspiring people within the organization to realize the value of data, the organization can reach to data-driven decisions more easily and thus meet its strategic goals in a more efficient manner. Data Management, provides … Read more…

IndentationError: expected an indented block in Python – How to Resolve it

Hi friends! In this post, we will be discussing about the “IndentationError: expected an indented block” in Python and how to easily resolve it, as well as, how to resolve the “IndentationError: unexpected indent” error.   What is Indentation in Python? Generally, in programming, indentation is when you leave empty spaces in the beginning of … Read more…

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…

How to Enable PowerPivot in Excel 2016 or Later

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…

How To Fix the Issue “This device can’t use a Trusted Platform Module”

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…

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…