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…
Welcome to the wide and wonderful world of SQL development. Whether you’re dipping your toes into these waters for the first time as a student, upgrading your tech skills, or seeking a career change, you’ve gotten the basic skills you’ll need. SQL development is an integral part of any programming endeavor because, in any system,…
The main difference between data lake and data warehouse is that the a data lake can be composed of all types of data varying from structured (relational data), semi-structured (csv, Json, xml among other files) or unstructured (images, videos, text files among any other type of known or unknow files). Some of these data may…
When talking DCL, we are mainly talking about a portion of security in SQL Server. There are only two commands, GRANT and REVOKE, but remember, these commands can mean everything. With great power comes great responsibility. –Peter Parker So, when trying to access or manipulate objects in SQL Server, we need a Login. A login…
What are the SQL Server datatypes? The SQL Server datatypes dictate the type of data an object can hold. Examples are integer, strings, decimals, binary, and so forth. We can divide them in Numeric Character Strings Binary Strings Date & Time Other Numeric, as the name say, has to do with numbers. BIT TINYINT SMALLINT…
Need a database? Think about designing first to achieve the desired model. Avoid the black box syndrome. Black box syndrome is just the idea of thinking that databases are software used to save and retrieve data. It is “kind of” true in the sense that it does that. However, there is a phase in the…
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…
The main feature in RDBMS (Relational Database management system) is the relational or the relationship part of it. If done correctly, it makes the connections among entities easier and faster to retrieve. It also eliminates data anomalies and redundancies. Business rules will dictate that, so a clear understanding of the rules will make it easier…
SQL means Structured Query Language. Through SQL you can establish communication with a database. According to the American National Standards Institute, SQL is the language that is used for RDMS. RDMS is the short form of relational database management systems. Structured Query Language is designed to make the management and retrieval of data easier. SQL…
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.