Planning of Disk Space for Databases
Do you think about something when you create a new database? I guess that most of you would say no,...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each...
Git: A Modern Approach to Code Management
In this article, I would like to share my knowledge and experience of working with git. The main hallmark of git is that it does not block...
Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included...
Resource Release in .NET Applications
In C#, there is one huge benefit, which is a drawback at the same time – an automatic garbage collection. With traditional desktop...
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects. Providing a user with excessive...
Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
Effective Use of Classes in .NET
When you need to learn a programming language, you buy a book. From books, we learn basics of the language and how to program, but this is...
