Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Learn how it works and how to use the DENSE_RANK() function in your code.
2024-04-12
3,538 reads
azure sql
Using Virtual Network Data Gateways to Secure Access to Azure SQL in Power BI
Power BI and Azure are two related services, but with a considerable independence between them. Power BI share the Azure Tenant for security management, but in relation to networking, they are in completely different environments.
2023-07-12
Monitoring Azure SQL Databases
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]
2022-03-18
10,208 reads
2022-02-28
11,155 reads
Schedule Azure SQL DB Processes using Azure Functions
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
2021-08-30
Getting Started with Azure Purview for Data Governance
In this article we will explore how to get started with Azure Purview and then explore some of the features within Purview Studio.
2021-06-28
SQL Monitor v11.1 now supports Azure SQL Managed Instances
Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.
2021-04-15
Digital Event: Innovate Today with Azure SQL
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-14
Azure AD Authentication for Azure SQL Databases
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
2021-03-19
Using Azure SQL Data Sync to Replicate Data
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
2021-03-02
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers