Why the need for data migration? Not too long ago, database software were limited to few brands and options. To…
Category: SQL SERVER
SQL Development
Welcome to the wide and wonderful world of SQL development. Whether you’re dipping your toes into these waters for the…
What is the difference between Data Lake and Data Warehouse?
The main difference between data lake and data warehouse is that the a data lake can be composed of all…
Data Control Language (DCL)
When talking DCL, we are mainly talking about a portion of security in SQL Server. There are only two commands,…
The Bits and Bytes of a SQL Server Datatype
What are the SQL Server datatypes? The SQL Server datatypes dictate the type of data an object can hold. Examples…
Data Definition Language – DDL
Need a database? Think about designing first to achieve the desired model. Avoid the black box syndrome. Black box syndrome…
What is normalization in RDBMS with examples?
What is Normalization in RDBMS? Normalization is a process to reduce or eliminate data redundancies by correcting table structures inside…
Table relationships in RDBMS
The main feature in RDBMS (Relational Database management system) is the relational or the relationship part of it. If done…
What is SQL and how does it work?
SQL means Structured Query Language. Through SQL you can establish communication with a database. According to the American National Standards…
Who is locking my processes? A SQL Server Gossip story.
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.