python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Azure SQL DB: Programmatic Backup and Restore
I am working on an automation infrastructure for an Azure based product. I need the ability to programmatically (no manual UI intervention work allowed) backup and restore an Azure SQL DB. I am lookin...
Walter Kelt
Votes: 0
Answers: 1
Refreshing permissions in Azure SQL Database for a Service Principal
I had an SQL database with one read-write role, that had an AAD group assigned, where the Server principal of my App service was added. The application was running normally, accessing the database wit...
shocks
Votes: 0
Answers: 0
Error message - 'rank' expects maximum '0' number of parameters
I'm not sure what this means, but I have a simple flow here that aggregates Region and the sum(Sales). When I want to do a ranking by sum(Sales) Partitioned by Region it gives me this strange error. '...
Peter Hui
Votes: 0
Answers: 1
Get previous row value based on a timestamp for matching IDs
I have a table about shipping that has information about the arrival (country and date) to a port. Now I need to extract the country where it departed from using the previous row entries. The table lo...
WonderCoding
Votes: 0
Answers: 1