Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
Renaming Something Without Breaking Everything
Plan a rename database object change with dependency checks, updated callers, permission tests, and a temporary compatibility name when suitable.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Permissions I Have in SQL Server: Check Database, Server and Object Access
The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.
Free Tools Worth Having on a SQL Server
Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.
MySQL – How to Create Stored Procedure
Confused by semicolons when you create stored procedure code in MySQL? Change the DELIMITER first, then reset it. Here is a simple example.







