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
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
How do we restore a specific page only in SQL Server
In the article we will analyze what we can do in the case of page corruption in SQL Server. It is possible to restore only the specific page and avoid restoring the entire database through the backups we have (just... read more
How do we collect long-running queries via Extended Event and how do we read its data
Many times we will need to find how many and which SQL queries were executed for a long time in a period of time in SQL Server. The easiest solution with the least performance impact is to create an Extended Event. The… read more
How to write advanced SQL queries
In a previous article we analyzed what SQL (Structured Query Language) is and how it is used with basic examples. In this article we will see its more advanced functions. The code is written with the Transact-SQL extension… read more
How databases are stored and what indexes are
We have seen what a relational database is and that our entities are logical objects called tables. But how are they stored “physically” in an RDBMS (relational database management system)? Tables as objects are stored and… read more
What are databases?
We use them every day, they are necessary, most of us don't know what they are and maybe even their existence... We are talking about databases. But what do we define as a database? By term we define any set of organized data stored in a… read more
