cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
726

Hotfix: JDBC Driver 10.2.1 for SQL Server Released

David-Engel on May 13 2022 10:47 AM
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.1. The update addresses a few issue...
756

Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed

BobDorr on Apr 25 2022 07:14 AM
WKT vs Static Geography Function Parameter Positioning Is Reversed
936

Early technical preview of JDBC Driver 11.1.1 for SQL Server released

David-Engel on Apr 22 2022 10:34 AM
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and ch...
1,371

How It Works: Temporary Objects - User Transaction Scope

BobDorr on Apr 20 2022 08:15 AM
This post discusses physical metadata storage as it relates to performance.
1,895

Cumulative Update #16 for SQL Server 2019 RTM

SrinivasSQL on Apr 19 2022 08:27 AM
The 16th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
1,567

Released: Microsoft.Data.SqlClient 5.0 Preview 2

David-Engel on Apr 13 2022 11:17 AM
Microsoft.Data.SqlClient 5.0 Preview 2 has been released. This release contains improvements and updates to the Microsof...
3,574

SQL Server 2022 Early Adoption Program Update - Applications Now Closed

Kendal Van Dyke on Apr 11 2022 12:30 PM
With the Public Preview of SQL Server 2022 coming by the end of the first half of calendar year 2022, applications to jo...
830

Early technical preview of JDBC Driver 11.1.0 for SQL Server released

David-Engel on Apr 06 2022 09:50 AM
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and ch...
1,879

Announcing general availability of the Ebdsv5 series Azure VMs!

Pam Lahoud on Apr 05 2022 10:41 AM
It's here!!! Happy #DoubleSprinklesVMs Day! Today we are thrilled to announce the general availability of the new Ebdsv5...
1,525

Cumulative Update #29 for SQL Server 2017 RTM

HristinaSQL on Mar 31 2022 11:18 AM
The 29th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...
5,109

GA: SQL best practices assessment for SQL Server on Azure VMs

EbruErsan on Mar 14 2022 07:29 AM
Wouldn't it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? ...
1,706

Released: Microsoft.Data.SqlClient 5.0 Preview 1

David-Engel on Mar 11 2022 09:00 AM
Microsoft.Data.SqlClient 5.0 Preview 1 has been released. This release contains improvements and updates to the Microsof...
1,187

Capture a Call Stack Without Generating A Dump

BobDorr on Mar 03 2022 07:46 AM
Capture a Call Stack Without Generating A Dump
866

SQL 2016 – It Just Runs Faster: XEvent Linq Reader

BobDorr on Mar 01 2022 09:31 AM
SQL 2016 – It Just Runs Faster: XEvent Linq Reader
685

SQL 2016 – Leverages On Demand MSDTC Startup

BobDorr on Mar 01 2022 09:29 AM
SQL 2016 – Leverages On Demand MSDTC Startup
702

SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool

BobDorr on Mar 01 2022 09:28 AM
SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool
673

SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption

BobDorr on Mar 01 2022 09:27 AM
SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption
604

SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms

BobDorr on Mar 01 2022 09:26 AM
SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms
514

SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches

BobDorr on Mar 01 2022 09:25 AM
SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches
536

SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)

BobDorr on Mar 01 2022 09:24 AM
SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)
551

SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)

BobDorr on Mar 01 2022 09:21 AM
SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)
600

SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers

BobDorr on Mar 01 2022 09:20 AM
SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers
575

SQL 2016 – It Just Runs Faster: Larger Data File Writes

BobDorr on Mar 01 2022 09:19 AM
SQL 2016 – It Just Runs Faster: Larger Data File Writes
545

SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default

BobDorr on Mar 01 2022 09:18 AM
SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default
511

SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign

BobDorr on Mar 01 2022 09:16 AM
SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign
550

SQL 2016 – It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning

BobDorr on Mar 01 2022 09:14 AM
SQL 2016 – It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
533

SQL 2016 – It Just Runs Faster: Automatic Soft NUMA

BobDorr on Mar 01 2022 09:12 AM
SQL 2016 – It Just Runs Faster: Automatic Soft NUMA
777

SQL 2016 – It Just Runs Faster: Instant File Initialization

BobDorr on Feb 28 2022 07:29 AM
SQL 2016 – It Just Runs Faster: Instant File Initialization
669

SQL 2016 – It Just Runs Faster: LDF Stamped

BobDorr on Feb 28 2022 07:27 AM
SQL 2016 – It Just Runs Faster: LDF Stamped

Latest Comments

Dhaval_Mehta
in Configure MSDTC to run Distributed transactions for SQL Server Linux Containers on Azure Kubernetes on May 10 2022 01:03 AM
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
amvin87
in Configure MSDTC to run Distributed transactions for SQL Server Linux Containers on Azure Kubernetes on May 10 2022 12:53 AM
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
KevinMartinTech
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
Dhaval_Mehta
in Configure MSDTC to run Distributed transactions for SQL Server Linux Containers on Azure Kubernetes on Apr 25 2022 08:43 AM
@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
chheyangvey
in Configure SQL Server AG (Read-Scale) for SQL Containers deployed on Kubernetes using Helm on Apr 20 2022 01:59 AM
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