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

Flyway Tips: AI Deployment Script Descriptions

By

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

A New Word: Fawtle

By

fawtle – n. a weird little flaw built into your partner that somehow only...

Post-quantum key exchange – Insurance policy for your packets

By

AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...

Read the latest Blogs

Forums

Where Your Value Separates You from Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Where Your Value Separates You...

Fixing the Error

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing the Error

T-SQL in SQL Server 2025: Encoding Functions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Fixing the Error

On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code: 

SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error?

See possible answers