User Profile

FonsecaSergio

Microsoft

Joined 7 years ago

38 Posts80 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

Synapse Connectivity Series Part #4 - Advanced network troubleshooting and network trace analysis
In this 4th part of connectivity series, we are going deep. On this post we will show how to troubleshoot connectivity issues on Azure Synapse Analytics using network traces and Wireshark. It covers ...
Nov 14, 2023 Place Azure Synapse Analytics Blog
24KViews
3likes
0Comments
Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints
In this article we are going to talk about Synapse Managed Virtual Network and Managed Private Endpoints.
Feb 28, 2023 Place Azure Synapse Analytics Blog
23KViews
3likes
3Comments
Synapse Connectivity Series Part #2 - Inbound Synapse Private Endpoints
This blog article will feature Synapse Private Endpoint. The foundation of this article was based on a previous post - Azure SQL DB Private Link / Private Endpoint - Connectivity Troublesh...
Jan 09, 2023 Place Azure Synapse Analytics Blog
34KViews
5likes
7Comments
Synapse Connectivity Series Part #1 - Inbound SQL DW connections on Public Endpoints
In this first article I would like to explore the SQL public endpoint connectivity. How it works behind the scenes how to troubleshoot connectivity issues and some common issues
Oct 25, 2022 Place Azure Synapse Analytics Blog
28KViews
3likes
6Comments
Calling Synapse REST API to automate tasks using Powershell
Sometimes we need to do some automations on Synapse and if using Powershell by default use the Az Powershell Module to simplify this interaction https://docs.microsoft.com/en-us/powershell/module/a...
Mar 11, 2021 Place Azure Synapse Analytics Blog
9.3KViews
2likes
0Comments
Synapse / SQL Password so secure that even you cannot use
Everyone knows that the your password should be very strong, and there companies that use password generator to create complex password and this is fine too. But sometimes or better sa...
Feb 22, 2021 Place Azure Synapse Analytics Blog
4.1KViews
0likes
0Comments
Automatic pause all Synapse Pools and keeping your subscription costs under control
As Synapse engineer or Synapse Support Engineer you may need to start and test some Pools, and you want this to be the most cost efficient possible. Leaving some Synapse with a lot of DWU left...
Jan 16, 2021 Place Azure Synapse Analytics Blog
23KViews
9likes
13Comments
How to query Azure SQL Metrics using Powershell
One way you can quickly search and query metrics data is using Azure Portal, where you have chart data. But maybe you want to get the raw data and query it yourself
Oct 08, 2020 Place Azure Database Support Blog
5KViews
3likes
0Comments
Azure SQL DB and TEMPDB usage tracking
Working on a case I got to scenario where customer may would like to better understand the TEMPDB usage and isolation between databases in an elastic pool. First speaking about isolation. Each ...
Sep 04, 2020 Place Azure Database Support Blog
28KViews
3likes
0Comments
Query Design performance issues #02 - Column-side conversions and Function usage in WHERE
When designing queries and filters (WHERE) sometimes we need to convert some data before filtering, and depending on what you do you may get a bad plan. Find some scenarios in this article
Aug 06, 2020 Place Azure Database Support Blog
2.4KViews
0likes
0Comments