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,281 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
9,422 reads
2022-02-28
10,333 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
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
Forums
Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing
First time here...hoping I can find some direction and answers so I can devise...
Azure elastic job issue authenticating to Azure SQL database
Azure elastic agent jobs: I’m getting this error “The server principal “ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3” is not...
Converting job_id to join to another table.
I need help, please! I have a monitoring table that pulls in information about...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers