Database Power Tools for VS Code | ApexSQL

Search, create and modify MySQL and MariaDB objects in Visual Studio Code with this free extension.

More details here: https://blog.apexsql.com/apexsql-database-power-tools-for-vs-code-2020-product-update-alert/

Product page: Database Power Tools for VS Code | ApexSQL

Real Time HTML Page Content Update with Blazor and SqlTableDependency

How to update an HTML page when a SQL Server table change occurs, without the need to reload the page or make asynchronous calls from the client to the server.

Source: Real Time HTML Page Content Update with Blazor and SqlTableDependency – CodeProject

SQL 2019 – New Features – CodeProject

New features of SQL 2019

Source: SQL 2019 – New Features – CodeProject

Mssql extension adds Object Explorer and IntelliCode to VS Code

Pretty neat stuff, although the SQL command line still is a bit “raw”. Going to explore how this combines with git versioning, because proper VCS for SQL is important!

The mssql extension for Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and adds a rich editing experience for T-SQL in Visual Studio Code.

Source: Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode – SQL Server Blog

SQL Server Hierarchical Query using the hierarchyid Type – CodeProject

SQL Server Hierarchical Query using the hierarchyid type. Nice for building queries for tree structures.

Source: SQL Server Hierarchical Query using the hierarchyid Type – CodeProject

Create Your Own SQL Server Management Studio 17 (SSMS) Extension – CodeProject

A short tutorial on how to get started with creating SSMS extensions

Source: Create Your Own SQL Server Management Studio 17 (SSMS) Extension – CodeProject

The Cause of Every Deadlock in SQL

“Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.”

Source: Geek Speak: The Cause of Every Deadlock in SQL … | THWACK

Native UTF-8 Support in SQL Server 2019: Savior or False Prophet? – Sql Quantum Leap

An in-depth analysis of the new native UTF-8 support in SQL Server 2019.

Source: Native UTF-8 Support in SQL Server 2019: Savior or False Prophet? – Sql Quantum Leap

CRUD Operations in Python with SQL Database – CodeProject

This practical demonstration will help you to understand how to implement CRUD (CREATE, READ, UPDATE and DELETE) operations functionality in Python with SQL database.

Source: CRUD Operations in Python with SQL Database – CodeProject

Ten points to secure your ASP.NET Core MVC applications

Ten points to secure your ASP.NET Core MVC applications
– Broken authentication and session management
– Sensitive Data Exposure & Audit trail
– Cross-Site Scripting (XSS) attacks
– Malicious File Upload
– Security Misconfiguration (Error Handling Must Setup Custom Error Page)
– Version Discloser
– Cross-Site Request Forgery (CSRF)
– XML External Entities (XXE)
– Insecure Deserialization
– SQL Injection Attack

https://www.codeproject.com/Articles/1259066/10-Points-to-Secure-Your-ASP-NET-Core-MVC-Applic-2

#asp #dotnet #security

https://www.codeproject.com/Articles/1259066/10-Points-to-Secure-Your-ASP-NET-Core-MVC-Applic-2