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
SQL Server Services in Windows
Windows services are installed as part of the SQL Server and its component installations. With the operating system, these services exchange information. In Administrative Tools
Big Data & SQL 