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.

Rebuild indexes based on fragmentation – sp_RebuildIndex

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...

2012-06-30

5,335 reads

Using SQL Server 2012 FileTables

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...

2012-06-24

13,740 reads

SQL Server 2012 Installation Guide

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...

2012-06-23

215,025 reads

Determine Index Fragmentation in a SQL Server Database

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...

2012-06-18

9,132 reads

Storage options available in Windows for SQL Server

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...

2012-06-16

2,459 reads

Find unused indexes using sys.dm_db_index_usage_stats

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...

2012-06-15

9,968 reads

SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...

2012-06-06

24,984 reads

Unable to recycle SQL Agent log: SQLServerAgent Error: 32.

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...

2012-06-06

2,545 reads

Tips to avoid deadlocks?

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

A database server should be able to service requests from a large number of concurrent users. When a database server...

2012-06-04

3,344 reads

SQL Server 2008 Security Best Practices

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...

2012-06-01

13,300 reads

Blogs

Query multiple Azure SQL Databases

By hellosqlkitty

I was sick of changing context in Azure Data Studio while cleaning up things...

KDA: Echoes of Deception - Case 3

The crime spree in Digitown is not ending. This time 20 cars have been...

The Book of Redgate: Do Your Best Work

One of our mission statements in the Book of Redgate says: attempt to do...

Read the latest Blogs

Forums

Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere

Comments posted to this topic are about the item Shining a Light on Shadow...

CAST(VARCHAR(n)) resolved performance issue?

By mikael_ljunghorn

Hi, I would love to hear if anyone can tell me why a CAST...

isnull, coalesce overhead

hi, one of our sister division's erp extract view is going thru at least...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers