Ahmad Yaseen
Ahmad has a bachelor's degree in computer engineering from the University Of Jordan and five years of experience working as a SQL DBA, gaining valuable knowledge of database structures, practices, principles and theories. His experience also includes.NET development, working with database applications, scripting and creating SQL queries and views.
His personal abilities include having very strong communication and interpersonal skills, the ability to prioritize and to make good sound decisions that benefit the company.
He has experience in upgrading, configuring, securing, tuning and monitoring SQL Servers since SQL Server 2005. This includes SQL Server performance tuning, SQL Server resource governor management, SQL Server maintenance plans, SQL Server data collection (Reports) analyzing and SQL databases design, developing, indexing and query optimization. In addition, he is familiar with installing and configuring SSRS, SSIS and SSAS. When it comes to disaster recovery and high availability, he has a solid foundation in SQL backup and recovery scenarios, mirroring, replication, log shipping, SQL clustering and AlwaysOn technology.
He has taken many courses on Microsoft SQL Server, including Designing Database Solutions for Microsoft SQL Server 2012, SQL Server 2012: AlwaysOn High Availability and Disaster Recovery Solutions, Developing Microsoft SQL 2012 Databases and SQL Server 2008 Administration. He can be contacted at [email protected], via LinkedIn at Eng.AhmadYaseen or Twitter at https://twitter.com/AhmadZYaseen.
2017 Awards
2016 Awards
2015 Awards
2017 Awards
2016 Awards
2015 Awards
Auditing and Compliance
- Automate the Import of SQL Server Audit Files into SQL Server Using PowerShell (last update: 2/2/2015)
Availability Groups
- SQL Server AlwaysOn Availability Group Endpoint Encryption Algorithm Compatibility Error (last update: 5/20/2016)
Backup
- Backup Compression for SQL Server TDE Enabled Databases (last update: 11/16/2016)
- SQL Server error BACKUP detected corruption in the database log (last update: 11/17/2015)
Change Data Capture
- Understanding how DML and DDL changes impact Change Data Capture in SQL Server (last update: 12/22/2015)
Database Administration
- Identify Unused SQL Server Tables (last update: 3/2/2016)
Database Configurations
- Expand All Database Files Simultaneously Using SQL Server 2016 AUTOGROW_ALL_FILES (last update: 6/19/2017)
Database Console Commands DBCCs
- Faster DBCC CHECKDB with SQL Server 2016 (last update: 9/8/2016)
- SQL Server 2016 DBCC CHECKDB with MAXDOP (last update: 10/11/2016)
Database Mirroring
- Move Database Files for a SQL Server Mirrored Database Without Impacting Database Mirroring (last update: 1/8/2015)
Dynamic Management Views and Functions
- Retrieve Actively Running T-SQL Statements from SQL Server (last update: 10/17/2017)
Express Edition
- Automate SQL Server Express Backups and Purge Old Backups (last update: 2/9/2015)
Functions - System
- Additional SERVERPROPERTY properties in SQL Server (last update: 8/16/2017)
- SQL Server 2016 STRING_SPLIT Function (last update: 5/17/2017)
Functions - User Defined UDF
- Computed Columns with Scalar Functions SQL Server Performance Issue (last update: 4/27/2018)
Identities
- Monitor SQL Server IDENTITY Column Values to Prevent Arithmetic Overflow Errors (last update: 7/29/2016)
- SQL Server IDENTITY System Function Comparison (last update: 9/18/2017)
Import and Export
- Performance Improvement for SQL Server SELECT... INTO T-SQL Statement (last update: 1/27/2017)
In-Memory OLTP
- Foreign Key Support in SQL Server 2016 Memory Optimized Tables (last update: 3/30/2017)
Indexing
- How to Overcome the SQL Server Filtered Index UnMatchedIndexes Issue (last update: 9/26/2017)
- SQL Server 2016 ColumnStore Index String Predicate Pushdown (last update: 7/20/2017)
- SQL Server 2016 Increased Non-Clustered Index Key Size (last update: 8/3/2017)
Locking and Blocking
- How to Kill a Blocking Negative SPID in SQL Server (last update: 1/18/2016)
Maintenance
- Resolve SQL Server Database Index Reorganization Page Level Locking Problem (last update: 4/14/2016)
Partitioning
- SQL Server 2016 Truncate Table with Partitions (last update: 8/30/2016)
Performance Tuning
- Clone a SQL Server Database Using DBCC CLONEDATABASE (last update: 8/11/2016)
- Finding what SQL Server Trace Flags were enabled for a query (last update: 1/11/2017)
- Get Detailed Wait Stats with SQL Server Execution Plan (last update: 10/5/2017)
- How to Force a Parallel Execution Plan in SQL Server 2016 (last update: 7/12/2017)
- Improve SQL Server Table Variable Performance Using Trace Flag 2453 (last update: 3/9/2017)
- SQL Server Performance Comparison of TOP vs ROW_NUMBER (last update: 6/29/2017)
Query Optimization
- Parallelism in SQL Server Execution Plan (last update: 3/30/2018)
- SQL Server 2014 Incremental Update Statistics Per Partition (last update: 5/5/2017)
Restore
- Make Network Path Visible For SQL Server Backup and Restore in SSMS (last update: 3/3/2015)
Scripts
- Fix SQL Server CTE Maximum Recursion Exhausted Error (last update: 10/13/2017)
Security
- Default Schema for Windows Group in SQL Server (last update: 10/19/2015)
- Grant User Access to All SQL Server Databases (last update: 6/25/2015)
- SQL Server errors with drop login and drop user (last update: 6/10/2016)
SQL Server 2016
- Auto Update Statistics Enhancement in SQL Server 2016 (last update: 9/22/2016)
- New CREATE OR ALTER statement in SQL Server 2016 SP1 (last update: 1/23/2017)
- SQL Server 2016 Exec Query Stats DMV Enhancements (last update: 10/26/2016)
- SQL Server 2016 Online ALTER COLUMN Operation (last update: 3/14/2017)
- SQL Server 2016 Sort Order Batch Processing Mode (last update: 12/7/2016)
SQL Server Configurations
- Troubleshooting Distributed Transaction Performance Problems in SQL Server (last update: 7/15/2016)
SQL Server Management Studio
- Line Split Issues when Copying Data from SQL Server to Excel (last update: 1/1/2015)
- Manage SQL Server Management Studio Connect to Server Name Drop Down List (last update: 6/1/2016)
