Hi Ral1l - Thank you for your reply. We have SQL running on EC2 instance and not Amazon RDS, there are limitations with running on RDS. Thank you.

Steve,

Thank you for the update, we ended up not using the instance storage. Our environment is an AG, saved myself some headache 🙂

Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of RDMS needs to...

I know this is an old post, but I wanted to share my experience... I highly recommend not to place tempdb files on instance storage in a production environment because...

You are correct, I know you can't declare variables in a view, I guess I should have said how to make this as a function or a SP and create...

I know this is a very old post, but I too wanted to do this today.. I found a PowerShell script similar to what I have below but the select...

Greetings Joe, thank you for sending the query. I followed John's query, and that worked perfectly. 
I was thinking of using merge, but I was wrong. I am glad I...

Hi John,
I agree, I figured my approach with using merge was incorrect. I am following your approach and see how it goes. Thank you for your input.

I have not used json, but why don't you try to use Powershell, http://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/ec2launch.html

If I have time tomorrow, I will play with it and update you. I use...

My understanding is that when you rebuild an index, only index stats gets updated but it does not update column stats. What you have is correct, you are saying do...

Great, BTW here is how to ignore truncation error with import wizard.. Thanks for replying back.

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/review-data-type-mapping-sql-server-import-and-export-wizard

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard

Are you using data conversion for doing data transfer, have you tried to ignore truncation if error happened? See attachment.

Sue,
I agree, I could remove rule of CEIP by issuing Remove-ClusterResource but I preferred not do so because it was not recommended. Even though the documentation shows how to...

Hi Prettsons,
My one challenge setting up the cluster is the CEIP resource, I had to deal with security issue and not having the resource failover properly to the other node. Is it...

I use Ola's solution, but try to adjust some of the default settings based on your environment, I specify below parameters:

sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d Maint_DB -Q "EXECUTE...