Azure Synapse (formerly Azure SQL Data Warehouse)

SQLServerCentral Article

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

2,109 reads

SQLServerCentral Article

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.13 (8)

2021-11-26 (first published: )

12,994 reads

Blogs

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022

By

Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs

Forums

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers