SQL Server Blog

Options
680
David-Engel on May 13 2022 10:47 AM
921
David-Engel on Apr 22 2022 10:34 AM
1,550
David-Engel on Apr 13 2022 11:17 AM
819
David-Engel on Apr 06 2022 09:50 AM
1,696
David-Engel on Mar 11 2022 09:00 AM
1,802
David-Engel on Feb 15 2022 01:58 PM
5,898
David-Engel on Feb 15 2022 01:39 PM
3,036
David-Engel on Feb 01 2022 11:11 AM
1,090
David-Engel on Jan 31 2022 11:56 AM
2,433
David-Engel on Jan 20 2022 11:41 AM
1,248
David-Engel on Dec 21 2021 01:30 PM
1,429
David-Engel on Dec 15 2021 11:00 AM
1,572
David-Engel on Dec 08 2021 12:25 PM
2,207
vwarchu on Dec 03 2021 03:01 PM
2,444
David-Engel on Dec 02 2021 01:00 PM
7,770
David-Engel on Nov 19 2021 08:00 AM
1,854
David-Engel on Nov 09 2021 01:37 PM
2,294
David-Engel on Oct 21 2021 08:30 AM
3,524
David-Engel on Sep 24 2021 03:26 PM
1,534
David-Engel on Sep 21 2021 03:08 PM
1,792
David-Engel on Sep 20 2021 06:58 PM
3,532
David-Engel on Sep 08 2021 02:19 PM
3,237
David-Engel on Aug 25 2021 01:56 PM
2,808
vwarchu on Aug 17 2021 09:00 AM
4,112
David-Engel on Aug 05 2021 11:41 AM
5,947
David-Engel on Jul 30 2021 01:52 PM
2,462
David-Engel on Jun 21 2021 01:38 PM
7,093
David-Engel on Jun 09 2021 12:35 PM
2,198
David-Engel on May 21 2021 02:29 PM
2,332
David-Engel on May 21 2021 11:40 AM

Latest Comments

Hi Amit, I tried .Net framework client app in the same AKS cluster but getting error for MSDTC transaction. In Single AKS, Windows container on windows 2019 node with .Net framework app using new TransactionScope() library and trying to us SQL deployed in linux node. It tries to update two tables in...
0 Likes
Hi Dhaval, if you are hosting the application container in the same aks cluster then you should be able to connect using the SQL container names but if the app container is outside the aks cluster then using the load balancer ip address should work for you and then you can open the msdtc transaction...
1 Likes
in Dynamic SQL & SQL injection on May 08 2022 01:09 PM
It is really hard to do dynamic SQL safely and performant. I recommend using something like sp_CRUDGen to generate a dynamic TSQL stored procedure with best practices for kitchen sink (optional parameters) queries. The custom software development company I work for (https://www.emergentsoftware.net)...
0 Likes
@amvin87 I am using AKS cluster. Hosted SQL server linux container in Linux node. Now if I host .Net framework application using SQLClient database connection and new TransactionScope() (MSDTC from c#), will it work or I need to take care of something else apart from above documentation?
0 Likes
I follow your step in the On Premise environment, but It doesn't work on load balance External IP is in pending status.What can I do if the deployment in On premise environment please advice.
0 Likes