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.
2020 Awards
2019 Awards
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)
Data Types
- SQL Server Bit Data Type (last update: 6/29/2020)
Database Administration
- Capture SQL Server Connectivity Errors in the ERRORLOG (last update: 2/18/2021)
- Move SQL Server Tables to Different Filegroups (last update: 12/17/2018)
- Remove Unnecessary SQL Server Transaction Log Files (last update: 11/18/2015)
- SQL Server Move Database Files Step By Step (last update: 1/12/2021)
- 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)
- SQL Server Management Studio Database Diagram Support Objects Cannot be Installed (last update: 12/2/2020)
Debugging
- Some Tricky Situations When Working with SQL Server NULLs (last update: 11/10/2015)
- Using SQL Server Profiler to Capture Stored Procedures Executions (last update: 6/11/2020)
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)
Extended Events
- Capture Executions of Stored Procedures in SQL Server (last update: 9/16/2020)
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 Plan Reorganize Index and Update Statistics Tasks (last update: 12/20/2019)
- SQL Server Maintenance Plans Rebuild Index Task (last update: 12/13/2019)
Install and Uninstall
- Error Installing .NET 3.5 for SQL Server (last update: 11/2/2020)
- Install SQL Server from Configuration File with Installation Center (last update: 5/12/2020)
Integration Services Development
- Install SQL Server Integration Services in Visual Studio 2019 (last update: 7/9/2020)
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)
- Monitor Deadlocks in SQL Server with system_health Extended Events (last update: 5/27/2020)
- SQL Server UPDATE lock and UPDLOCK Table Hints (last update: 1/28/2020)
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)
- SQL Server Maintenance Plan Execute T-SQL and SQL Server Agent Job Tasks (last update: 12/27/2019)
- SQL Server Maintenance Plan Shrink Database Task (last update: 1/10/2020)
- SQL Server Maintenance Plans History Cleanup Task (last update: 2/18/2020)
- SQL Server Maintenance Plans Maintenance Cleanup Task (last update: 3/2/2020)
- Transfer SQL Server Maintenance Plans Between Servers (last update: 4/20/2020)
Professional Development Interview Questions Developer
- SQL Server Interview Questions for Developers on Querying (last update: 8/7/2020)
Restore
- Solve Common SQL Server Restore Issues (last update: 12/4/2015)
SQL Server Configurations
- How to Check SQL Server Version When Service is Not Running (last update: 12/17/2020)
- 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: 2/8/2021)
- SQL Server Database Diagram Index was Outside the Bounds of the Array (last update: 3/13/2020)
- SQL Server Management Studio Connection to Integration Services Error Class Not Registered (last update: 7/22/2020)
- 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)
- SQL Server Single User Mode Connection with SQL Server Management Studio (last update: 9/2/2020)
System Databases
- Five facts about the SQL Server Model Database (last update: 3/18/2021)
- Five Facts about the SQL Server Resource Database (last update: 4/6/2021)
- Five facts about the SQL Server Tempdb Database (last update: 3/2/2021)
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)
- 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)
- READ_COMMITTED_SNAPSHOT and SNAPSHOT_ISOLATION levels in SQL Server (last update: 8/21/2020)
- SQL Server CASE Statement Example (last update: 2/11/2020)
- SQL Server Global Temporary Table Visibility (last update: 9/22/2015)
- SQL Server LIKE Syntax with Wildcard Characters (last update: 2/2/2021)
- SQL Statements Where Semicolon is Required (last update: 10/13/2020)
- 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 SQL Server with Examples for Snapshot Isolation Level (last update: 2/4/2021)
- 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)
- SQL Server READ_COMMITTED_SNAPSHOT Database Option and READ COMMITED Transaction Isolation Level (last update: 4/1/2020)
- Understanding SQL Server Transaction Savepoints (last update: 6/14/2018)
