User Profile
frugecn
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Updating columns names of multiple tables dynamically
If you have a https://learn.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver16, you could just update them there and do a sync. Another way is to create a cursor for the tables and columns sys views filtered to what you tables and columns you wanted and do https://learn.microsoft.com/en-us/sql/relational-databases/tables/rename-columns-database-engine?view=sql-server-ver16 on the columns with the new generated from LEFT(column_name, CHARINDEX('_',column_name)-1) assuming that the first '_' is where you want to split from. I'm sure there are much more elegant ways as well.410Views0likes0CommentsSQL Server TDE, Azure Key Vault, and Azure Arc
With SQL 2022, there is more of a potential dependence on Azure Arc for the hybrid cloud experience, especially around security. Is there a way that we can utilize Arc with SQL Server on-prem and Azure Key Vault for managing TDE keys? If you can setup that process, will it be able to handle auto key rotations from Key Vault? I'm looking for the ability to use Key Vault for the EKM, but also be able to handle key rotation in a somewhat automated fashion. Currently, the SQL connector cannot handle key rotations, so it is a very manual process to create new logins and keys to re-encrypt the databases.823Views0likes0Comments
Recent Blog Articles
No content to show