In SQL Server we have the possibility to store files such as docx, xlsx, XML, etc. in table fields. To search for words in these fields, a full table scan would have to be performed, but there is also the solution of creating... read more
Why doesn't SQL Server use all CPU Cores?
Having a SQL Server Instance installation we can face the following strange situation, while there is a need for CPU usage that never reaches this 100%. In the article we will see what may be the reason and how... read more
What is collation and how it changes in SQL Server
In one sentence, collation is the way characters are encoded in a database. That is, you define whether they will be case sensitive (uppercase, lowercase), in which language the varchar and text fields are. Fields like nvarchar which are in unicode format are not affected… read more
How can we access another oracle database remotely
In this article we will analyze how we can access tables / views located in a remote Oracle database. To achieve this we need to create an object called Database Link.… read more
How can we store docx, xlsx, jpg, xml, etc. files in a database table? in SQL Server
In SQL Server we have the ability to store files such as Docx, Xlsx, XML, JSON, JPG, PNG etc. in a field of a database table. In this article we will analyze how this is done and how it is done... read more
What are Columnstore Indexes and when do we use them in SQL Server
In this article we will analyze the difference between a table that is physically stored via a Clustered Rowstore Index and one that is stored via a Clustered Columnstore Index. What exactly are Columnstore Indexes, when should they be used and what are… read more
How can we get an email whenever an error occurs in the Oracle database Alert log
In a system based on an Oracle database, that an error occurs is recorded in a log file called the Alert Log. It is very useful to be informed immediately when something happens and the most immediate way is no other… read more
How we enable auditing in Oracle Database
In this article we will see the steps and options we have to enable auditing in an Oracle Database. Through auditing we can record who and how makes access or changes to... read more
How to properly install SQL Server
In this article we will analyze how a new SQL Server installation should be done step by step. In particular we will see the setup for SQL Server 2019. We will also see what we need to have done before starting the installation and... read more
