Redincs Technology
Redincs Technology
  • Видео 164
  • Просмотров 201 263
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:...
Просмотров: 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
SQL Server Activity Moniter
Просмотров 2910 месяцев назад
SQL Server Activity Moniter
How to schedule SQL Server database backup
Просмотров 54910 месяцев назад
How to schedule SQL Server database backup
What is SQL Server Agent?
Просмотров 74710 месяцев назад
What is SQL Server Agent?
How to Configure Database Mail
Просмотров 21210 месяцев назад
How to Configure Database Mail
SQL Server Recovery Models Explained
Просмотров 20410 месяцев назад
SQL Server Recovery Models Explained
SQL Server Roles Explained
Просмотров 20810 месяцев назад
SQL Server Roles 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

Комментарии

  • @sebadigiorgio1770
    @sebadigiorgio1770 3 дня назад

    I had to replace (SID =DEV) with (SERVICE_NAME = your service name)

  • @sebadigiorgio1770
    @sebadigiorgio1770 3 дня назад

    A genius!!!! Thank you!

  • @chengtan2110
    @chengtan2110 7 дней назад

    Very clear instructions. I managed to restore my database to a lower SQL Server version. Thank you for posting this.

    • @redincs
      @redincs День назад

      Great to hear!

  • @dataanalyst839
    @dataanalyst839 8 дней назад

    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?

    • @redincs
      @redincs 7 дней назад

      You’d need to rewrite the query

    • @dataanalyst839
      @dataanalyst839 7 дней назад

      @redincs how? Provide example.

  • @GoshaVivisektor
    @GoshaVivisektor 9 дней назад

    Thanks man

    • @redincs
      @redincs 7 дней назад

      You're welcome!

  • @joseluisjimenezinocente178
    @joseluisjimenezinocente178 10 дней назад

    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

    • @emarversity
      @emarversity 10 дней назад

      Ensure you select the right option at 1:35

    • @joseluisjimenezinocente178
      @joseluisjimenezinocente178 10 дней назад

      @@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

    • @redincs
      @redincs 5 дней назад

      I’d have to see to understand better.

  • @joseluisjimenezinocente178
    @joseluisjimenezinocente178 12 дней назад

    the user need special permits, in the linked server?

    • @redincs
      @redincs 12 дней назад

      Only the access that you need it to have on the database

  • @VishwajeetDabholkar
    @VishwajeetDabholkar 15 дней назад

    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

  • @khoale8688
    @khoale8688 16 дней назад

    S3 bucket to store database but you configured it to facing internet? Is it secure?

    • @redincs
      @redincs 16 дней назад

      No it's not. If you have site VPN, you should be fine.

  • @gebstryker4641
    @gebstryker4641 Месяц назад

    Well done!

    • @redincs
      @redincs Месяц назад

      Thank you!

  • @stivenguillermobuenoreinos7462
    @stivenguillermobuenoreinos7462 Месяц назад

    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?

    • @emarversity
      @emarversity Месяц назад

      Look into taking a native SQL backup for RDS.

  • @yrysf777
    @yrysf777 Месяц назад

    Is DBA stressful work ? Is it future proof ?

    • @emarjm
      @emarjm Месяц назад

      It depends on where you work

  •  Месяц назад

    What If I don't have a Sql Server and only a SQL database?

    • @emarjm
      @emarjm Месяц назад

      That’s not possible, the database can’t exist without an instance.

  • @farazahmad56
    @farazahmad56 Месяц назад

    very informative. it saved my lot of time. Thank you for posting⚡

    • @redincs
      @redincs Месяц назад

      Glad it was helpful!

  • @TalhaIftikhar-wj3bu
    @TalhaIftikhar-wj3bu Месяц назад

    what if we have rds oracle instance?

  • @phantxmh
    @phantxmh Месяц назад

    This was very informative! Very simple to follow and understand.

    • @redincs
      @redincs Месяц назад

      Glad it was helpful!

  • @yourfeedYT
    @yourfeedYT Месяц назад

    bro made me lose my data base file thx

    • @redincs
      @redincs Месяц назад

      Unless you “dropped” your database files, your detached files are in directories.

  • @ravenz6295
    @ravenz6295 Месяц назад

    you are a life saver. it worked from 2022 database to 2019 database. thank you so much.

    • @redincs
      @redincs Месяц назад

      Glad I could help!

  • @OZTutoh
    @OZTutoh Месяц назад

    Just saying that I skipped right over this when I saw "Backup" spelt wrong in the thumbnail

    • @emarversity
      @emarversity Месяц назад

      Thanks for your feedback 🫡

  • @KleinPinto
    @KleinPinto 2 месяца назад

    A BIG "THANKS" TO YOU, BROTHER!! Greetings from Peru.

    • @redincs
      @redincs 2 месяца назад

      Glad it helped

  • @richarddarling8418
    @richarddarling8418 2 месяца назад

    Big up Trevor we went to Manchester High.

    • @redincs
      @redincs 2 месяца назад

      💯💯💯

  • @greenedigital4449
    @greenedigital4449 2 месяца назад

    Fuego

  • @milestomemoriez
    @milestomemoriez 2 месяца назад

    Thank you so much! It worked seamlessly, i was struggling with Oracle installation for linked server with sql.

    • @redincs
      @redincs 2 месяца назад

      You're welcome!

  • @JBS439
    @JBS439 2 месяца назад

    This is sweet. Thanks so much

    • @redincs
      @redincs 2 месяца назад

      You are so welcome!

  • @redincs
    @redincs 3 месяца назад

    PostgreSQL AWS RDS Essential Training FREE for a Limited time: www.udemy.com/course/postgres-rds/?couponCode=OCTFREE

  • @lksvasan
    @lksvasan 3 месяца назад

    Very precise... Thank you

    • @redincs
      @redincs 3 месяца назад

      You are very welcome

  • @pavanjoshi1
    @pavanjoshi1 3 месяца назад

    anyone, my import doubled the data what could be wrong?

  • @pavanjoshi1
    @pavanjoshi1 3 месяца назад

    RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier package not avaialble.

  • @ziadfawzi
    @ziadfawzi 3 месяца назад

    Thank you so much.

    • @redincs
      @redincs 3 месяца назад

      You're welcome!

  • @5t1300
    @5t1300 3 месяца назад

    This is exactly what I needed! Thank you for the clear instructions :)

    • @redincs
      @redincs 3 месяца назад

      You are so welcome!

  • @BoomLoop-o9l
    @BoomLoop-o9l 3 месяца назад

    tahnk u

  • @legendgod
    @legendgod 3 месяца назад

    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?

  • @VictorOluwatola
    @VictorOluwatola 3 месяца назад

    This is quite helpful, thanks. I have an issue, where can I see the SQL Server configuration for password security parameters?

    • @redincs
      @redincs 3 месяца назад

      Thank you, on the properties of the instance.

  • @rowlandjones3872
    @rowlandjones3872 3 месяца назад

    HOW DO WE GET CONTENT FROM A VIEW RATHER INSTEAD OF TABLE

    • @redincs
      @redincs 3 месяца назад

      Yes you can

  • @rowlandjones3872
    @rowlandjones3872 3 месяца назад

    GREAT CONTENT...!!!

    • @redincs
      @redincs 3 месяца назад

      Thank you!

  • @chethank920
    @chethank920 3 месяца назад

    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

  • @user-fk8zw5js2p
    @user-fk8zw5js2p 3 месяца назад

    Very simple and easy to follow explanation. Thank you

    • @redincs
      @redincs 3 месяца назад

      Glad it was helpful!

  • @a.j4690
    @a.j4690 4 месяца назад

    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.

  • @kvbd2710
    @kvbd2710 4 месяца назад

    Excellent video. Thank you so much. Can you please provide a link to part-2, thanks. I could not find it.

    • @redincs
      @redincs 4 месяца назад

      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.

  • @ryanshannon6963
    @ryanshannon6963 4 месяца назад

    Kind of interesting roles are login user equivalent, then you get into group roles. Thank you for clarifying that and the useful demonstrations!

    • @redincs
      @redincs 4 месяца назад

      You're very welcome!

  • @rarant5693
    @rarant5693 4 месяца назад

    Thank you! Very nice!

  • @abdouldia1605
    @abdouldia1605 4 месяца назад

    Thanks @redincs. Very helpfull!

  • @ChristopherCosta2016
    @ChristopherCosta2016 4 месяца назад

    What is the password?

  • @HenriquePLima
    @HenriquePLima 4 месяца назад

    Saved my life man!

    • @rishi150511
      @rishi150511 2 месяца назад

      Hello, have you worked in DMS from on-promise sql to cloud sql

    • @HenriquePLima
      @HenriquePLima 2 месяца назад

      @@rishi150511 Sadly no, just implemented on cloud

  • @jesseJBM
    @jesseJBM 4 месяца назад

    This might sound silly, but how do you know your host name? Very new to all this

    • @redincs
      @redincs 4 месяца назад

      @@jesseJBM go to “this PC”..and check properties.

  • @MotinAi-Tube
    @MotinAi-Tube 4 месяца назад

    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.

  • @NikhilVargude
    @NikhilVargude 4 месяца назад

    this not bakop this back up

  • @darswayeeyou
    @darswayeeyou 4 месяца назад

    First of all I love that you are from the Caribbean...big up to you😊

    • @redincs
      @redincs 4 месяца назад

      Thank you so much 🤗

  • @zb470
    @zb470 4 месяца назад

    Thank you! This not only solved my issue but saved me $$ doing something I was trying to do in a Data Factory.

  • @mithilanavishka9884
    @mithilanavishka9884 4 месяца назад

    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

    • @redincs
      @redincs 3 месяца назад

      You’re welcome 😉