After a long time, when I tried to create a user and grant him all permissions on a certain database using- GRANT ALL PRIVILEGES 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.
MySQL Single Quotes in Strings
We frequently deal with names/strings that contain apostrophes or single quotes. It can be difficult to manage them in the database. If we provide the
Teradata VM
Teradata is a well-known Relational Database Management System created by the Teradata Corporation. Using the concept of parallelism, Teradata is used to create large-scale data
CHOOSE Function in SQL Server
In SQL Server, the CHOOSE function returns the item at the provided index from a list of values. CHOOSE is an index into an array,
Renaming a column in SQL Server
Although renaming a column is extremely uncommon, SQL Server provided us with the ability to do so in the event that it was required. I
CHECKSUM and CHECKSUM_AGG
CHECKSUM: The checksum value computed over a table row or an expression list is returned by the CHECKSUM function. To create hash indexes, use CHECKSUM.
Big Data & SQL 