Category: SQL Terminologies

This is page is for SQL Concepts that you already know or should know. Here, I will try to add one concept per day with real life example(s) to map our knowledge with real world and work.

CAST vs. CONVERT

CAST vs. CONVERT

Datatype conversion is a common scenario that we face while writing SQL queries. Cast and Convert are two functions provided by SQL for this purpose. But what is the difference ...

READ MORE +
0
System Databases : Restrictions Matrix

System Databases : Restrictions Matrix

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you "can not" perform ...

READ MORE +
0
Question : Who is a DBA?

Question : Who is a DBA?

This post is targeted for those who are keen or new to DBA profession. Based on my experience I tried to write about DBAs and Possible career paths related to it. Who is a ...

READ MORE +
0