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

Rolling Back a Broken Release

By

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Presenting with Visual Studio Code

By

A while back I wrote a quick post on setting up key mappings in...

Read the latest Blogs

Forums

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Creating JSON III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON III

Testing is Becoming More Important

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Testing is Becoming More Important

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data: 

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin
I run this code: 
SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;
What are the results?

See possible answers