Short, practical SQL tips, query patterns, and database tooling insights designed to help developers and DBAs solve real database problems faster.

Latest Posts

• Using Object Filters to Adjust Schema Comparison
• How to Automatically Synchronize Multiple Databases on Different SQL Server Instances
• Find and Delete Incomplete Open Transactions in SQL Server
• How To Generate and Fill a Doubly Linked List Table
• What is faster inside SUM & AVG: 0 or NULL?
• Enabling AUTO_CLOSE Is a Bad Idea?
• Getting Real Currency Exchange Rates with SQL Server Data Generator
• SQL Server Typical Maintenance Plans: Automatic Statistics Update
• What is the fastest way to calculate the record COUNT?
• XML, XQuery & Performance Issues
• Using HTTP Tunneling
• How to Get a List of Permissions of MySQL Users
• Refreshing Objects of SQL Server Databases
• How To: Kill User Sessions in Oracle
• How To: Create a MySQL Database Diagram Using a Sketch Image
• Be careful while using UNSIGNED data type in the routine body
• Data Comparison Methods and Techniques
• 10 Ways to Synchronize Oracle Table Data
• How To: Disable All Foreign Keys in Oracle Schema
• Adding Timestamp to a Filename
• Loading Oracle LOB Data – Code Samples
• How to reduce MSDB size from 42Gb to 200Mb