Implementing Failover in MS SQL Server 2017 Standard
Introduction Often, we need to ensure fault tolerance of MS SQL Server DBMS, especially, when there...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
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...
Monitoring Azure SQL Database with Azure SQL Analytics
The most important and challenging responsibility of a database administrator is monitoring performance metrics. Because 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...
Azure SQL Database Automatic Tuning
Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL Database. To be honest, I am thoroughly...
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...
