DKDavid Kaplunovindatabasesexpert.hashnode.dev·Jan 8 · 3 min readdbForge 2025.3: AI Assistant in SQL Complete, Expanded Connectivity, and Smarter SQL WorkflowsDo you ever feel like SQL development is a juggling act? One minute you’re in SQL Server, the next in Oracle or MySQL, trying to track queries, optimize execution plans, and make sense of complex schema logic. Sounds familiar? You’re not alone—and no...00
DKDavid Kaplunovindatabasesexpert.hashnode.dev·Dec 29, 2025 · 1 min readMaking MySQL Data Analysis and Reporting EasierData analysis and reporting are routine tasks for analysts and managers, but they remain complex and time-consuming. The process usually involves selecting relevant data, writing SQL queries, validating results, and presenting insights in a clear, re...00
DKDavid Kaplunovindatabasesexpert.hashnode.dev·Dec 29, 2025 · 1 min readNeed Realistic Test Data Fast? How to Generate Random Numbers in SQL ServerGenerating random numbers and populating SQL tables with sample data is a daily challenge for database developers, QA engineers, and data analysts. When you need realistic datasets for testing, validation, or experimentation, manual data creation qui...00
DKDavid Kaplunovindatabasesexpert.hashnode.dev·Dec 29, 2025 · 1 min readImporting JSON into MySQL Without Extra ComplexityJSON has become a common way to exchange data — from API responses and application logs to exports from third-party services. Eventually, this data often needs to be stored in MySQL to query, analyze, or combine with other relational data. But import...00
DKDavid Kaplunovindatabasesexpert.hashnode.dev·Dec 26, 2025 · 1 min readWhy QUOTENAME() Should Be Your Go-To Function in SQL ServerWorking with dynamic SQL, auto-generated scripts, or object names that include spaces, special characters, or reserved keywords can be tricky. One small mistake and your query fails — or worse, becomes vulnerable. That’s where SQL Server’s QUOTENAME(...00
