Amazon RDS

External Article

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

  • Article

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.

2017-08-30

2,895 reads

Technical Article

RE: Executing SQL in ActiveX Script Task

  • Reply

You can do the file system stuff with FileSystemObjects rather than your text file:Dim objFsoSet objFso = CreateObject("Scripting.FileSystemObject")Then see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/fsoorifilesystemobject.asp for all the nice things you can do.The way I used to run a query on an existing connection in an ActiveX task might not be the best, but it does work. I set up an […]

2005-02-04

1 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers