Troubleshooting Issues when Working with Date and Time in SQL Server

The Microsoft SQL Server database stores the date and time information in a variety of formats. The most common of them are DateTime, DateTime2, and Date. As it happens with all types of data, issues can take place time after time. In this article, we’ll focus on troubleshooting some of the most common issues that you might face while working with the SQL time and date data types.

CodingSight - Troubleshooting Issues when Working with Date and Time in SQL Server
Read More

How to Create a Table with Multiple Foreign Keys and Not Get Confused

Understanding Table Relations

SQL server adds foreign keys to implement relations between tables in a relational database. A table can have one-to-one, one-to-many, or many-to-many relations with another table, depending upon the type of data you want to store.

A one-to-one relationship is simple and rarely used. Each record in a particular table relates to exactly one record in another table.

CodingSight - How to Create a Table with Multiple Foreign Keys and Not Get Confused
Read More

9 Best Practices for Writing SQL Queries

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many ways to execute a SQL query to get desired results on your database.

However, not all SQL queries are created equal. Most can be optimized to follow the best practice. This article focuses on 9 SQL query optimization tips. After reading, you will know all the dos and don’ts of writing SQL queries.

CodingSight - 9 Best Practices for Writing SQL Queries
Read More

How to Download and Install SQL Server Express Edition?

SQL Server is Microsoft’s premier database management system that we can use to develop relational databases. It also offers support for graph databases. Depending on the services offered, SQL Server comes in various editions, such as Enterprise, Standard, Personal, Developer, Express, etc.

In this article, we’ll deal with the SQL Server Express 2019, a free edition of SQL server commonly used for developing desktop, web, and small-scale server applications. We’ll clarify how to download, install, and configure it. Along the way, we’ll also illustrate how to install and use SQL Server Management Studio which is an easy-to-use GUI-based tool for managing SQL Server databases.

CodingSight - Installing and Configuring SQL Server Express Edition
Read More

How to Easily Get Data from Web Source Using Power BI Rest API Calls

Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs.

This article explains the usage of Rest API as a data source to import JSON data in Power BI from a remote location. Also, we’ll learn how to transform the imported JSON data into a tabular format. Finally, we’ll plot visualizations using the imported data.

Read More

Power BI REST API No Code Options for Easy Data and Reports Download

Microsoft’s Power BI REST API no-code option is extremely helpful as it allows calling Power BI REST API without writing a single line of code. Of course, you can call it programmatically using any programming language. Still, testing if Power BI Rest APIs are accepting requests and returning the right data, it is convenient to use the no-code options first. This article will explain how to do that.

CodingSight - Power BI REST API No Code Options
Read More