Best of InfoWorldDecember 2023

  1. 1
    Article
    Avatar of infoworldInfoWorld·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.

  2. 2
    Article
    Avatar of infoworldInfoWorld·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.

  3. 3
    Article
    Avatar of infoworldInfoWorld·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.

  4. 4
    Article
    Avatar of infoworldInfoWorld·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.

  5. 5
    Article
    Avatar of infoworldInfoWorld·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.