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

645 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

7,259 reads

Blogs

When do Statistics get updated?

By

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...

Power BI: Making Date & Time Keys

By

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...

Daily Coping 18 Jan 2021

By

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

Read the latest Blogs

Forums

Intermittent "nesting level exceeded" error

By julian.fletcher

We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...

Selecting last 6 months

By sqlErik

Hi, I need to select rows from the last 6 months prior to the...

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers