Comparison of SQL Server Deployment Options on the Azure Cloud Platform

by

Hi friends, in this article, we will be performing a comparison of the SQL Server deployment options on the Azure cloud platform.   Overview of SQL Server Deployment Option on Azure When it comes to options for deploying SQL Server databases on the Azure cloud platform, there are many options that can cover all needs. … Read more…

An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint (9642) – How to Resolve

by

Hi friends, in this article, we will be discussing about how to troubleshoot the following error message: “Event ID: 9642. An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint.“.   About the Service Broker/Database Mirroring transport connection endpoint error We can see from the error message, that it refers to a … Read more…

Data Security vs. Data Privacy

by

In this post, we will be comparing Data Security vs. Data Privacy and try to identify their main difference. So in order to efficiently perform this comparison, we need to define what data security is as well, as what data privacy is. What is Data Security? As covered in a previous article, defines the processes, … Read more…

Differences Between Batch and Streaming Data

by

In this article, we will be discussing about the batch and streaming data, what they are and which are their main differences.   What is Batch Data and Batch Processing? Batch data, is a term used to characterize large data sets with millions of records stored in files, records, etc. Batch data is processed by … Read more…

An existing History Table cannot be specified with LEDGER=ON – How to Resolve

by

Hi friends, in this post, we will be discussing about the SQL Server 2022 error message: An existing History Table cannot be specified with LEDGER=ON.   What are Ledger Tables in SQL Server 2022? Ledger tables are special tables originally introduced in SQL Server 2022. They constitute a major part of the security enhancements in … Read more…

What is Abstraction in Object Oriented Programming?

by

Hi friends. In this article, we will be discussing about what is Abstraction in Object Oriented Programming. Also, we will see a relevant video lecture.   What is Abstraction? Abstraction, is a well-known technique in Object Oriented Programming and generally in Computer Science. It is a way, of handling a complex problem, by removing the … Read more…

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

by

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

by

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?

by

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

by

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 ‘)’.

by

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…