Sales Analysis with Power BI Desktop and Autonomous Database

Total: 2 Average: 5

Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and optimized for Data Warehouse workload. It means you don’t need to take more effort and resources (DBA role) to manage the database and optimize the workload.

Power BI Desktop is a business analytics service by Microsoft. It offers interactive visualizations and business intelligence capabilities with a simple interface, letting the end-users create reports and dashboards.

The current article describes the process of creating a Sales Analysis with Power BI Desktop and data hosted in Oracle Autonomous Data Warehouse.

Read More

Insert Column with a Default Value to SQL Serve Table

Total: 1 Average: 5

To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This article will cover the following aspects:

  • The DEFAULT constraint and required permission to create them
  • Adding a DEFAULT constraint while creating a new table.
  • Adding a DEFAULT constraint into an existing table.
  • Modifying and Viewing the constraint definition using T-SQL scripts and SSMS.
CodingSight - Insert Column with a Default Value to an Existing Table
Read More

How to Automate Backend Processes in SQL Server Instance with Python

Total: 2 Average: 5

Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes, reading or deleting data, other programming frameworks integrating with the RDMS is extremely valuable. This article will consider these types of tasks specifically integrated with Python and various method modules available to do so.

CodingSight - SQL Server and Python
Read More

How to Install SQL Server 2019 on Ubuntu 18.04 Linux System Step by Step

Total: 1 Average: 5

After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 there, and installing this OS in practice, we come to the primary goal. It is installing the SQL Server instance on our new Ubuntu Linux. If you don’t have the OS in question installed and configured yet, do it, following the step-by-step guideline in the previous article about installing Ubuntu 18.04 on a virtual machine. Now we can proceed to the task of installing SQL Server 2019 in that environment.

CodingSight - Installing Ubuntu on Linux
Read More