- 159
- 152 382
Redincs Technology
Jamaica
เข้าร่วมเมื่อ 21 ต.ค. 2017
How to backup and restore all SQL Server Database sing PowerShell
Udemy Courses: linktr.ee/emarmorrison
SQL Server Coaching: cutt.ly/5wukGpf3
Download my 6-Figure template for free: subscribepage.io/resume-template
***** Udemy Courses ******
For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it?
Database Design Master Class: cutt.ly/PwG3KYcr
Azure SQL Database Administration: cutt.ly/IwG3KsBI
SQL Server 2022 Essential Training: cutt.ly/March2023
PostgreSQL Database Essential Training: cutt.ly/postgres
AWS Oracle RDS Database Administration Essential Training: cutt.ly/Oracle_RDS
Mastering SQL Server on AWS: cutt.ly/L6AC8fX
Mastering Amazon RDS for PostgreSQL on AWS: cutt.ly/AwhVZwvs
Learn SQL for Beginners: cutt.ly/AwhVZwvs
******* Connect with me on:
Discord: discord.gg/AFrWkUVwh3
LinkedIn: www.linkedin.com/in/emarmorrison/
SQL Server Coaching: cutt.ly/5wukGpf3
Download my 6-Figure template for free: subscribepage.io/resume-template
***** Udemy Courses ******
For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it?
Database Design Master Class: cutt.ly/PwG3KYcr
Azure SQL Database Administration: cutt.ly/IwG3KsBI
SQL Server 2022 Essential Training: cutt.ly/March2023
PostgreSQL Database Essential Training: cutt.ly/postgres
AWS Oracle RDS Database Administration Essential Training: cutt.ly/Oracle_RDS
Mastering SQL Server on AWS: cutt.ly/L6AC8fX
Mastering Amazon RDS for PostgreSQL on AWS: cutt.ly/AwhVZwvs
Learn SQL for Beginners: cutt.ly/AwhVZwvs
******* Connect with me on:
Discord: discord.gg/AFrWkUVwh3
LinkedIn: www.linkedin.com/in/emarmorrison/
มุมมอง: 54
วีดีโอ
How to Resize TempDB after Restart
มุมมอง 2821 วันที่ผ่านมา
Udemy Courses: linktr.ee/emarmorrison SQL Server Coaching: cutt.ly/5wukGpf3 Reference: www.mssqltips.com/sqlservertip/4829/tempdb-size-resets-after-a-sql-server-service-restart/ Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watch...
How Create Oracle RDS Database
มุมมอง 1214 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Create User in Oracle Database
มุมมอง 1325 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
Oracle User Roles Explained
มุมมอง 415 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Restore SQL Server RDS Database to Point-in-time
มุมมอง 2456 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to delete RDS Instance
มุมมอง 946 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Modify SQL Server RDS Instance
มุมมอง 356 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Stop and Start SQL RDS Instance
มุมมอง 606 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Create and Connect to SQL Server RDS
มุมมอง 1496 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Monitor SQL Server Performance AWS
มุมมอง 2556 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to schedule Jobs SQL Server RDS
มุมมอง 2156 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Enable Multi AZ Cluster SQL Server
มุมมอง 516 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/L6AC8fX For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Master...
How to Attach and Detach SQL Server Database
มุมมอง 776 หลายเดือนก่อน
Enroll in this course on Udemy: cutt.ly/March2023 For one-on-one Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Udemy Courses For 50% off, use the coupon code in the format Month Year, eg. AUGUST2024 because we create coupons each month. So, if you are watching this in January 2024, the coupon will be JANUARY2024, Got it? Database Design Mast...
How to Grant Database Base Roles SQL Server
มุมมอง 986 หลายเดือนก่อน
Private Database Mastery Level-Up Coaching: cutt.ly/5wukGpf3 Download my 6-Figure template for free: subscribepage.io/resume-template Advance your career or learn some new skills with one of these courses For 50% off, use the Coupon Code in the format Month Year eg. AUGUST2023 because we create coupons each month. So, if you are watching this January 2024 the coupon will be JANUARY2024, Got it?...
How to Create Contained User SQL Server
มุมมอง 666 หลายเดือนก่อน
How to Create Contained User SQL Server
How to schedule SQL Server database backup
มุมมอง 2116 หลายเดือนก่อน
How to schedule SQL Server database backup
How to Backup Transaction Log SQL Server
มุมมอง 2246 หลายเดือนก่อน
How to Backup Transaction Log SQL Server
How to Configure Model Database SQL Server
มุมมอง 266 หลายเดือนก่อน
How to Configure Model Database SQL Server
SQL Server Capacity Planning and Growth Consideration
มุมมอง 816 หลายเดือนก่อน
SQL Server Capacity Planning and Growth Consideration
SQL Server Database Storage strategies
มุมมอง 96 หลายเดือนก่อน
SQL Server Database Storage strategies
What is the difference between users and logins SQL Server?
มุมมอง 356 หลายเดือนก่อน
What is the difference between users and logins SQL Server?
What is SQL Server Configuration Manager
มุมมอง 1076 หลายเดือนก่อน
What is SQL Server Configuration Manager
Kind of interesting roles are login user equivalent, then you get into group roles. Thank you for clarifying that and the useful demonstrations!
Thank you! Very nice!
Thanks @redincs. Very helpfull!
What is the password?
Saved my life man!
This might sound silly, but how do you know your host name? Very new to all this
@@jesseJBM go to “this PC”..and check properties.
Hello sir I am from India can you please upload video on data validation after putting it from s3 to RDS , whatever difference we will get how to analyse and run what kind of SQL query to resolve the difference after migration.
this not bakop this back up
First of all I love that you are from the Caribbean...big up to you😊
Thank you so much 🤗
Thank you! This not only solved my issue but saved me $$ doing something I was trying to do in a Data Factory.
very well done , love you, i had all these errors and i got stcuck , thank you soo much for your support, ithink i will be able to fix those issues
I have also seen the option while doing backup to enter the destination as disk or url . can we directly send the backup files to s3 using the url option?
Yes, if you’re SQL 2022. I have a video on how to back to AWS S3 bucket.
Excellent!
Thank you! Cheers!
thanks for sharing
My pleasure
bro you saved me!
Glad I could help
When I go to Option Groups in RDS, the 'Add Option' tab is greyed out for me, so I'm unable to add option. Not sure what I'm doing wrong.
I think you're skipping too many steps
IS It ok if my Database in always on mode?
Unable to get Database node under the server connection.
New subscriber. So refreshing and surprising to see a fellow Jamaican in data especially data admin. I’m a data analyst that is interested in building data admin skills to pick up dba roles. I’ll be tuned into your channel heavily.
Awesome! I'm happy to hear that!
is there a way to make this a scheduled backup like how it is done in SQL Server EC2? like SQLagent where it saves daily backup and retention in the server local drive? Is similar possible with AWS S3?
You can use power shell to achieve it.
Muchas gracias!!!
Muchas gracias por compartir tus conocimientos!!! Saludos desde Bolivia!!!
Thank you!
Thank you so much!! I'm an Oracle guy and SQL Server drives me crazy. This video showed me exactly what I needed.
You're welcome!
Pratical information, easy to digest, in a short time. Thank you.
Wow, very helpful. Thanks
great stuff thank you!
did someone try 2022 to 2019?
Where did you write store procedures in onprem sql.or azure sql ? Can we use this method to sync data between two dbs ? I have other team onprem sql db , I want to consume some tables from others team db to my team azure sql db
Create a link server to consume data.
azure sql
@redincs ok linking servers is one step. I want 19 tables and its data on my azure sql with latest data for every 30 seconds ... I believe second step would be writing this stored procedure and run on schdudlng . Correct me if im wrong.and I use this tablet in my .net api ef core project .
Is this backup stored in S3?
No it’s not
Nice
كبير ياولد، بصراحة من اجمل المراجعات اللي اشوفها وعجبتني وصلتلي كل النقاط بشكل مختصر و واضح
Thank you!
Really appreciate it! This is what I exactly was looking for 🥹
does automated backups has cost?
Thank you!!! Helped me a lot.
You're welcome!
Hi, When we modify instance type will we loss our data?
Hi, no it won’t
Thank you for providing this however some things for your next edition: 1- Please teach us based on the SQL 7.1 module. 2- Please Use Azure Managed Identity / Server Principal. 3- Please parameterize to run a Sproc on the DB side. * Also you mentioned the IP on the Firewall, is there any chance to show us that one as well? Many Thanks!
Hello Thanks a lot for your demo, Sir it's will save some hours on my side
Glad to hear that!
great video i have one question if i want ot automate this task just to compare and notify me there is a change and i want to export this result in excel sheet What should i do ?
Hey, I’m not sure if it’s possible in later versions to export. You can also use Azure data studio to compare database which have the ability to export the results.
@@redincs Thanks for your reply ✌️👍
Hi! this video is exactly what i've been looking for. huge thank you for this!!! i have a question, will this also remove the files in s3 that are no longer in server? the reason is i have maintenace task in SQL to clean up the back up files older than 7 days in server but i want to make sure the "removed" files remain in s3 when synced
Thank you. No, you would need another script to delete the s3 files.
@@redincs awesome! thanks
I am getting error like "External references are not supported when creating a package from this platform." How to handle this kind of scenario ?
Please provide more details l…
Is there any chance we can run this task right after the job on SQL Server is done?
Yes...create job step in the main job
Enroll in Azure SQL Database Administration Course for free: www.udemy.com/course/azure-sql-database-administration/?couponCode=APR2024FREE
Is this backup supported only windows 2022 or later? please share if you have aws documents to confirm
Yes 2022 and later. Doc: learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-s3-compatible-object-storage?view=sql-server-ver16
Tome mi me gusta amigo... Muchas Gracias... no se por que youtube me muestra este video en mi tercer día de búsqueda
You’re welcome!😇
Thanks so much. This was very helpful. I'm considering a career change. No. I'm not considering, I WILL BE making a career change. I know I can do this!
Hello, I was looking at your video channel. We may be helping a company that uses secure images to increase supply chain security and help cloud native development. Would you be willing to help try their software, make a video, and help show devs how to use their tools? This is not an offer, but just to start a conversation about your willingness to take on sponsorship. Please provide me with your email if you are interested. You'd have a chance to look at their technology and decide if it's the type of software that you'd be interested in covering in your channel.
Thank you for reaching out. I can be contacted at emarversity@gmail.com
This was so well done. Great video!
Thank you so much!
Amazing! So clear and to the point. Thanks
Glad it was helpful!
thank you so much my friend you did an amazing work. I have been trying to figure out this for hours because i installed the oracle client 11 g 32 bits and my sql server is 2022 tnsping worked by the ssms was not able to see the oracle provided. I followed lot of different pages. at the end I saw your video which saved me. thanks again for saving my day you are genius. God bless you.!!
Thank you for you comment, I appreciate it!
thks Guy, that's easy to get!