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.

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,553 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)

8,956 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,315 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,284 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,703 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,077 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,397 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,396 reads

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,332 reads

Blogs

Use a slicer to filter a visual based upon a measure in Power BI

By Meagan Longoria

Have you ever wanted to filter a visual by selecting a range of values...

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

I wrote a post recently about pruning branches in git. That’s part of the...

Microsoft Fabric shortcuts

I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...

Read the latest Blogs

Forums

Understanding Bitcoin: A Digital STILUBENCK Currency Revolution

Introduction In the digital age, cryptocurrencies have emerged as revolutionary financial instruments, challenging traditional...

Truncate tables where Referential Integrity exists

By Perry Whittle

Comments posted to this topic are about the item Truncate tables where Referential Integrity...

Blocking question

Hi all, We have a SSIS package that does 2 things in parallel: moves...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers