SQLBrains

Happy Diwali

Interview and Project Support available but not included.For demo classes and more details please register at this link https://www.sqlbrains.com/register.php or drop a mail to [email protected]

https://www.mssqltips.com/sqlservertip/6195/sql-server-function-to-measure-cpu-usage-per-database/

SQL Server Function to Measure CPU Usage Per Database In this article we look at a script that can be used to show CPU usage by SQL Server database to get an idea which databases are consuming the most CPU on your server.

https://www.sqlservercentral.com/blogs/wrangling-data-flows-in-azure-data-factory-calculating-distance-between-two-geo-points

Wrangling data flows in Azure Data Factory: Calculating distance between two Geo-points – SQLServerCentral The latest blog posts on SQLServerCentral.

https://www.sqlservercentral.com/articles/understanding-outer-joins-in-sql

Understanding Outer Joins in SQL – SQLServerCentral The latest SQL Server articles from SQLServerCentral

https://www.red-gate.com/simple-talk/blogs/merging-tables-in-power-bi-dataflows-with-pro-subscription/

Merging tables in Power BI dataflows with PRO subscription - Simple Talk Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version

Interview and Project Support available but not included.For demo classes and more details please register at this link https://www.sqlbrains.com/register.php

https://www.red-gate.com/simple-talk/sysadmin/devops/how-to-configure-ci-cd-in-azuredevops/

How to Configure CI/CD in AzureDevOps - Simple Talk Take advantage of the CI/CD pipeline in Azure DevOps to build, test, and deploy continuously to deliver value to your customers consistently with ease. In this article, Joydip Kanjilal shows you how to get started with Azure DevOps using a .NET Core app.

https://www.sqlservercentral.com/steps/stairway-to-biml-level-8-using-the-relational-database-metadata-to-build-packages

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages – SQLServerCentral In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.