Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
15,377 reads
Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.
2017-12-29
5,408 reads
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
This script will upload the latest backup files to an AWS S3 bucket
2014-11-14 (first published: 2014-09-14)
1,538 reads
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
91 reads
Here's how I open a record set that uses a stored proc proc code : CREATE PROCEDURE [dbo].[SPNDemo] @ObjectName as varchar(50), @id as int output AS SET NOCOUNT ON SET @id = object_id(@ObjectName) SELECT name , XType FROM dbo.SysObjects WHERE name like '%' + @ObjectName + '%' ORDER BY XType, Name IF @@Rowcount > 0 […]
2005-05-27
Interesting reading. Thank you for taking the time to share the ideas.
2005-05-16
Heres a copy of the column in question. AUDITTIMESTAMP 1087846893579 1087924923734 1104764681188 1104732392516 1087846893610 1104741005453 1087846893657 1104693744344 1104741246891 1087846893735I'm using this statement to see the dates, but I can't get it to work with deleting any records over 30 days old. SELECT DATEADD(hh, - 05, DATEADD(ss, AUDITTIMESTAMP / 1000, '01/01/1970')) AS ts, * Thanks
2005-05-06
Yes, Siva, I've allready checked these IP addresses. It doesn't work. Neither physical nor virtual. On sql server log it's said that one node listen to xx.xx.xx.x1 :1433 , other node- xx.xx.xx.x2:1424These ports have been assigned dynamically. When I try to connect from cluster node to outside SQL server by its IP address all works […]
2005-05-06
Ah - I do have an index on it. It's a name though - not very like to chnage much.
2005-05-06
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers