It is extremely rare to rename any database object once it has been defined; however, if the need arises, one must be aware of how
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.
Deleting Objects in SQL Server
Schema changes are uncommon in some businesses. Dropping the objects is unusual too. When deleting any database objects, one must be cautious because it may
Creating Objects – SQL Server
Although the CREATE, ALTER, and DROP (DDL) commands appear to be extremely straightforward, their use is high and will be used frequently since they deal
MySQL UPDATE JOIN with Aggregate Function in SET
When relational model tables are normalized, as was discussed in a previous post, it may be necessary to join them to obtain the correct records
MySQL UPDATE with JOIN
When tables in a relational model are normalized, it may be necessary to join them in order to fetch the required records or update the
SQL Server – Connecting through GUI
An integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database, is SQL Server Management Studio. Since its introduction with Microsoft
Big Data & SQL 