Object storage integration SQL Server 2022 (16.x) introduces new object storage integration to the data platform, enabling you to integrate SQL Server with S3-compatible object storage, in addition to Azure Storage. The first is backup to URL and the second is Data Lake Virtualization.Data Lake...
This behavior is on by default in all databases (including tempdb) starting with SQL Server 2019 (15.x). Scheduler worker migration Worker migration allows an idle scheduler to migrate a worker from the runnable queue of another scheduler on the same NUMA node and immediately resume the task ...
Support for SQL Server 2017 (14.x) on Windows and Linux is in public preview and shouldn't be used for production migrations. SSMA v7.5 The v7.5 release of SSMA for MySQL has been enhanced with several improvements to ensure greater accessibility for people with disabilities. SSMA v7.4 The...
Add basic support for hierarchyid type in SQL Server. SSMA v8.2 The v8.2 release of SSMA for Access is enhanced with targeted fixes that are designed to improve quality and conversion metrics. Note A known issue with auto-update may cause the failure of an update from SSMA v8.1 to v8.2....
SQL Server 2016 is making a lot of enhancements to In-Memory OLTP to make it easier to use and perform even better. In a previous post I listed all the new features that had been included in SQL Server 2016 up to and including CTP3. But we have added a ...
for a 6-byte sized row, you may not want to use a 16-bit GUID as an identifier. As GUID is quite large in terms of its size, its recommended to consider evaluating other data types and use a GUID for selective scenarios where other data types like int, long and others cannot serve...
An important aspect of FOR XML in SQL Server 2005 is the backwards-compatibility with FOR XML in SQL Server 2000. The backwards-compatibility aspects can be split into the following categories: bug fixes, compatibility mode changes, and preserving FOR XML behavior....
SQL Server Native Client has been removed in SQL Server 2022 (16.x). SQL Server Native Client is a data access technology that was introduced in SQL Server 2005 (9.x). It combines the SQLOLEDB Provider and the SQLODBC Driver into one native dynamic link library (DLL), while also provid...
Wrong. (Sorry to be so blunt, but wrong is wrong.) As it turns out, we don't need to haul out bubble sort code; all we need to do is call the arraylist's Sort method: DataList.Sort() That's it. With that one single line of code we can sort all the items in our array li...
int, bigint, smallint, and tinyint data types store integer data of varying ranges. These data types are ideal for storing whole numbers where precision is crucial. Apart from storing exact values, the data types are suitable for performing precise and safe calculations, fastest integer calculati...