Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. November 2023

Announcing: Fabric Warehouse support for sp_rename

We are excited to announce that the Data Warehouse now supports sp_rename.

With sp_rename, you can rename user objects like Tables, Stored Procedures, Functions etc.

Here is an example of how to use sp_rename that fixes a spelling mistake for city:

sp_rename [dbo.dimension_ctiy], [dimension_city];

When you use these features, change the schema an object belongs to or drop a table, the changes will be reflected in OneLake within 1 minute.

For More information, please see our documentation:

sp_rename (Transact-SQL) – SQL Server | Microsoft Learn

Related blog posts

Announcing: Fabric Warehouse support for sp_rename

Blog's featured image

Mirroring SQL Server database to Fabric
August 12, 2024 by Kal Yella

Fabric Mirroring ingests and replicates data continuously in near real-time from sources such as Azure Cosmos DB, Azure SQL Database, Snowflake into Microsoft Fabric. However, it is currently restricted to the above data sources. This blog explains how we can extend Fabric mirroring to an on-prem SQL Server database as a source, using a combination of SQL Server Transactional replication and Fabric Mirroring.

Read more
Blog's featured image

Announcing the availability of Trusted workspace access and Managed private endpoints in any Fabric capacity
August 2, 2024 by Meenal Srivastva

Use Trusted workspace access and Managed Private endpoints in Fabric with any F capacity and enjoy the benefits of secure and optimized data access and connectivity  We are thrilled to share with you an update on the Fabric network security features that were announced in general availability earlier this year. Trusted workspace access, and Managed … Continue reading “Announcing the availability of Trusted workspace access and Managed private endpoints in any Fabric capacity”

Read more