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