Basit Farooq

I'm a Lead Database Administrator, Trainer and Technical Author. I've more than a decade of IT experience in development, technical training, and database administration on Microsoft SQL Server platforms. I've authored numerous SQL Server technical articles and developed and implemented many successful database infrastructure, data warehouse and BI projects. I hold 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.

Error Logs

Consolidating Error Logs from multiple SQL Servers using SSIS (last update: 4/9/2013)

Integration Services Development

SQL Server Integration Services package to delete files from a Network or Local path based on date (last update: 6/13/2013)

Locking and Blocking

Identify the cause of SQL Server blocking (last update: 4/18/2013)

Monitoring

Different techniques to identify blocking in SQL Server (last update: 7/27/2012)

Restore

How to migrate a SQL Server database to a lower version (last update: 8/5/2019)

Service Broker

SQL Server Service Broker error database cannot be enabled (last update: 10/24/2012)

SQL Server Agent

Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise (last update: 6/6/2013)