Reading about the Diagnosing and Resolving Spinlock Contention on SQL
Server, rather than spin, wouldn't it make more sense to have the
threads queue for the resource ? By the way, great article
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...
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...
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...
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?
Latest Comments