Azure Synapse (formerly Azure SQL Data Warehouse)

Analyze Azure Cosmos DB data using Synapse Link and Power BI

  • Article

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,588 reads

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4 (6)

2019-11-04

8,856 reads

Blogs

Daily Coping 21 Sep 2021

By

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

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Can't attach MDF and LDF files

By WhiteLotus

Hi All When I tried to attach my mdf and ldf file , I...

Social Media Link Aggrigator

By krishna28

Need a way to put all of your social media links and profiles into...

Issue with the format of calculation

By JeremyU

Hello friends, This issue is a little hard to explain, but I hope you...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers