Sergey Gigoyan

Sergey Gigoyan (LinkedIn) is a Senior Technical Architect specializing in data and databases with more than 15 years of experience.  Sergey focuses on modern data architectures, database design and development, performance tuning and optimization, high availability solutions, BI development and DW design. He has worked with SQL Server, Oracle, and PostgreSQL databases, as well as cloud-based data solutions (AWS and Azure).  Sergey also has extensive experience with modern data stacks such as Snowflake and dbt. Sergey's experience spans various industries.  He had the privilege of working with IT giants such as Oracle as a Principal Data Engineer and BlackBerry as well as innovative startups.  He helped deliver complex database solutions and advanced data strategies. Sergey is also the author of “Building a Successful Career in IT - How I Did It” where he provides actionable advice on thriving in the ever-evolving IT industry.
  • MSSQLTips Awards: Champion (100+ tips) - 2024 | Author of the Year - 2020
Title Category Date
SQL Server Management Studio Connection to Integration Services Error Class Not Registered SQL Server Management Studio2026-05-20
SnowPro Advanced Architect Certification Exam Cram Snowflake2026-05-13
Snowflake SnowPro Advanced Architect Certification Preparation Snowflake2026-04-22
SQL Server UPDATE lock and UPDLOCK Table Hints Locking and Blocking2025-06-19
SQL Server Move Database Files Step By Step Database Administration2025-01-13
How to Install SSIS in Visual Studio 2019 Integration Services Development2025-01-02
SQL Server READ_COMMITTED_SNAPSHOT and READ COMMITTED Options Transactions2024-12-30
SQL Index Rebuild vs Reorganize Comparison Indexing2024-09-04
Compare SQL Server XACT_STATE vs @@TRANCOUNT Functions Transactions2024-08-14
Comparing SQL Server and Oracle Backup Types SQL Server and Oracle Comparison2024-07-24
Snowflake Resource Monitors to Track Resource Usage Snowflake2024-03-15
Simple Examples to Mask Sensitive Data in Snowflake Snowflake2024-02-21
Dynamic Data Masking in SQL Server for Sensitive Data Protection Security2024-01-08
Compare Snowflake vs SQL Server GREATEST and LEAST Functions Snowflake2023-10-11
Snowflake SELECT Statement Unique Features Snowflake2023-09-28
Snowflake Scoped Transactions Behavior and Examples Snowflake2023-08-09
Snowflake Transactions in Stored Procedures Snowflake2023-07-28
Replace OUTER APPLY and CROSS APPLY with LEFT JOINs for Snowflake Snowflake2023-07-21
Compare Data Warehouse Concepts in Snowflake versus SQL Server Data Warehousing2023-04-28
Learn How Snowflake Creates and Detects Deadlocks for Data Integrity Snowflake2023-04-26
Transactions in Snowflake Stored Procedures with Code Examples Snowflake2023-04-06
Compare Snowflake Temporary and Transient Tables with SQL Temp Tables Snowflake2023-03-16
Learn about Snowflake Temporary Tables vs. Snowflake Transient Tables Snowflake2023-03-01
Snowflake NULL Functions – NVL2, ZEROIFNULL, EQUAL_NULL, IS_NULL_VALUE Snowflake2023-02-23
SQL Server and Snowflake NULL Functions – ISNULL, COALESCE, NULLIF Snowflake2023-02-09
Create Transactions in Snowflake Plus Useful Commands for SQL Devs Snowflake2022-12-28
SQL Server PARSEONLY and NOEXEC to Check Query Syntax TSQL2022-12-16
Snowflake Constraints Primary Key, Unique Key, Foreign Key, Not Null Snowflake2022-12-07
SQL Deadlock Priority to Control Transaction Roll Backs Locking and Blocking2022-11-30
DDL and DML Statements in transactions for SQL Server and Snowflake Snowflake2022-10-26
Snowflake Transactions vs SQL Server Transactions Snowflake2022-05-23
Find MAX value from multiple columns in a SQL Server table TSQL2021-12-08
How to Recover Tempdb in SQL Server System Databases2021-10-26
SQL SELECT INTO Advanced Topics TSQL2021-10-06
SQL SELECT INTO to a Create a Table TSQL2021-09-22
Configure Database Mirroring with T-SQL Code Database Mirroring2021-09-13
Issues with SQL Server Permissions to Restore a Database Restore2021-08-02
Find and Remove Duplicate Rows from a SQL Server Table Database Design2021-07-20
Rebuild System Databases in SQL Server System Databases2021-07-08
SQL Server Configuration Manager Error The Parameter is Invalid SQL Server Configurations2021-06-11
SQL Server Move Database Files for Master System Databases2021-06-02
Move SQL Server System Database Files System Databases2021-05-10
SQL Server Master Database Facts System Databases2021-05-04
SQL Server MSDB Database Facts System Databases2021-04-19
Resource Database in SQL Server Facts System Databases2021-04-06
SQL Server Model Database Facts System Databases2021-03-18
Five facts about the SQL Server Tempdb Database System Databases2021-03-02
Capture SQL Server Connectivity Errors in the ERRORLOG Database Administration2021-02-18
How to Install SQL Server Management Studio on your Local Computer SQL Server Management Studio2021-02-08
DDL commands in SQL Server with Examples for Snapshot Isolation Level Transactions2021-02-04
SQL LIKE Wildcard with Underscore and More Examples TSQL2021-02-02
How to Check SQL Server Version When Service is Not Running SQL Server Configurations2020-12-17
SSMS Database Diagram Support Objects Cannot Be Installed Database Design2020-12-02
Error Installing Microsoft .Net Framework 3.5 SQL Server Install and Uninstall2020-11-02
SQL Semicolon Usage Examples TSQL2020-10-13
Capture Executions of Stored Procedures in SQL Server Extended Events2020-09-16
SQL Server Single User Mode Connection with SQL Server Management Studio SQL Server Management Studio2020-09-02
READ_COMMITTED_SNAPSHOT and SNAPSHOT_ISOLATION levels in SQL Server TSQL2020-08-21
SQL Server Interview Questions for Developers on Querying Developer Interview Questions2020-08-07
SQL Server Bit Data Type Data Types2020-06-29
Using SQL Server Profiler to Capture Stored Procedures Executions Debugging2020-06-11
Monitor Deadlocks in SQL Server with system_health Extended Events Locking and Blocking2020-05-27
Install SQL Server from Configuration File with Installation Center Install and Uninstall2020-05-12
Transfer SQL Server Maintenance Plans Between Servers Maintenance2020-04-20
SQL Server Database Diagram Index was Outside the Bounds of the Array SQL Server Management Studio2020-03-13
SQL Server Maintenance Plans Maintenance Cleanup Task Maintenance2020-03-02
SQL Server Maintenance Plans History Cleanup Task Maintenance2020-02-18
SQL Server CASE Statement Example TSQL2020-02-11
SQL Server Maintenance Plan Shrink Database Task Maintenance2020-01-10
SQL Server Maintenance Plan Execute T-SQL and SQL Server Agent Job Tasks Maintenance2019-12-27
SQL Server Maintenance Plan Reorganize Index and Update Statistics Tasks Indexing2019-12-20
SQL Server Maintenance Plans Rebuild Index Task Indexing2019-12-13
Backup Database Task in SQL Server Maintenance Plans Backup2019-12-05
SSIS Access Denied when Connecting in SQL Server 2016 or 2017 Integration Services Security2019-11-27
Create SQL Server Maintenance Plan with Maintenance Plan Designer Maintenance2019-09-30
Getting Started with SQL Server Maintenance Plans – Part 1 Maintenance2019-07-24
SQL Decimal vs Numeric, Timestamp vs Rowversion, Index vs Constraint TSQL2019-07-05
Auditing Failed SQL Server Transactions Using Table Variables Auditing and Compliance2019-06-14
Move SQL Server Tables to Different Filegroups Database Administration2018-12-17
Write More Compact SQL Server Code Using New Features – Part 2 TSQL2018-12-03
Write more compact SQL Server code using new features TSQL2018-11-20
SQL Server transactions in nested stored procedures using Savepoints Transactions2018-06-27
Understanding SQL Server Transaction Savepoints Transactions2018-06-14
Debugging T-SQL Code in SQL Server Management Studio SQL Server Management Studio2017-12-08
SQL Server Management Studio Tips – Generating Scripts SQL Server Management Studio2017-07-18
SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips SQL Server Management Studio Configuration2017-07-11
SQL Server Management Studio Productivity Tips SQL Server Management Studio Configuration2017-07-05
Handling Transactions in Nested SQL Server Stored Procedures TSQL2017-06-08
DDL commands in Transactions in SQL Server versus Oracle Transactions2016-12-09
Synchronizing SQL Server data using rowversion Database Administration2016-11-09
Compare SQL Server NOLOCK and READPAST Table Hints Locking and Blocking2016-09-22
Compare Repeatable Read and Serializable SQL Server Transaction Isolation Levels Locking and Blocking2016-09-01
Difference between SQL Server Unique Indexes and Unique Constraints Indexing2016-06-13
SQL Server Referential Integrity without Foreign Keys Referential Integrity2016-03-31
Setting a fixed amount of memory for SQL Server SQL Server Configurations2016-03-07
Joining SQL Server tables using large character type columns JOIN Tables2016-03-02
Using Global Temporary Staging Tables for SQL Server Data Importing Import and Export2016-02-19
Execute large scripts in SSMS with Insufficient Memory Failures SQL Server Management Studio2016-01-29
Comparison of SQL Server Serializable and Snapshot isolation levels TSQL2015-12-24
SQL Server Backups and Transaction Log Questions Backup2015-12-18
Solve Common SQL Server Restore Issues Restore2015-12-04
Remove Unnecessary SQL Server Transaction Log Files Database Administration2015-11-18
Some Tricky Situations When Working with SQL Server NULLs Debugging2015-11-10
Exploring SQL Server 2014 Table Variables Temp Tables2015-10-16
Storing passwords in a secure way in a SQL Server database Encryption2015-09-29
SQL Server Global Temporary Table Visibility Temp Tables2015-09-22
SQL Server Transaction Count with Mismatching Number BEGIN and COMMIT Error Handling2015-09-14