How to Connect to Azure SQL Database Securely

Azure, Cloud

As a database administrator, I started my journey in deploying managed SQL databases on the cloud,...
Read More

How to Connect an Oracle ADW with Power BI and Create Sales Dashboard

Business intelligence, Power BI

Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and optimized for Data Warehouse workload....
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

Database development, Languages & Coding, MySQL, Statements, T-SQL

Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Read More

SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table

Database development, Tables

To insert data into a table having columns with default constraints, we can use the DEFAULT...
Read More

Centralized Data Modeling Using Power BI Templates

Business intelligence, Power BI • One Comment

The centralized data modeling approach is really helpful in many practical scenarios. This article focuses on achieving it using Power BI...
Read More

Implementing Error and Transactions Handling in SQL Server

Database administration, Troubleshooting Issues

Introduction No matter how hard we try to design and develop applications, errors will always occur. There are two general categories –...
Read More

Power BI Date Table Template Tutorial

Business intelligence, Power BI

What is the right way of using Date Templates in Power BI reports and dashboards? This article will...
Read More

How to Connect Python to SQL Server to Automate Backend Process

Automation, Database administration

Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes,...
Read More

MS SQL Server on Linux vs Windows Performance Test to Spot the Difference

Database administration, Performance Tuning

Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of...
Read More

Install SQL Server 2019 Ubuntu Linux Server Step by step

Database development

After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 (refer to...
Read More
Close