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.

Using Cell-Level Encryption in SQL Server

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...

2012-07-19

15,589 reads

Encrypting Connections to SQL Server

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...

2012-07-16

5,663 reads

Introducing Windows Server 2012 – Get the FREE eBook!

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...

2012-07-14

2,261 reads

View SQL Server information using Transact-SQL script

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Recently one of our clients requested information about their SQL Server infrastructure which we manage. In order to complete this...

2012-07-13 (first published: 2012-07-04)

9,053 reads

Retrieving password policy settings for SQL login accounts

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...

2012-07-10

3,411 reads

Purging MSDB Backup and Restore History Tables

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...

2012-07-09

2,426 reads

Securing Database Contents with Transparent Data Encryption (TDE)

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...

2012-07-08

7,761 reads

Find the size of Index in SQL Server

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

As we know, sp_spaceused gives the size of table and index but it gives the sum of size of all...

2012-07-06

7,307 reads

Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...

2012-07-03

5,406 reads

Determine space used for each table in a SQL Server database

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...

2012-07-01

4,417 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers