azure-sql-database
How do I change the name of an Azure Resource Group?
Edit: You can’t rename an Azure Resource Group. What you can do is move your resources to a new Resource Group instead. Moving all resources in Resource Group A to Resource Group B is the poor man’s rename. Unfortunately not all resource providers let you move resources between resource groups, and some that do might … Read more
Password reset for Azure database
If you’re referring to the administrative password for a specific Windows Azure SQL Database server, you can do this from the new portal. Select the Database choice on the left, then select Servers: Then, after selecting the server of choice, you’ll see the option on the right for resetting admin password:
Optimal way to concatenate/aggregate strings
SOLUTION The definition of optimal can vary, but here’s how to concatenate strings from different rows using regular Transact SQL, which should work fine in Azure. ;WITH Partitioned AS ( SELECT ID, Name, ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Name) AS NameNumber, COUNT(*) OVER (PARTITION BY ID) AS NameCount FROM dbo.SourceTable ), Concatenated AS … Read more
The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
Open SQL Management Studio Expand your database Expand the “Security” Folder Expand “Users” Right click the user (the one that’s trying to perform the query) and select Properties. Select page Membership. Make sure you uncheck db_denydatareader db_denydatawriter This should go without saying, but only grant the permissions to what the user needs. An easy lazy … Read more