Sucharita Das


Sending streaming data from Azure IoT Central to Azure SQL Database

Introduction In my last article, Working with Azure IoT Central at SQLServerCentral, I gave an overview of Azure IoT Central. I had connected my mobile phone as a device to Azure IoT Central and collected the telemetry data. In this article, I will export the telemetry data continuously from Azure IoT Central to Azure SQL […]

5 (1)

2021-08-23

839 reads

An Introduction to Power BI

Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]

5 (2)

2021-07-12

6,998 reads

Azure Storage: Blob and Data Lake Storage Gen2

Introduction Azure Storage is the service for storing different types of data. A storage account is created first. The storage account provides a unique namespace for different types of Azure storage data accessible from anywhere in the world over HTTP or HTTPS. Data in the Azure storage account is durable and highly available, secure, and […]

5 (1)

2021-06-14 (first published: )

2,226 reads

An Introduction To Kusto Query Language (KQL)

Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to create the ADX cluster. Then, one or more databases should be created inside the […]

3 (1)

2021-06-02 (first published: )

6,364 reads

An Introduction to Azure Data Explorer

Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past are not capable of processing and storing all this data in an efficient way. We need […]

4.5 (2)

2021-04-26

2,801 reads

Discussion on Normalization and Database Design Concepts

Introduction Relational database design helps to create a set of relations and tables, which are connected with each other through some defined relationships. The main purpose of relational database design is to preserve the information and minimize data redundancy. We need to follow some design guidelines for relational schemas to maintain the quality of the […]

5 (3)

2021-02-23

4,718 reads

Implementation of Normalization in SQL Server

Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]

3 (2)

2021-02-22

3,004 reads

Analyze Azure Cosmos DB data using Synapse Link and Power BI

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]

2021-01-12

1,585 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

update final code where not contain x then null if not contain x and another cod

By ahmed_elbarbary.2010

i work on SQL server 2012 I face issue i can't update table replacement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers