SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan...
Oracle Database Security: Database Auditing
In this article, I will continue with Oracle Database Security and I will present some important facts about standard database auditing,...
Getting Started with SQL Server 2017 on Linux in the Azure portal
SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to other operating...
Monitoring Azure SQL Database with Azure SQL Analytics
The most important and challenging responsibility of a database administrator is monitoring...
How to Use Default and Custom Widgets in SQL Server Operations Studio
There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The demand created...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each...
Azure SQL Database Automatic Tuning
Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL...
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
Let us start our SQL journey to understand aggregating data in SQL and types of aggregations including simple and sliding aggregations....
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 running total refers to the sum of values in...
Understanding the Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the...