- 10
- 35 590
RZtechSkills
United States
เข้าร่วมเมื่อ 24 ธ.ค. 2021
HOW TO DOWNLOAD SQL SERVER 2016 FILE FROM MICROSFOT SITE.
HOW TO DOWNLOAD SQL SERVER 2016 FILE FROM MICROSFOT SITE.
มุมมอง: 644
วีดีโอ
Always Encrypted Part 1
มุมมอง 5832 ปีที่แล้ว
This video provides information on Always Encrypted. Links: pecl.php.net/package/pdo_sqlsrv/5.3.0/windows github.com/MicrosoftDocs/sql-docs/blob/live/docs/connect/php/using-always-encrypted-php-drivers.md docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver15 Courtesy of: www.rztechskills.com/
How to take Encrypted Backup of a Database
มุมมอง 1K3 ปีที่แล้ว
This Video Will Demonstrate on How to Configure SQL Server Database Encrypted Backups. Courtesy of: www.rztechskills.com/
SQL Server Cell level Encryption
มุมมอง 2513 ปีที่แล้ว
This video shows how to encrypt a column within SQL Server Table. Courtesy of: www.rztechskills.com/
SQL Server Encryption
มุมมอง 4353 ปีที่แล้ว
This Vidos Show Types, and Components of SQL Server Encryption. Courtesy of: www.rztechskills.com/
How to Download AdventureWorks Database
มุมมอง 793 ปีที่แล้ว
This Video Will Show How to Locate and Restore AdventureWorks Database. www.rztechskills.com/
How To Configure SQL Server SSL_Part3
มุมมอง 4.9K3 ปีที่แล้ว
This Demo will help you out to configure SQL Server SSL Properly. Detail: 1 - Create a Certificate Using a PowerShell Script 2 - Intro to Windows Certificates Store and Configure the Certificate 3 - Configure the Certificate Within SQL Server Configuration Manager 4 - Export and Import the Certificate 5 - Check on the SQL Connection www.rztechskills.com/
How To Configure SQL Server SSL_Part2
มุมมอง 9K3 ปีที่แล้ว
This Demo will help you out to configure SQL Server SSL Properly. Detail: 1 - Create a Certificate Using a PowerShell Script 2 - Intro to Windows Certificates Store and Configure the Certificate 3 - Configure the Certificate Within SQL Server Configuration Manager 4 - Export and Import the Certificate 5 - Check on the SQL Connection www.rztechskills.com/
How To Configure SQL Server SSL_Part1
มุมมอง 16K3 ปีที่แล้ว
This Demo will help you out to configure SQL Server SSL Properly. Detail: 1 - Create a Certificate Using a PowerShell Script 2 - Intro to Windows Certificates Store and Configure the Certificate 3 - Configure the Certificate Within SQL Server Configuration Manager 4 - Export and Import the Certificate 5 - Check on the SQL Connection www.rztechskills.com/
How to Recover a Corrupted Database
มุมมอง 2.9K3 ปีที่แล้ว
This video will show you to recover a SQL Server corrupted database. www.rztechskills.com/
Thanks for making this
New-SelfSignedCertificate -DnsName "SQLSSL" -CertStoreLocation "Cert:\CurrentUser\My" -KeySpec KeyExchange
Thanks for making this video.. it's really informative.. just one concern.. I have NT Service\MSSQLSERVER as login account for SQL service.. so do I have to give explicit permission to it or it works if SYSTEM group has full control?
Thank you
How does it goes with SQL server always on AG , can you create a video on that please or share any document
Hello Mughees! you can export the same certificate to other AlwaysOn nodes. Watch this whole series on how to import a certificate.
Thanks a lot! You saved me! 🙇♂🙇♂
This is an outstanding video of technical expertise at its very finest! These are the people who belong on TH-cam for the very reason that their videos work! Outstanding job!
Thanks for your kind words!
Great explanation! Could I force to all client conections use encrypted connection? If the client does not check Encrypt connection on SSME, it is still able to connect. I would like only encrypt connection are allowed.
How do you do it with a non self signed cert?
Avoid creating a new certificate. Import the existed certificate assuming you have one already. Then watch the video to change some setting for your certificate.
Thank You.. Following your steps in the recording, i was able to enable SSL in SQL2019
God bless you for what you did here. You saved many hours of my time.
Gracias !!!!
I need help... How can we unbind or remove it ? Without affecting the server
Really useafull!!!! So many hours of reseraching (I've tried to connect to sql Server from my C# application (C# is a programming language like Java)). There are articles out there, bu they are outdate, I dind't know ho to set that dman KeySpec property. Thanks a bunch!!🤩
Is it the same procedure when running always on HA?
was it the same have you tested if yes can you share any doc or link
Brilliant demo! Thank you!
Great videos, not just step by step, but good explanations as well. I'm still get "This certificate was issued by an authority that is not trusted" when connecting remotely. Any ideas on what I'm doing wrong?
Around the 7:30 mark where he imports the cert into "Trusted Root Store" - do that step on your remote machine
Great tutorial which gave excellent context. Thank you so much!
Thank You!
Thanks!
Is there a way to make this Self-Signed certificate issued to CA Internal server as a trusted certificate?
What you did on pages so that the db got corrupted? Pls tell me ... that means how did you corrupt a table within database...anyone is there to answer ....
I am also enthusiast to know.
Man, I can't thank you enough. I was using PowerShell to run dbatools commands and it was giving me an error when I run any command because of a certificate trust issue. It's been resolved thanks to you.
Happy it worked for you!
I'm still having problems how are you connecting to your instance (without providing your laptop or instance name) thanks.
got it
Thank you .Please share the query used to create the certificate in power shell .
Brother thank you helped me a lot, was writing a diploma project about it 😂
So excited to help!
Great presentation - I have successfully done on standalone prod server with external certificate. Can you suggest how to do this on Sql cluster environment ( 2 node)
Try to export the same certificate on Node 2.
i got an error " Target principle name is incorrect"
Check your system name, make sure its correctly typed.
Good job!👍
This was an informative, well-delivered video. I am very familiar with the PowerShell scripting program, and following his instructions to the letter allow me to get a working cert so I can could use my developer edition of SQL server. One caution I want to add, however. Please note use the PowerShell edition with IntelliSense so you don't have to write out those long string names for the commands is Windows Powershell ISE. You want to run that as Admin and not the other shell.
Thanks, how to use 1, encrypted column on Join statement. 2, Select statement with where EncryptedColumn = @EncryptedColumn inside StoredProcedure
hi did you find how to run Select statement with where EncryptedColumn = @EncryptedColumn without any problem ?
How do you get Dns name?
Hi Ian- Please watch part two. It has been explained in this series.
Thank you for the descriptive video
if I have the multiple SQL Servers, do I need to create each of SSL certification for each machine?
Hey Dav - what type of environment do you have? Please provide some details.
In a SQL Cluster what CN you have to use? the SQL virtual server name? or the node name? Thanks, great video, a very well explained. 👌
Hi Nacho! That would be your Single Node SSL Certificate that you should use for all FIC nodes.
are these 2 statements not needed? BACKUP SERVICE MASTER KEY TO FILE = 'C: ame1.key' BACKUP MASTER KEY TO FILE = 'C: ame2.key'
Hi Nestor - You may avoid backing up the SMK and DMK if your concern is migrating the backup file to another server. In this case, you only need to backup the certificate and regenerate it with its' private key. However, if at any circumstances you need you rebuild your original server, it's better idea to regenerate the same SMK and DMK for any encryption.
Outstanding explanation. excellent walk-through of SSL certification. Thank you very much.
Thanks for leaving a nice comment!
Outstanding explanation, thank you RZTechSkills.
Great presentation -- I am in a process of migrating encrypted server.. now i can export and import certificate on new server and then restore DBs
excellent.. I am stuck on migration
Great explanations! Thank you RZ TechSkills. Looking forward to seeing more videos from you.
Excellent walk through of SSL certificate creation and implementation. Is it possible to automate this process using PowerShell?
Appreciate this video! Really helped with a gnarly client problem!