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,628 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,665 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,264 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,058 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,421 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,435 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,762 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,335 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,409 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,420 reads

Blogs

Git forked

By Randolph West

Forgive me for the title. Mentally I’m 12. When I started my current day...

Setting FK Constraints in Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how...

Webinar: Navigating the Database Landscape in 2026

For a number of years, we’ve produced the State of the Database Landscape report,...

Read the latest Blogs

Forums

SSMS 22 Latest Update Crashing

Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...

Transactional Replication setup issue

Hi! I've been banging my head against the wall for 2 days now trying...

The Power of Data and Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Power of Data and...

Visit the forum

Question of the Day

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

See possible answers