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

Learn Better: Pause to Review More

By

If you want to learn better, pause more in your learning to intentionally review.

Azure SQL Managed Instance Next-Gen: Bring on the IOPS

By

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...

SQL, MDX, DAX – the languages of data

By

Ramblings of a retired data architect Let me start by saying that I have...

Read the latest Blogs

Forums

Two foreign keys to the same table. Can't cascade deletes.

By FunkyDexter

Not sure if this is really a relational theory question but it seems about...

Connecting Power BI to SSAS and effective user not working

By Paul Hernández

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

High Availability setup - has anyone seen this method?

By Paul Lancaster

Hi all, I recently moved to a new employer who have their HA setup...

Visit the forum

Question of the Day

Encoding URLs

I have this data in a SQL Server 2025 table: 

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO
If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers