PowerShell Saturday in Charlotte, NC

If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...

SCRIPT: Find the row count of all tables and views

Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...

SQL Server: Understanding the Data Page Structure

We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...

The Home Server is Back

After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...

VM Guest Memory – Watch these numbers !

I have been using VMware vSphere client for a while now and the person who inspired me to use this...

Choosing a Mobile Workstation

I get a lot of e-mail and Twitter requests for advice about what laptop someone should buy. I don’t mind...

Ctrl+R in SSMS 2012

After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like...

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...

Database Certificates and the X.509 Standard

 Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...

Drive Size - PowerShell Script

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

## Script to Find List of...