Logon Triggers in SQL Server
A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL...
Difference Between Inline and Out-of-Line Constraints
Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two ways of creating constraints on a...
How to Handle Errors in SQL Server Nested Transactions
In this article, we will explore SQL Server Nested Transactions, a transaction block with one or several transactions. The image describes...
Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server
You often come across scenarios where you have to calculate a running total of a quantity. A...
SQL Server Table Partitioning and Partitions Tutorial
Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
Microsoft SQL Operations Studio: Understanding and Installation
SQL Server Management Studio is considered as the default integrated graphical user interface tool that has been used for many years to...
Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are among the most important SQL Server components. Both have...
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
50 Shades of Oracle Database Certification Exam
In this article, I would like to talk about one of the basic certifications from Oracle – Oracle Database SQL Certified Expert....
5 Ways to Update Data with a Subquery in Oracle SQL
A subquery is a powerful way to find the data you want to use for another query. They are often...
