Database and Disk Size - PowerShell Script

Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...

Drive Size - PowerShell Script

The below script is used to find the disk size for a set of servers,

## Script to Find List of...

Troubleshooting Performance - Top CPU Queries

Today I came accross white paper "Troubleshooting Performance Problems in SQL Server" by Sunil Agarwal, Boris Baryshnikov, Tom Davidson, Keith...

Find AD user detail - PowerShell Script

I developed the below script to find the details of a AD user and the AD groups he is associated...

Find Members of AD Group - PowerShell Script

This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...

Forcing network protocol to connect SQL server

Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...

Service pack Native Client, SQL XML4 and VSSWriter failed

One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...

SSIS: Transfer SQL Server Object using SMO

we often face a situation to move SQL server object beween servers or databases, when you have constant table list...

Blocking in SQL Server by SPID -2 (Orphan distributed transactions)

Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...

Rollback TRUNCATE TABLE statement

Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...