hamletshahnazaryan

I am an experienced SQL Server administrator and developer with a solid background in T-SQL, C#, ASP.NET, and DevExpress. I specialize in database management, performance optimization, and automating administrative processes to improve system efficiency.

With years of hands-on experience working on large-scale SQL Server databases, I have developed numerous T-SQL scripts and custom utilities aimed at monitoring server performance, automating backups, and enhancing database security. I am dedicated to providing effective solutions to complex database issues.

Currently, I am focused on sharing my expertise by creating and selling useful tools for database administrators and developers. I am always open to learning new techniques and contributing to the SQL Server community.
  • Interests: My professional interests include database optimization, performance tuning, and automation of repetitive administrative tasks. I enjoy solving complex technical problems and finding innovative solutions to improve system efficiency. Outside of work, I have a passion for animation and creative technologies. I am currently learning more about animation techniques, which I hope to apply in both professional and personal projects. I also love playing video games, reading books on technology and innovation, and exploring new tools that can help make work processes more efficient.
  • Skills: SQL Server Administration: Database optimization, backup automation, and security. T-SQL: Advanced queries, stored procedures, performance tuning. C# & .NET: Application development, SQL integration, UI design. ASP.NET & Web Forms: Web application development, data-driven solutions. DevExpress: Building rich UIs, report design, and data visualization. Database Performance Monitoring: DMV usage, performance analysis, bottleneck identification.

All authors

All authors

Blogs

In-Person CISA Training – April 13-16, 2026

By

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

EightKB 2026

By

EightKB is back again for 2026! The biggest online SQL Server internals conference is...

The FinOps Lifecycle: From Budgeting to Reporting

By

Working in DevOps long enough teaches you two universal truths: That’s exactly why I...

Read the latest Blogs

Forums

VS Code, Unresolved References.

By mjdemaris

Hi all, I just started using VS Code to work with DB projects.  I...

Fun with JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fun with JSON II

Changing Data Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Data Types

Visit the forum

Question of the Day

Fun with JSON II

I have some data in a table: 

CREATE TABLE #test_data
(
    id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_date DATE
);

-- Step 2: Insert rows  
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned? 
SELECT t1.[key] AS row,
       t2.*
FROM OPENJSON(
     (
         SELECT t.* FROM #test_data AS t FOR JSON PATH
     )
             ) t1
    CROSS APPLY OPENJSON(t1.value) t2;

See possible answers