What is Savepoint in SQL? By designating a point inside a transaction that may be “rolled back to” without impacting any work done in 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.
SQL Interview Questions – Part-1
What does the business rule in the context of a database? A business rule is a declaration that places restrictions on a certain feature of
Automatic deletion of files from S3 bucket
Amazon S3, also known as Amazon Simple Storage Service, is a web service interface-based object storage service provided by Amazon Web Services. Anything we want
NOT NULL in SQL Server
In a relational database, a null value is used when a column’s value is absent or ambiguous. A null is not a zero value or
Removing VIEW in SQL Server
Using a query, a view creates a virtual table whose contents are known. In other terms, a view is a hypothetical table built from a
Fetch all the views – SQL Server
The following commands will assist in retrieving the metadata details regarding the system-created views. SELECT * FROM sys.objects WHERE type = ‘V’ Or you can
Big Data & SQL 