Azure Synapse Analytics

“At my work, I am running a sql script to extract some things from couple of tables, simple joins and stuff, it ran in 2 mins on 5/6 but now it’s taking about 4 mins to run it And no one else is sharing the server, so am curious how this wor…”more

“One gap that really slows down day-to-day work is the lack of Copilot support in SSMS for Azure Synapse Analytics. Copilot in SSMS works well with SQL Server, but as soon as you switch to Synapse (especially dedicated SQL pools), it’s simpl…”more

“It's 9 PM, and here I am, relearning 20 year old tech and questioning everything about the query engine in SQL Server, trying to decipher how it might cooperate with a columnar engine all because I'm stuck using SQL Server Data Warehouse, a…”more

“I’m studying for Azure’s DP-203 and I was wondering if Synapse is a good data warehouse in terms of performance and costs, because, basically, the exam revolves around synapse and its benefits and features (which in hindsight they sound goo…”more

“Folks aren't too happy with Synapse for multiple reasons; one is that we can't get it running on a private endpoint, so port 1433 sits on the internet for the Serverless SQL Pool.”

“Azure Synapse Analytics is absolute trash for anything bigger than a few extractions. I have tried to work with this platform. I have given it every opportunity I can, but never have I seen so much trouble from a tool or framework I had to…”more