The type or namespace name ‘Office’ does not exist in the namespace ‘Microsoft’ – How to Resolve

Hi friends, in this article, we will be discussing about, how you can resolve the following error you might get in your Visual Studio project: CS0234 The type or namespace name ‘Office’ does not exist in the namespace ‘Microsoft’ (are you missing an assembly reference?)   Why I Received this Error Message? The reason you … Read more…

SQL Server is Terminating Because of Fatal Exception 80000003 – How to Troubleshoot

In this article, we will be discussing about the error message “SQL Server is Terminating Because of Fatal Exception 80000003” and how to troubleshoot it. In more detail, the error message to talk about is: SQL Server is terminating due to fatal exception 80000003. This error can be caused by an unhandled Win32 or C … Read more…

What are NoSQL Databases?

Hi friends, in this post, we will be discussing about Non-Relational Databases and more specifically, we will try to answer the question: What are NoSQL Databases?   Definition for NoSQL Databases Non-Relational Databases which are also known as “NoSQL databases”, are database systems that do not use the tabular schema of rows and columns which … Read more…

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…