Author
Azure SQL: Recover Deleted Records
Via Azure Portal, restore a copy of the database from a backup at specific point in time. Via SSMS, copy over deleted records from recovered database back to the original database. Note: In Azure Portal, go to the original database and select “Retore”. Select a point in time before the accidental delete occurred. Time is... » read more
Always On Automatic Failover Jobs
In addition to the automatic failover that occurs for Always On setup, these jobs also needs to be created on both the Primary and the Secondary server to help with the automatic failover. In the event of a failover, all user jobs should be disabled on the Secondary server and enabled on the Primary server... » read more
Add New Job Category
2 Options to add new Job Category via Script via GUI Via Script Via SSMS In Management Studio, the same process is exposed via a dialog located under the SQL Server Agent Jobs node in the Object Explorer as shown below: Right-click the highlighted item and you are presented with the Manage Job Categories dialog... » read more
Azure Function Setup Environment Configuration
You can setup Configuration Variables to store database connection strings or keys at the application level. You can get retrieve that value to be used in any of your functions. Azure Function -> Settings -> Configuration -> New application setting MyKey01 = “xxxxxxxxxxxxxxx”
Debug WCF Service
Put a debug break point in the WCF code. Run the web app that is calling the WCF services. Go back to Visual Studio -> “Debug” -> “Attach To Process” and select the WCF services (MyService01.exe). Go back to the web app and run the code to reach the break point. You need to attach... » read more
Create SQL Login for SQL Azure Database
Generating Logins Logins are server wide login and password pairs, where the login has the same password across all databases. Here is some sample Transact-SQL that creates a login: You must be connected to the master database on SQL Azure with the administrative login (which you get from the SQL Azure portal) to execute the... » read more
NCRONTAB Used By Azure Function
Example When Triggered 0 */5 * * * * once every five minutes 0 0 * * * * once at the top of every hour 0 0 */2 * * * once every two hours 0 0 9-17 * * * once every hour from 9 AM to 5 PM 0 30 9 *... » read more