What are models in Data Science? In a simple sentence, models are built so that we can make predictions about a trend we are investigating. There are two categories of models: supervised, which we train, and unsupervised, which is done through... read more
Is query join performed between SQL Server and Oracle tables? (aka PolyBase)
In the article we will see a magical way so that we can use in select queries data from external sources (without Linked Server) and more specifically from Oracle Database. What is PolyBase As of SQL Server 2016 the… read more
How to export bulk data from Oracle database using Oracle Data Pump (expdp)
Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. The data can be extracted using the… read more
How to visualize data on a map using Python
In this article with the help of jupyter notebook and python we will make a heatmap. We will do a complete analysis using dataframe, polynomial regression scatter plot, bar plot. Let's start by loading the libraries we'll need: What… read more
What is Always Encrypted and how it is applied to protect sensitive data
In the era of GDPR let's talk about another SQL Server feature to protect sensitive data. It's none other than Always Encrypted! What is Always Encrypted Its purpose is that the data is always encrypted by… read more
How do we connect a Microsoft Excel to SQL Server
Microsoft Excel, although we use it every day and is one of the most well-known and oldest Microsoft programs, hides many possibilities. In this article we will see how to connect a SQL Server database... read more
How do we apply the latest patch (PSU) to an Oracle database
In the article we will analyze the process of patch set update (PSU) in Oracle Database. The process is done through the two Oracle tools, OPatch and Datapatch. OPatch is a tool that allows you to apply and uninstall… read more
What is TDE and how does it relate to GDPR (example in SQL Server)
Since 2018, when the European GDPR (data protection) legislation began in Europe, all companies started looking for solutions on how to implement the data protection policy immediately with as little impact as possible. There it comes… read more
What are isolation levels and how can they affect a transaction
In this article we will talk about one of the ACID properties of RDBMS and more specifically about the Isolation property. During relational database transactions, many users will try to access the same data… read more
