Tricky Questions about C#
Some questions may seem too basic, but they still contain tiny tricks. Sometimes even a simple...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1
Why does it take so much time to execute a query? Why are there no indexes? Chances are you’ve heard about EXPLAIN in PostgreSQL....
Common Mistakes of DBA in MS SQL Server
In this article, we are going to review DBAs mistakes, the consequences of which were quite perceptible and which I had to deal with. The...
Another Way to Localize Application
I would like to introduce a simple way to localize applications. I do not like the standard...
How to Automate Data Collection on the SQL Server Database Growth
Introduction Often, there is a need to control the growth of all tables and files of all databases. In this article, we are going to...
Preparing for Exam 70-483: Programming in C#
During preparation for exam 70-483, I found lots of websites containing links to various manuals that helped me a lot. But what really...
Comparison of Tree Graphs
When developing an information system that also includes various processing of design and...
Understanding Transactions in SQL
A transaction in SQL is a unit of execution that groups one or more tasks together. A transaction is considered successful if all the tasks...
Oracle as Workaround of Mutating Tables
The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger, resulting in the “ORA-04091:...
Oracle Regular Expressions. Dangerous Range
An Oracle developer who often uses regular expressions in code sooner or later can face a...