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
MSSQLTips award

2016 Awards
MSSQLTips award

2015 Awards
MSSQLTips award

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)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Ahmad Yaseen

More SQL Server Solutions