SQL Server Blog

Options
7,188
DavidEngelMS on Mar 07 2023 10:16 AM
1,889
DavidEngelMS on Feb 15 2023 08:10 AM
2,031
DavidEngelMS on Feb 15 2023 08:00 AM
1,693
DavidEngelMS on Feb 01 2023 02:36 PM
1,838
DavidEngelMS on Jan 30 2023 09:00 AM
2,577
David-Engel on Jan 20 2023 09:45 AM
1,509
David-Engel on Jan 13 2023 02:35 PM
1,536
David-Engel on Jan 13 2023 02:29 PM
1,811
David-Engel on Dec 16 2022 01:04 PM
1,701
David-Engel on Dec 16 2022 12:58 PM
1,201
David-Engel on Dec 15 2022 08:30 AM
1,399
David-Engel on Dec 09 2022 08:00 AM
2,280
David-Engel on Dec 05 2022 05:19 PM
2,048
David-Engel on Nov 10 2022 04:15 PM
1,323
David-Engel on Nov 03 2022 05:07 PM
3,355
David-Engel on Nov 03 2022 02:54 PM
1,953
David-Engel on Oct 26 2022 04:18 PM
2,270
David-Engel on Oct 21 2022 08:00 AM
2,705
David-Engel on Oct 13 2022 04:29 PM
1,506
David-Engel on Sep 14 2022 05:12 PM
1,054
David-Engel on Sep 14 2022 11:00 AM
1,784
David-Engel on Sep 14 2022 09:00 AM
2,254
David-Engel on Sep 13 2022 04:54 PM
1,324
David-Engel on Aug 31 2022 09:00 AM
1,870
David-Engel on Aug 12 2022 03:00 PM
2,992
David-Engel on Aug 09 2022 03:34 PM
2,633
David-Engel on Aug 09 2022 03:19 PM
3,015
David-Engel on Aug 08 2022 09:40 AM
8,528
David-Engel on Jul 13 2022 01:20 PM
1,102
David-Engel on Jun 23 2022 11:00 AM

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