Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Aliases in SQL
In this post, we’ll go over aliases in SQL Server. The following are some key points about Aliases. In SQL Server, aliases can be used
Disable and Enable Index in SQL Server
This topic describes how to disable and enable an index in SQL Server. Disabling an index prevents users from accessing the index and, in the
Data Types in SQ Server
The allowed data types in SQL Server are listed below, along with their complete descriptions. Beginners should be aware of these data types and their
DROPPING INDEXES
The DROP INDEX command can be used to delete a non-primary key index. However, this method cannot delete indexes created as a result of a
Indexes in SQL Server
An index in SQL is a quick lookup table used to find records that users frequently search for. An index is designed to be small,
Big Data & SQL 