Best of InfoWorld — December 2023

1. 1
   Article

   InfoWorld·2y

   SQL unleashed: 9 ways to speed up your SQL queries

   Learn 9 best practices for writing faster SQL queries, including retrieving only the columns you need, using CASE instead of UPDATE for conditional column updates, and pre-staging data for improved performance.

   21

   1
2. 2
   Article

   InfoWorld·2y

   The best new features in Microsoft .NET 8

   Microsoft .NET 8 has arrived with a plethora of new features and enhancements. Highlights include improvements in the garbage collector, JSON serialization and deserialization, time abstraction, cryptography, compression, native AOT compilation, code generation, and performance. Additional resources are available for further reading.

   17
3. 3
   Article

   InfoWorld·2y

   How to use IEnumerable, ICollection, IList, and IQueryable in C#

   Learn how to use IEnumerable, ICollection, IList, and IQueryable in C# to work with collections of data efficiently.

   15
4. 4
   Article

   InfoWorld·2y

   Visual Studio Code introduces floating editor windows

   Visual Studio Code 1.85 introduces floating editor windows and the ability to visualize JavaScript heap snapshots. It also includes improvements to the keyboard experience, interactive type hints, auto-update extensions, enhanced navigation for Python projects, and new features for GitHub Copilot and project trees.

   14

   2
5. 5
   Article

   InfoWorld·2y

   SQL unleashed: 7 SQL mistakes to avoid

   Learn about 7 common SQL mistakes to avoid when writing database applications, including blindly reusing queries, nesting views, running large multi-table operations in a single transaction, clustering on volatile columns, inefficiently counting rows, using triggers, and doing negative searches.

   11