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
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
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. Nice for building queries for tree structures.
Source: SQL Server Hierarchical Query using the hierarchyid Type – CodeProject
“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
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
– 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
#asp #dotnet #security
You must be logged in to post a comment.