2023-07-03
454 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
Learn how to query data stored in text files from Azure Synapse Analytics using the Serverless pool that is included with each workspace.
2023-06-07
1,413 reads
Understanding Azure Synapse Analytics Pricing
Learn about the different parts of Azure Synapse Analytics and what it costs for each of these areas.
2023-03-03
13,644 reads
2023-01-25
382 reads
Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools
In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.
2023-01-09
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2026-02-16 (first published: 2022-10-10)
12,776 reads
2022-04-08
331 reads
2022-03-18
386 reads
Exploring Knowledge Center in Azure Synapse Analytics
Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big data systems together. It provides SQL for enterprise data warehousing, Spark technologies for big data, Data explorer for analytics, Pipeline for data integration and ETL and ELT, and other popular Azure services including Power BI, CosmosDB, and […]
2022-03-11
1,415 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers