Data - Developer Support

Azure SQL TDE failures – Activity log Alerts to rescue

May 22, 2020 May 22, 2020 05/22/20

Developer Support

The SQL Server connection to the Key Vault can be lost for various reasons of either the SQL Server (updates, backups etc..) or the Key Vault (Key expired, disabled etc.) Luckily Azure provides detailed logging and alerting through Azure Monitor Logs and Alerts.

DAX Calculation Groups for Time Intelligence

May 20, 2020 May 20, 2020 05/20/20

Developer Support

Power BI Premium (Preview), Azure Analysis Services and SQL Server Analysis Services 2019 now support Calculation Groups! Why am I so excited? Because this functionality was one of the best capabilities in Multidimensional Analysis Services through Named Sets and Calculated Members.

Using Azure DevOps Pipelines with Redgate to Automate Oracle Database Deployments

May 14, 2020 May 14, 2020 05/14/20

Developer Support

In this post, I will cover a basic end to end-to-end example of taking a local Oracle database, setting up a project in a Git repository and using a Continuous Integration / Continuous Delivery (CI/CD) pipeline to take your database changes from code through to production.

Global Power BI User Group: Tales from the Forum (Video)

April 29, 2020 Apr 29, 2020 04/29/20

Developer Support

Our own Dev Consultant Jorge Segarra answers questions from the Global Power BI User Group on all things Power BI in this video, "Tales from the Forum."

A How-To Guide For pssdiag and SQL Nexus: Creating a pssdiag Package

April 24, 2020 Apr 24, 2020 04/24/20

Developer Support

In this post, Sr. Consultant Kendal Van Dyke explores pssdiag and SQL Nexus, free tools from Microsoft that help you capture and analyze SQL Server performance data.

Machine Learning – Lessons from our POC

April 10, 2020 Apr 10, 2020 04/10/20

Developer Support

Using multiple algorithms and tuning the algorithms to find the optimum value for each parameter also improves the accuracy of the model. However, it is not necessary that higher accuracy models always give the accurate results, as sometimes, the improvement in model’s accuracy can be due to over-fitting too.

Azure API for FHIR

January 15, 2020 Jan 15, 2020 01/15/20

Developer Support

Azure API for FHIR (Fast Healthcare Interoperability Resources) enables rapid exchange of data through FHIR APIs, backed by a managed Platform-as-a Service (PaaS) offering in the cloud. It makes it easier for anyone working with health data to ingest, manage, and persist Protected Health Information PHI in the cloud.

Secure Access to Azure SQL Servers for Power BI

January 14, 2020 Jan 14, 2020 01/14/20

Developer Support

How do you refresh Power BI datasets in the Power BI service from Azure SQL server resources while restricting traffic to specific resources? Learn how using the On-Premises Data Gateway and SQL endpoints can help you tighten security.

DBA’s thoughts about monitoring SQL Server in Azure

December 30, 2019 Dec 30, 2019 12/30/19

Developer Support

Monitoring our systems is key to a healthy, predictable, and stable environment. Learn how Azure Monitor helps simplify monitoring of Azure solutions including data platforms such as Azure SQL.

DACPAC always changes previously replicated tables on the target

December 29, 2019 Dec 29, 2019 12/29/19

Developer Support

Learn how to prevent the DACPAC from rebuilding all objects that once participated in transactional replication and have no changes in development.

Developer Support