Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-23 (first published: 2022-11-21)
34 reads
Amazon RDS
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
1,783 reads
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment
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
Running SQL Server Databases in the Amazon Cloud (Part 1)
In this tip, Sadequl Hussain outlines what's involved in rolling out a SQL Server instance in RDS. In subsequent tips, he will explore what features it offers and what shortcomings it has.
2014-06-27
3,145 reads
An Interview with Amazon Web Services
A short interview with Sundar Raghavan of Amazon Web Services about SQL Server and their support and offerings of cloud data services.
2012-09-27
1,548 reads
Setup SQL Server on Amazon RDS
Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)
2012-05-09
5,129 reads
RE: Database Backup compression
SQL native backups are ineffecint.I have also tried red gate backcup. it was ok with me.
2005-04-29
RE: Executing SQL in ActiveX Script Task
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
RE: media_set for backup question
Solved this one. Deleted existing backup file which appears to contain media family information that is read when backing up over file.
2004-04-20
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC