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

Why your data still can’t answer a simple question 

By

Every organization I talk to has the same problem dressed up in different clothes....

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

By

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Did You Really Name That Default?

By

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

Comments posted to this topic are about the item The day-to-day pressures of a...

Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)

By BOR15K

Hello all, I’m looking for advice on how to derive a daily snapshot table...

SQL 2017 to SQL 2025. Good to Go ?

By homebrew01

We need to replace our Windows server running SQL 2017. Any reason not to...

Visit the forum

Question of the Day

Using OPENJSON

I have some data in a table that looks like this: 

BeerID BeerName    brewer               beerdescription
1      Becks       Interbrew            Beck's is a German-style pilsner beer 
2      Fat Tire    New Belgium          Toasty malt, gentle sweetness, flash of fresh hop bitterness.
3      Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste
4      Alaskan Amber Alaskan Brewing     Alaskan Brewing Amber Ale is an "alt" style beer
8      Kirin       Kirin Brewing         Kirin Ichiban is a Lager-type beer
If I run this, what is returned? 
select t1.[key]
    from openjson((select t.* FROM Beer AS t for json path)) t1

See possible answers