Neat example of what is possible with Blazor!
How to develop a Blazor server application dynamically and generate UI from Entity Framework using open-source Platz.SqlForms including master-details data entry
Source: Microsoft Blazor – Rapid Development with SQL Forms Open-source Platz.SqlForms – 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
“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
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
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
SQL Server Brute Force Attack Detection
https://www.codeproject.com/Articles/1231882/SQL-Server-Brute-Force-Attack-Detection-Part-1
ApexSQL has released a new, free tool for analyzing the execution plan of a query on SQL Server.
Static Code Analyzer for T-SQL – MS SQL Server.
Plugs into MS SSMS and can also be run from command line.
It reports useful clues which you can turn/on off to your liking.
http://sqlcodeguard.com/index-database-issues.html
It will spot declared but unused variables, but it appears it doesn’t do code coverage or execution path to spot stuff like variables being used without being initialized.
Price: Free
ADO – Stored Procedure – Generated SQL
Is there a way to intercept and view the generated SQL of a stored procedure call?
We have a strange date off by 2 issue.
Migration from MSSQL to PostgreSQL?
Has anyone of you done this?
There are features that you pay mucho dollars for in MSSQL, which PostgreSQL appears to manage just fine.
You must be logged in to post a comment.