- Видео 164
- Просмотров 201 263
Redincs Technology
Ямайка
Добавлен 21 окт 2017
Cannot create an instance of ole db provider error as windows authentication user
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 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:...
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 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:...
Просмотров: 30
Видео
How to Restore the latest SQL Server Backup from a Directory
Просмотров 58Месяц назад
Download Script: forms.gle/cHMEmAp9RTfKzAwx6 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 Cl...
How to Get The latest File in a Directory Using SQL
Просмотров 812 месяца назад
Download Script: forms.gle/dQha3RvX7ves2Mry8 Udemy Courses: linktr.ee/emarmorrison 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 JANUARY2...
Configure SQL Server Database Mail Using Gmail
Просмотров 2502 месяца назад
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...
Grant User Access with Expiry Date in SQL Server | Grant Temporary Access SQL Server
Просмотров 793 месяца назад
Enroll in this course on Udemy: cutt.ly/March2023 Scripts Are Available for Download in this course on Udemy. 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, ...
How to backup and restore all SQL Server Database sing PowerShell
Просмотров 2934 месяца назад
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.l...
How to Resize TempDB after Restart
Просмотров 704 месяца назад
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
Просмотров 2488 месяцев назад
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
Просмотров 3639 месяцев назад
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
Просмотров 999 месяцев назад
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
Просмотров 50510 месяцев назад
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
Просмотров 21610 месяцев назад
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
Просмотров 6710 месяцев назад
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
Просмотров 10610 месяцев назад
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
Просмотров 31710 месяцев назад
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
Просмотров 53310 месяцев назад
How to Monitor SQL Server Performance AWS
How to schedule Jobs SQL Server RDS
Просмотров 44810 месяцев назад
How to schedule Jobs SQL Server RDS
How to Enable Multi AZ Cluster SQL Server
Просмотров 6510 месяцев назад
How to Enable Multi AZ Cluster SQL Server
How to Attach and Detach SQL Server Database
Просмотров 20710 месяцев назад
How to Attach and Detach SQL Server Database
How to Grant Database Base Roles SQL Server
Просмотров 16110 месяцев назад
How to Grant Database Base Roles SQL Server
How to Create Contained User SQL Server
Просмотров 10410 месяцев назад
How to Create Contained User SQL Server
How to schedule SQL Server database backup
Просмотров 54910 месяцев назад
How to schedule SQL Server database backup
SQL Server Recovery Models Explained
Просмотров 20410 месяцев назад
SQL Server Recovery Models Explained
How to Backup Transaction Log SQL Server
Просмотров 68510 месяцев назад
How to Backup Transaction Log SQL Server
How to Configure Model Database SQL Server
Просмотров 4610 месяцев назад
How to Configure Model Database SQL Server
How do Differential Backup SQL Server
Просмотров 23110 месяцев назад
How do Differential Backup SQL Server
I had to replace (SID =DEV) with (SERVICE_NAME = your service name)
A genius!!!! Thank you!
thank you!
Very clear instructions. I managed to restore my database to a lower SQL Server version. Thank you for posting this.
Great to hear!
We mad a successful connection from SQL Server to Oracle, but the only thing is that need to use openquery t-sql function each time. Is there any way to query tables without it?
You’d need to rewrite the query
@redincs how? Provide example.
Thanks man
You're welcome!
I have q local server 2022 on windows 11, and a remote server sql 2022 on a windows server 2022, when a tried to create a linked server to a db, user an password is correct and have access to the remote DB, but can't create then linked server, always same error "Cannot create an instance of OLE DB provider "SQLNCLI10" for linked server "..." (Error 7302), somthing is missing but i don't know what
Ensure you select the right option at 1:35
@@emarversity everything is correct, whit the Microsoft SQL Server Managment Studio, i can connect correctly, but i can't create a linked server with the same access
I’d have to see to understand better.
the user need special permits, in the linked server?
Only the access that you need it to have on the database
nice video, how to connect to this RDS instance ? I have whitelisted my IP and setup the oracle bsicas, sdk and other things. but still getting : ORA-12541: Cannot connect. No listener at host Cannot connect. The database is active
S3 bucket to store database but you configured it to facing internet? Is it secure?
No it's not. If you have site VPN, you should be fine.
Well done!
Thank you!
Hi fellow. I'm getting an error when I trying to create a credential in SSMS: credentials for external storage are not allowed on RDS. I'm following all the steps you showed. Any idea of how solving this?
Look into taking a native SQL backup for RDS.
Is DBA stressful work ? Is it future proof ?
It depends on where you work
What If I don't have a Sql Server and only a SQL database?
That’s not possible, the database can’t exist without an instance.
very informative. it saved my lot of time. Thank you for posting⚡
Glad it was helpful!
what if we have rds oracle instance?
The process is the same.
This was very informative! Very simple to follow and understand.
Glad it was helpful!
bro made me lose my data base file thx
Unless you “dropped” your database files, your detached files are in directories.
you are a life saver. it worked from 2022 database to 2019 database. thank you so much.
Glad I could help!
Just saying that I skipped right over this when I saw "Backup" spelt wrong in the thumbnail
Thanks for your feedback 🫡
A BIG "THANKS" TO YOU, BROTHER!! Greetings from Peru.
Glad it helped
Big up Trevor we went to Manchester High.
💯💯💯
Fuego
Thank you so much! It worked seamlessly, i was struggling with Oracle installation for linked server with sql.
You're welcome!
This is sweet. Thanks so much
You are so welcome!
PostgreSQL AWS RDS Essential Training FREE for a Limited time: www.udemy.com/course/postgres-rds/?couponCode=OCTFREE
Very precise... Thank you
You are very welcome
anyone, my import doubled the data what could be wrong?
RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier package not avaialble.
Thank you so much.
You're welcome!
This is exactly what I needed! Thank you for the clear instructions :)
You are so welcome!
tahnk u
Is it involve a cost when restore from backup? Let's say I restored a database from 3 days ago. Then restore my data within a hour. Then delete the restored DB. In this way, I will be charged for 1 hour of storage fee?
This is quite helpful, thanks. I have an issue, where can I see the SQL Server configuration for password security parameters?
Thank you, on the properties of the instance.
HOW DO WE GET CONTENT FROM A VIEW RATHER INSTEAD OF TABLE
Yes you can
GREAT CONTENT...!!!
Thank you!
Can we able to create service principal and add it to the admin group and add the aad user to the database using script? If so can you make a video regarding that
Very simple and easy to follow explanation. Thank you
Glad it was helpful!
for security reasons on the bucket after the role is created edit the s3 bucket policy and change the principal from "Principal":* to "Principal": { "AWS": "arn:aws-west:iam::123456789123:role/service-role/name-of-role-for-bucket" }, A principal of * makes the bucket public but hidden. So prinical * is not a good setting if you want private s3 buckets for audit logs. But other than that great video.
Excellent video. Thank you so much. Can you please provide a link to part-2, thanks. I could not find it.
Hi thanks you for you feedback! I don’t have a part 2 but can checkout my courses on Udemy…the links are in the description.
Kind of interesting roles are login user equivalent, then you get into group roles. Thank you for clarifying that and the useful demonstrations!
You're very welcome!
Thank you! Very nice!
Thanks @redincs. Very helpfull!
What is the password?
Saved my life man!
Hello, have you worked in DMS from on-promise sql to cloud sql
@@rishi150511 Sadly no, just implemented on cloud
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
You’re welcome 😉