Useful SQL Server 2019 features 1. Memory-optimized TempDB metadata. In SQL Server 2019 Microsoft introduces a new feature that is part of the In-Memory Database feature family. This is memory-optimized TempDB metadata. Now the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. Use the following script to turn on the memory-optimized TempDB...
Tag: linux
Troubleshooting SQL Server 2017 problems on Linux
Troubleshooting SQL Server 2017 problems on Linux Starting from SQL Server 2017, Microsoft supports the Linux operating systems to install SQL Server. If you have problems when you work with SQL Server 2017 on Linux, review this troubleshooting checklist to find potential solutions. 1. You may notice that the daylight saving time (DST) changes are not determined by SQL Server...
Using external tables to invoke Linux utilities and hold the data received
Using External Tables to Invoke Linux Utilities and Hold the Data Received By Yuli Vasiliev You might use external tables to query operating system data. As a preprocessor program to be used in your external table, you might create a shell script calling a Linux utility, such as ls, df, or ps. Moreover, you can pass arguments to the utility...
SSWUG TV – Interview with Josef Richberg, SSWUG.ORG Presenter and Red Gate Software’s Exceptional DBA of 2009.
Pro-Center Video Programming for IT Professionals