In SQL Server, we must change the user that "starts" the SQL Server service from the Windows default to someone with specific rights that belongs to the Active Directory Domain. In this article we will see how we can… read more
What is Always On Availability Group
The Always On Availability Group is the feature provided by Microsoft in SQL Server to Replicate our bases on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery and for reading... read more
How we send email through SQL Server
Through Microsoft SQL Server we have the possibility to send emails either for some alerting or so that we can send reports. In this article we will see step by step how it works and how to activate Database Mail... read more
How to Text Search Documents Stored in Database Table in SQL Server Using Full-Text Index
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
How we create a failover group in Azure Managed Instance
In a Managed Instance with multiple databases in Azure we can have high availability. More specifically, we can have an asynchronous second read-only Managed instance in the same or in a different region. We can at any time do… 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 to see what operations a query performs to complete it in SQL Server (Execution Plan Operators)
To run a query on SQL Server, the Query Optimizer takes information such as the query, database schema, statistics and derives the optimal way to access them. The result is called Plano or otherwise… 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
