Azure Synapse Analytics is GA!
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th at 1:10pm EST, at the PASS SQL Saturday Atlanta BI (info) (register) (full schedule)) Great...
2020-12-04
2 reads
James Serra's Blog
PASS SQLSaturday’s I will be speaking at
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL...
2020-12-02
31 reads
Azure Stack and Azure Arc for data services
For those companies that can’t yet move to the cloud, have certain workloads that can’t move to the cloud, or have limited to no internet access, Microsoft has options...
2020-12-01 (first published: 2020-11-18)
557 reads
External tables vs T-SQL views on files in a data lake
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus...
2020-11-11 (first published: 2020-11-03)
774 reads
Top Azure Synapse Analytics and Power BI questions
I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer...
2020-10-28 (first published: 2020-10-22)
735 reads
Synapse and federated queries
As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about...
2020-10-23 (first published: 2020-10-15)
465 reads
Microsoft Ignite Announcements 2020
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related...
2020-10-08 (first published: 2020-09-30)
492 reads
Azure Synapse Analytics overlooked features
There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and...
2020-09-29 (first published: 2020-09-23)
440 reads
Query options in Azure Synapse Analytics
The public preview version of Azure Synapse Analytics has three compute options and four types of storage that it can access (mentioned in my blog at SQL on-demand in...
2020-09-23 (first published: 2020-09-16)
280 reads
Data Lakehouse & Synapse
I am starting to see this relatively new phrase, “Data Lakehouse”, being used in the data platform world. It’s the combination of “Data Lake” and “Data Warehouse”. In this...
2020-09-17 (first published: 2020-09-10)
785 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers