Forum Widgets
Latest Discussions
Reliable Interactive Resources for Dp300 exam
Hello everyone, I hope you're all having a great day! I wanted to reach out and start a discussion about preparing for the DP-300 (Azure Database Administrator) certification exam. I’ve been researching various resources, but I’m struggling to find reliable and interactive materials that truly help with exam prep. For those who have already passed the DP-300, could you share any interactive and trustworthy resources you used during your study? Whether it's courses, hands-on labs, or practice exams, I’d really appreciate your recommendations. Any advice on how to effectively prepare would be incredibly helpful! Thank you so much for your time reading this discussion and for sharing your experiences!
Architectural Feedback: Is SPFx + Azure Database a viable choice for an internal ticketing system?
Hi everyone, I am currently evaluating the architecture for a new interdepartmental ticketing system and would love to get your feedback, real-world experiences, or best practices regarding our proposed approach. Our goal is to centralize and streamline requests, tracking, and communication across various departments within the organization. We want to provide an intuitive interface that integrates seamlessly into our existing workplace (SharePoint Online / Microsoft Teams). Proposed Architecture Frontend / UI: Custom web parts developed using SPFx (SharePoint Framework), embedded into SharePoint pages and surfaced in Microsoft Teams. Backend / Database: Azure Database for PostgreSQL for managing relational data, audit logs, complex ticket statuses, and SLA metrics. Integration Layer: Custom REST APIs (hosted via Azure Functions / App Service) to handle transactions securely between SPFx and PostgreSQL Rationale Behind This Choice User Experience: SPFx provides a native look and feel within Microsoft 365, minimizing user onboarding friction. Relational Data Complexity: We prefer PostgreSQL over standard SharePoint Lists due to data volume projections, complex relational data models, granular access control requirements per department, and advanced analytics needs. Questions Architecture Viability: Do you consider using SPFx purely as a frontend consumer for external REST APIs connected to PostgreSQL a clean and sustainable pattern long-term? SharePoint Lists / Dataverse vs. External DB: Is the added overhead of maintaining a custom API + PostgreSQL in Azure justified, or would you strongly favor Dataverse or native SharePoint Lists for this specific use case? Authentication & Security: Any specific tips when securing SPFx calls to Azure API/Functions using Microsoft Entra ID (Azure AD) to ensure proper department-level data segregation? Maintenance & Governance: Are there any major maintenance, lifecycle, or performance bottlenecks we should prepare for when maintaining a hybrid SPFx + external DB solution? Thanks in advance for any insights, lessons learned, or potential red flags!Azure Data Studio - default dashboard settings for Server and Desktop?
Hello. I am just starting to learning Azure Data Studio. My Server Dashboard and Database Dashboard don't seem to have the same widgets by default as per all of the tutorials. Below are my default settings (which have not changed). Could someone please tell me (or perhaps provide) the default settings I need so that my dashboards display all of the "default" widgets? { "workbench.enablePreviewFeatures": true, "workbench.startupEditor": "welcomePageWithTour", "datasource.connectionGroups": [ { "name": "ROOT", "id": "C777F06B-202E-4480-B475-FA416154D458" } ], "datasource.connections": [ { "options": { "connectionName": "", "server": "localhost\\SQLEXPRESS", "database": "", "authenticationType": "Integrated", "user": "", "password": "", "connectTimeout": "30", "connectRetryCount": "1", "connectRetryInterval": "10", "applicationName": "azdata", "groupId": "C777F06B-202E-4480-B475-FA416154D458", "databaseDisplayName": "" }, "groupId": "C777F06B-202E-4480-B475-FA416154D458", "providerName": "MSSQL", "savePassword": true, "id": "e53c9395-7bd0-4864-b65c-01ad39fbf340" } ], } PS: I couldn't find a specific topic group for "Azure Data Studio". If this is not the correct place, please let me know where best to ask my question. Many thanks MichelleInventário de Recursos do Azure | Extração de Dados para Analisar Recursos e Custos
Inventário de Recursos do Azure Extração de Dados | Analisar Recursos e Custos Objetivo: Ajudar Administradores de Cloud Azure. https://github.com/leonardorochadf/InventarioRecursosAzure É um script em powershell que possibilita gerar um relatório do Excel de qualquer ambiente do Azure ao qual você tenha acesso de leitura. São exportados dois arquivos: Um Excel contendo o índice de recursos principal no painel mostrando o número correto de recursos e está organizado de acordo com cada um. A arquitetura do Azure será gerada no arquivo XML, que você deverá abrir no https://app.diagrams.net Recursos Extraídos: Centro de Segurança ,Máquina virtual ,Disponibilidade definida ,Conjunto de dimensionamento de máquina virtual ,Disco Gerenciado ,Conta de armazenamento ,Rede Virtual ,Pareamentos de rede virtual ,Gateway de rede virtual ,WAN virtual ,Endereço IP público ,Balanceador de carga ,Gerente de tráfego ,Gateways de aplicativos ,Porta da frente ,Tabelas de rotas ,Zonas DNS públicas ,Zonas DNS privadas ,Anfitriões do Bastião ,Firewall do Azure ,SQL VM ,Servidores SQL ,Banco de dados SQL ,Banco de Dados do Azure para MySQL ,Banco de dados do Azure para Postgre ,Cache do Azure para Redis ,Cosmos DB ,Databricks ,Explorador de dados ,Plano de Serviço de Aplicativo ,Serviços de aplicativos ,Contas de automação e runbooks ,HUB do evento ,ÔNIBUS de serviço ,Espaços de trabalho do Log Analytics ,Serviço de Kubernetes do Azure ,Azure RedHat OpenShift ,Área de trabalho virtual do Azure ,Instâncias de contêiner ,Cofres de Chaves ,Cofre de Serviços de Recuperação ,Hubs IoT ,Gerenciamento de API ,Trabalhos de análise de streaming ,máquinas. Comandos: Install-Module -Name Az -MinimumVersion 4.7.0 -AllowClobber -Scope AllUsers Install-Module ImportExcel Install-Module Az.Accounts Install-Module Az.ResourceGraph Login-AzAccount Chamar o script no PowerShell. Execute "AzureResourceInventory.ps1". No Azure CloudShell você já está autenticado. No PowerShell Desktop, você será redirecionado para a página de entrada do Azure. Se você tiver privilégios em várias subscriptions, poderá especificar o desejado usando o parâmetro "-TenantID" ou o recurso do Azure verificará todas as suas IDs de locatários e solicitará que você escolha um. Exemplo: C:\Users\leonardo.rocha\Documents\GitHub\InventarioRecursosAzure\AzureResourceInventory.ps1 -TenantID xxxxxxxxxxxxxxxxxxxx -IncludeTags -Diagram -SecurityCenter -QuotaUsage O Resultado final estará na pasta C:\InventarioRecursosAzure FIM
Data Share. Comparing Azure Data Share with Snowflake Data Share
Hi All, Looking a new implementation and comparing Azure's products along side Snowflake for some key functionality. Has anyone done a similar comparison in the past and is happy to share their learnings. Much appreciated. I'll add back into this discussion with my finding as my investigation progresses.
