SQL Server Blog

Options
2,839
amvin87 on Sep 02 2022 08:43 AM
3,008
amvin87 on Nov 02 2021 09:03 AM
3,415
amvin87 on Oct 01 2021 09:18 AM
19K
amvin87 on Jul 28 2021 08:15 AM
2,843
amvin87 on Apr 07 2021 10:58 AM
3,355
EbruErsan on Feb 23 2021 03:16 AM
9,757
amvin87 on Jan 04 2021 07:45 AM
4,286
EbruErsan on Jul 21 2020 05:52 AM
16.2K
Pedro Lopes on Jul 07 2020 07:00 AM
3,367
Pam Lahoud on Jul 01 2020 10:00 AM
3,396
Tejas Shah on Apr 13 2020 12:24 PM
4,512
Tejas Shah on Mar 25 2020 08:37 AM
7,189
Tejas Shah on Mar 17 2020 03:11 AM
7,565
Tejas Shah on Jan 08 2020 10:07 PM
3,388
Tejas Shah on Jan 06 2020 10:30 AM
3,781
EbruErsan on Dec 27 2019 01:32 AM
8,314
EbruErsan on Dec 27 2019 12:54 AM
7,020
Tejas Shah on Dec 12 2019 12:10 PM
5,646
goramesh on Dec 10 2019 03:23 PM
7,081
EbruErsan on Nov 06 2019 11:27 AM

Latest Comments

So the credential that was created (is Step 4) is associatedwith the TDE_Login (in Step 9). It is the credential that SQL uses to contact AKV. Via the Azure Active Directory Application (from Part 2) This whole process is confusing and complicated. (Written years ago - way before my time). I've trie...
0 Likes
Adrian: Thanks so much for your reply. I understand TDE_Login is tied to credential linked to Asymmetric key, but TDE_Login is used by what to contact AKV? by application? I read your posting multiple times, seems that once the database TDE is turned on, there is nothing to config, right? there is n...
0 Likes
Hello EricHe2020; Sorry for the delay in getting back to you, I've been out on leave for a few months. You are correct, this is not a login used for logging in to the server by a user. It is a login for the credential that is tied to an ASYMMETRIC Key. That is then used to contact AKV. This is a lot...
0 Likes
What if you need conditional parameters like textbox(id="txtName", Prompt="Filter by Name") strSQL = "SELECT * FROM tblNames "if txtName <> "" Thenparam = txtNamestrSQL &= "WHERE Name LIKE ?"end if ds = sqlsrv_query(conn, strSQL , param)(don't mind the syntax)Would that work?
0 Likes
Andrian; Thx for the excellent post. can I ask what is purpose of this ? this login is not for users to login? --Create a Login that will associate the asymmetric key to this loginCREATE LOGIN TDE_LoginFROM ASYMMETRIC KEY EKMSampleASYKey;
0 Likes