SQL Server Blog

Options
3,930
subhojitbasak on Dec 19 2022 05:35 AM
2,506
BobDorr on Oct 03 2022 03:27 PM
3,130
zimwang_1993 on Feb 23 2021 08:42 AM
3,218
Kevin Farlee on Oct 19 2020 10:49 AM
20.4K
Mine Tokus on Jul 06 2020 09:51 AM
52.8K
Amit Banerjee on Mar 05 2020 11:38 PM
480
SQL-Server-Team on Mar 23 2019 01:24 PM
651
SQL-Server-Team on Mar 23 2019 01:23 PM
339
SQL-Server-Team on Mar 23 2019 01:23 PM
515
SQL-Server-Team on Mar 23 2019 01:23 PM
331
SQL-Server-Team on Mar 23 2019 01:22 PM
287
SQL-Server-Team on Mar 23 2019 01:22 PM
421
SQL-Server-Team on Mar 23 2019 01:21 PM
699
SQL-Server-Team on Mar 23 2019 01:20 PM
545
SQL-Server-Team on Mar 23 2019 01:19 PM
1,166
SQL-Server-Team on Mar 23 2019 01:18 PM
3,528
SQL-Server-Team on Mar 23 2019 01:15 PM
431
SQL-Server-Team on Mar 23 2019 01:01 PM
706
SQL-Server-Team on Mar 23 2019 12:59 PM
1,283
SQL-Server-Team on Mar 23 2019 12:58 PM
595
SQL-Server-Team on Mar 23 2019 12:57 PM
3,370
SQL-Server-Team on Mar 23 2019 12:56 PM
867
SQL-Server-Team on Mar 23 2019 12:55 PM
1,391
SQL-Server-Team on Mar 23 2019 12:55 PM
945
SQL-Server-Team on Mar 23 2019 12:50 PM
1,170
SQL-Server-Team on Mar 23 2019 12:49 PM
1,348
SQL-Server-Team on Mar 23 2019 12:49 PM

Latest Comments

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
0 Likes
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