From the team that brought you Windows Terminal, Windows Subsystem for Linux, PowerToys and Windows Package Manager (WinGet), we are excited to introduce Dev Home, a new open-source experience in Windows created just for developers.  

 SELECT p.name
 ,p.value
 ,t.name AS TableName
 ,c.name AS ColumnName
 ,c.is_nullable
 ,c.max_length
 ,TYPE_NAME(c.system_type_id)
FROM sys.tables t
JOIN sys.columns c
ON t.object_id = c.object_id
LEFT JOIN sys.extended_properties p
ON p.major_id = t.object_id
AND p.minor_id = c.column_id
ORDER BY t.name DESC,c.name DESC

The new .NET framework is modern, lean, modular and open source. No longer is .NET a system-wide installation – it is merely a folder. Instead of a huge underlying framework, you only pick and choose the pieces of the .NET framework that you need in your apps. And more importantly, you can package the required components of the .NET framework right alongside your app. We’re entering an age of app-runtime silos and ultimate portability. 

Top 8 Free, Open Source SQL Clients 

SQL is back. Not just because writing glue code to kludge together NoSQL tools is annoying. Not just because retraining workforces to learn a myriad of new languages is hard. Not just because standards can be a good thing.

But also because the world is filled with data. It surrounds us, binds us. At first, we relied on our human senses and sensory nervous systems to process it. Now our software and hardware systems are also getting smart enough to help us. And as we collect more and more data to make better sense of our world, the complexity of our systems to store, process, analyze, and visualize that data will only continue to grow as well. 

These are the customer-reported issues addressed in 15.7.4:

• Green squiggles and light bulb with "Macro in skipped region" message.
• F7 does not switch to code.
• F7 does not build anymore.
• F7 build does not work.
• LINK : error : Telemetry event upload failed: 'Failed to open connection to VCTIP'.
• AXML file doesn't open after update.
• F7 no longer toggles between the designer and the code.
• XAML Editor Error: Window is not supported in WPF project.
• WinForms View.ToggleDesigner does not work as it used to.
• Toggle designer key binding lost.
• F7 does not start a new build.
• F7 no longer toggles between Designer and Code views.
• There is a problem with structure definition in C language.
• Provisioning a new SQL Server and new SQL DB in a different region than the App Service plan fails.

Git Security Vulnerability

We also fixed a security vulnerability in Git that was disclosed by the Git community. The vulnerability can lead to arbitrary code execution when a user clones a malicious repository. This blog post has more information. 

Squidex is an open source headless CMS and content management hub.
We build it with ASP.NET Core and CQRS and is tested for Windows and Linux on modern browsers. 

The lost art of writing SQL queries
I noticed that most (junior) developers no longer are able to write anything but the most trivial SQL queries.  Time to fix that!