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

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

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

T-SQL Tuesday #33 – Trick Shot

It’s T-SQL Tuesday time again, and this is my post for #33. The host is Mike Fal and his topic...

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

Fix: Crystal Reports Shows Red X Across Entire Page When Report Run Inside Visual Studio

I was googling (with Bing AND Google) like crazy for a solution to this, but didn't find one from any...

PerformancePoint 2013 and SharePoint 2013

PerformancePoint is an important BI Tool in the Microsoft world and it will continue to be Microsoft’s solution for creating interactive,...

Querying the Management Data Warehouse for Disk Usage over time (Data Collector)

A part of every DBA’s job is to justify all those disk space requests. The phrases “I just need it”...

High Availability Lingo

You have got to love the way the SQL Server team change the lingo in all of their high availability...