Basit Aalishan Masood-Al-Farooq

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

All authors

Detecting and Removing Duplicate Indexes

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...

2012-09-14

1,802 reads

Introduction to Windows Azure SQL Database Services (Part 2)

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...

2012-09-06

1,244 reads

Capture SQL Server Deadlocks using Extended Events

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...

2012-09-03

1,522 reads

SQL Server Guest User – Still a Serious Security Threat

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...

2012-08-31 (first published: 2012-08-28)

5,271 reads

Tips For Minimizing Deadlocks in SQL Server

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...

2012-08-23

2,472 reads

Transparent Data Encryption (TDE) with Database Mirroring

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...

2012-08-23

1,738 reads