SQL Server Blog

Options
726
David-Engel on May 13 2022 10:47 AM
756
BobDorr on Apr 25 2022 07:14 AM
936
David-Engel on Apr 22 2022 10:34 AM
1,371
BobDorr on Apr 20 2022 08:15 AM
1,895
SrinivasSQL on Apr 19 2022 08:27 AM
1,567
David-Engel on Apr 13 2022 11:17 AM
3,574
Kendal Van Dyke on Apr 11 2022 12:30 PM
830
David-Engel on Apr 06 2022 09:50 AM
1,879
Pam Lahoud on Apr 05 2022 10:41 AM
1,525
HristinaSQL on Mar 31 2022 11:18 AM
5,109
EbruErsan on Mar 14 2022 07:29 AM
1,706
David-Engel on Mar 11 2022 09:00 AM
1,187
BobDorr on Mar 03 2022 07:46 AM
866
BobDorr on Mar 01 2022 09:31 AM
685
BobDorr on Mar 01 2022 09:29 AM
702
BobDorr on Mar 01 2022 09:28 AM
673
BobDorr on Mar 01 2022 09:27 AM
604
BobDorr on Mar 01 2022 09:26 AM
514
BobDorr on Mar 01 2022 09:25 AM
536
BobDorr on Mar 01 2022 09:24 AM
551
BobDorr on Mar 01 2022 09:21 AM
600
BobDorr on Mar 01 2022 09:20 AM
575
BobDorr on Mar 01 2022 09:19 AM
545
BobDorr on Mar 01 2022 09:18 AM
511
BobDorr on Mar 01 2022 09:16 AM
550
BobDorr on Mar 01 2022 09:14 AM
533
BobDorr on Mar 01 2022 09:12 AM
777
BobDorr on Feb 28 2022 07:29 AM
669
BobDorr on Feb 28 2022 07:27 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
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE