By reducing the redundant data, normalization is a rigorous procedure that enhances data integrity in the table. There are various procedures involved in converting the
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.
AWS SQL Server Instance Types
On-premises SQL Server instance types are explained in the previous article. In this article, we’ll be discussing the instance types available in Amazon RDS. A
SQL Server Instance Types
A copy of the sqlservr.exe executable that functions as an operating system service is referred to as an instance of the database engine. A number
Project Analysis & Requirements
The project’s overarching plan is described in the project analysis document and the requirements document. The essential features of these documents that aid in the
SDLC & DDLC – Development Life Cycle
Planning, building, testing, and deploying an information system are all steps in the development life cycle, whether it be for a database or an application.
SQL vs SQL Server
The terms SQL and SQL Server are frequently misunderstood by beginners, as was mentioned in one of the earlier articles. I always made an effort
Big Data & SQL 