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,464 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,055 reads
2022-02-28
11,027 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
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers