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,482 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,638 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,256 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,022 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,378 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,385 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,741 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,222 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,401 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,409 reads

Blogs

SQL Saturday NYC Recap 2025

By DataOnWheels

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By Grant Fritchey

Just a quick one this morning. I’m on the road and haven’t worked up...

Why Data Silos Hurt Your Business Performance

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...

Read the latest Blogs

Forums

SSPI handshake failed error code 0x80090311

By jamesstirling01

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Need query help - MAX record

Hello - I have attached a Word document here with details about my issue....

Need query help - MAX record

I am having trouble writing linking the MAX query that I created back to...

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers