You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
2022-01-07
Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including code examples you can copy and use immediately.
2022-01-03
In this article we look at how ingestion will read data from the landing zone and push data into the Bronze layer of the Delta Lake tables for Azure Synapse Analytics.
2021-12-13
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.
2021-11-12
In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.
2021-11-05
In this article, we will explore the HTAP capabilities of Cosmos DB. The goal is to derive real-time insights from transactional changes made to Cosmos DB, in a cost-effective manner with minimal overhead. I want the solution to be scalable, reliable and overall simple to maintain.
2021-11-03
2,189 reads
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
2021-10-08
This article demonstrates how to get started with using Auto Loader cloudFiles with Databricks through an end-to-end practical example of ingesting a data stream which has an evolving schema.
2021-10-01
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
2021-09-20
6,445 reads
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
2021-09-20
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers