Sergey Gigoyan
Sergey Gigoyan is a database professional (MCSE: Data Platform, MCITP, OCP) with more than 10 years of experience, with a focus on database design and development, performance tuning and optimization, high availability solutions, BI development and DW design. He has worked with SQL Server 2000/2005/2008/2012/2014, Oracle, PostgreSQL databases. He has designed and developed database and DW systems for banking, trading, financial and sales areas. He is now working at Oracle Armenia as a Principal Database Developer. He is continuously developing his professional skills to keep pace with new technologies.
Check out Sergey's blog.
2017 Awards
2016 Awards
2015 Awards
Auditing and Compliance
- Auditing Failed SQL Server Transactions Using Table Variables (last update: 6/14/2019)
Backup
- Backup Database Task in SQL Server Maintenance Plans (last update: 12/5/2019)
- SQL Server Backups and Transaction Log Questions (last update: 12/18/2015)
Constraints
- SQL Server Referential Integrity without Foreign Keys (last update: 3/31/2016)
Database Administration
- Move SQL Server Tables to Different Filegroups (last update: 12/17/2018)
- Remove Unnecessary SQL Server Transaction Log Files (last update: 11/18/2015)
- Synchronizing SQL Server data using rowversion (last update: 11/9/2016)
Database Design
- Find and Remove Duplicate Rows from a SQL Server Table (last update: 8/16/2019)
Debugging
- Some Tricky Situations When Working with SQL Server NULLs (last update: 11/10/2015)
Encryption
- Storing passwords in a secure way in a SQL Server database (last update: 9/29/2015)
Error Handling
- SQL Server transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements (last update: 9/14/2015)
Import and Export
- Using Global Temporary Staging Tables for SQL Server Data Importing (last update: 2/19/2016)
Indexing
- Difference between SQL Server Unique Indexes and Unique Constraints (last update: 6/13/2016)
- SQL Server Maintenance Plans Rebuild Index Task (last update: 12/13/2019)
Integration Services Security
- Connecting to Integration Services Access is Denied in SQL Server 2016 or 2017 (last update: 11/27/2019)
JOIN Tables
- Joining SQL Server tables using large character type columns (last update: 3/2/2016)
Locking and Blocking
- Compare Repeatable Read and Serializable SQL Server Transaction Isolation Levels (last update: 9/1/2016)
- Compare SQL Server NOLOCK and READPAST Table Hints (last update: 9/22/2016)
Maintenance
- Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer (last update: 9/30/2019)
- Getting Started with SQL Server Maintenance Plans - Part 1 (last update: 7/24/2019)
Restore
- Solve Common SQL Server Restore Issues (last update: 12/4/2015)
SQL Server Configurations
- Setting a fixed amount of memory for SQL Server (last update: 3/7/2016)
SQL Server Management Studio
- Debugging T-SQL Code in SQL Server Management Studio (last update: 12/8/2017)
- Executing large scripts in SQL Server Management Studio with Insufficient Memory Failures (last update: 1/29/2016)
- How to Install SQL Server Management Studio on your Local Computer (last update: 6/29/2017)
- SQL Server Management Studio Productivity Tips (last update: 7/5/2017)
- SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips (last update: 7/11/2017)
- SQL Server Management Studio Tips – Generating Scripts (last update: 7/18/2017)
T-SQL
- Compare SQL Server Features - Decimal vs Numeric, Timestamp vs Rowversion, Unique Index vs Unique Constraint (last update: 7/5/2019)
- Comparison of SQL Server Serializable and Snapshot isolation levels (last update: 12/24/2015)
- Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters (last update: 9/10/2018)
- Exploring SQL Server 2014 Table Variables (last update: 10/16/2015)
- Find MAX value from multiple columns in a SQL Server table (last update: 10/20/2015)
- Handling Transactions in Nested SQL Server Stored Procedures (last update: 6/8/2017)
- SQL Server Global Temporary Table Visibility (last update: 9/22/2015)
- Write more compact SQL Server code using new features (last update: 11/20/2018)
- Write More Compact SQL Server Code Using New Features - Part 2 (last update: 12/3/2018)
Transactions
- DDL commands in Transactions in SQL Server versus Oracle (last update: 12/9/2016)
- Handling SQL Server transactions in nested stored procedures using Savepoints (last update: 6/27/2018)
- Understanding SQL Server Transaction Savepoints (last update: 6/14/2018)
