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!
“Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.”
An in-depth analysis of the new native UTF-8 support in SQL Server 2019.
This practical demonstration will help you to understand how to implement CRUD (CREATE, READ, UPDATE and DELETE) operations functionality in Python with SQL database.
SQL Server Brute Force Attack Detection
#SQL #Server #security
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.
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.
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.
Calling .NET libs from Delphi?
Basically, I’d like to call sql generators from .NET System.Data.SqlClient, like it is done here:
How much bending over backwards is required to to do this?