Differences Between Batch and Streaming Data

Technology articles, eBooks and courses - TechHowTos

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

How to Use a Percentage Formula in Excel

Technology articles, eBooks and courses - SQL Server - Databases - Azure - Python - Programming - TechHowTos

In this short how-to tip, we will see how you can use a percentage formula in Excel.   Example of Excel Spreadsheet Below, you can see an example of an Excel spreadsheet, that contains some sample values, based on which we will create a percentage formula. As you can see, the spreadsheet has 3 columns: … Read more

This Month’s Tech Tip – January 2020

Technology articles, eBooks and courses - SQL Server - Databases - Azure - Python - Programming - TechHowTos

This month’s tech tip is about Azure SQL Database and more specifically, about the different compatibility percentages, when migrating from on-premises to the Azure cloud.   Tech Tip: When migrating your on-premises SQL Server databases to the Azure cloud platform, the available SQL Server deployment options have the following compatibility percentages with your on-premises databases … Read more

This Month’s Tech Tip – November 2019

Technology articles, eBooks and courses - TechHowTos

This month’s tech tip is about SQL Server and Azure SQL Database.   Tech Tip: Among other, SQL Server (version 2016 and later) and Azure SQL Database support “Dynamic Data Masking”. This feature, allows the user to set SQL Server to dynamically mask sensitive data from unauthorized access, based on certain rules.   Enroll to … Read more

This Month’s Tech Tip – May 2019

Technology articles, eBooks and courses - SQL Server - Databases - Azure - Python - Programming - TechHowTos

This month’s tech tip is about Search Engine Optimization (SEO).   Tech Tip: Some of the major guidelines for efficient Search Engine Optimization (SEO) in your blog articles are: Write unique and clear content. Use the proper titles for your articles. Use the proper headings and subheadings for your articles and keep them relevant to … Read more