Ahmad Yaseen

Ahmad Yaseen
Ahmad Yaseen is a SQL Server DBA with a bachelor’s degree in computer engineering as well as .NET development experience.

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

2015 Awards   MSSQLTips award

Category Tip Title
Auditing and Compliance Automate the Import of SQL Server Audit Files into SQL Server Using PowerShell
Availability Groups SQL Server AlwaysOn Availability Group Endpoint Encryption Algorithm Compatibility Error
Backup Backup Compression for SQL Server TDE Enabled Databases
Backup SQL Server error BACKUP detected corruption in the database log
Change Data Capture Understanding how DML and DDL changes impact Change Data Capture in SQL Server
Database Administration Identify Unused SQL Server Tables
Database Configurations Expand All Database Files Simultaneously Using SQL Server 2016 AUTOGROW_ALL_FILES
Database Console Commands DBCCs Faster DBCC CHECKDB with SQL Server 2016
Database Console Commands DBCCs SQL Server 2016 DBCC CHECKDB with MAXDOP
Database Mirroring Move Database Files for a SQL Server Mirrored Database Without Impacting Database Mirroring
Dynamic Management Views and Functions Retrieve Actively Running T-SQL Statements from SQL Server
Express Edition Automate SQL Server Express Backups and Purge Old Backups
Functions System Additional SERVERPROPERTY properties in SQL Server
Functions System SQL Server 2016 STRING_SPLIT Function
Functions User Defined UDF Computed Columns with Scalar Functions SQL Server Performance Issue
Identities Monitor SQL Server IDENTITY Column Values to Prevent Arithmetic Overflow Errors
Identities SQL Server IDENTITY System Function Comparison
In Memory OLTP Foreign Key Support in SQL Server 2016 Memory Optimized Tables
Indexing How to Overcome the SQL Server Filtered Index UnMatchedIndexes Issue
Indexing SQL Server 2016 ColumnStore Index String Predicate Pushdown
Indexing SQL Server 2016 Increased Non-Clustered Index Key Size
Locking and Blocking How to Kill a Blocking Negative SPID in SQL Server
Maintenance Resolve SQL Server Database Index Reorganization Page Level Locking Problem
Partitioning SQL Server 2016 Truncate Table with Partitions
Performance Tuning Clone a SQL Server Database Using DBCC CLONEDATABASE
Performance Tuning Finding what SQL Server Trace Flags were enabled for a query
Performance Tuning Get Detailed Wait Stats with SQL Server Execution Plan
Performance Tuning How to Force a Parallel Execution Plan in SQL Server 2016
Performance Tuning Improve SQL Server Table Variable Performance Using Trace Flag 2453
Performance Tuning SQL Server Performance Comparison of TOP vs ROW_NUMBER
Query Optimization Parallelism in SQL Server Execution Plan
Query Optimization SQL Server 2014 Incremental Update Statistics Per Partition
Restore Make Network Path Visible For SQL Server Backup and Restore in SSMS
Scripts Fix SQL Server CTE Maximum Recursion Exhausted Error
Security Default Schema for Windows Group in SQL Server
Security Grant User Access to All SQL Server Databases
Security SQL Server errors with drop login and drop user
SQL Server 2016 Auto Update Statistics Enhancement in SQL Server 2016
SQL Server 2016 SQL Server 2016 Exec Query Stats DMV Enhancements
SQL Server 2016 SQL Server 2016 Online ALTER COLUMN Operation
SQL Server 2016 SQL Server 2016 Sort Order Batch Processing Mode
SQL Server Configurations Troubleshooting Distributed Transaction Performance Problems in SQL Server
SQL Server Management Studio Line Split Issues when Copying Data from SQL Server to Excel
SQL Server Management Studio Configuration Manage SQL Server Management Studio Connect to Server Name Drop Down List
TSQL CREATE OR ALTER statement in SQL Server
TSQL Performance Improvement for SQL Server SELECT... INTO T-SQL Statement
No Records Found
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (31)
Analysis Services Analysis Services Development (94)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (147)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (199)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (41)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (85)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (41)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (77)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (72)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (73)
Database Development Query Optimization (14)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (366)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (148)
Power Platform Power BI Charts (52)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (50)
Professional Development Professional Development Community (16)
Professional Development Professional Development Conferences (2)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (18)
Professional Development Professional Development Management (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (196)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms