SQL SERVER DEVELOPER
Why the need for data migration? Not too long ago, database software were limited to few brands and options. To name a few of them we can say Oracle, MS SQL Server, MySQL, DB2 among few others. Oracle would be used for systems that needed very high performance and robustness. MySQL, would be used for…
What is Normalization in RDBMS? Normalization is a process to reduce or eliminate data redundancies by correcting table structures inside a relational database management system. There are, as of 2022, 7 different forms of normalization. They are 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, and 6NF. To understand how this works, we will take this table…
Let’s find out who is the culprit locking my processes in SQL SERVER but I want SQL Server to tell me who is doing by sending me email.