Find Largest Tables To Compress

In this post I’m gong to show some T-SQL that will show you the compression state of tables and how to quickly find objects that are worth compressing.
Last...

New SQL Server Cumulative Updates

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...

Power Shell or Windows – Rebooting of servers local or remote computers

Rebooting of servers local or remote Using PowerShell and Windows
Powershell command
Start->Run->Powershell press enter
PS:\>RESTART-COMPUTER -COMPUTERNAME SERVER01, SERVER02,LOCALHOST
Windows Command
Start->Run->cmd press enter
c:\>shutdown /m...

The dangerous beauty of Bookmark Lookups

Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...

SQL – DBCC CLEANTABLE – DROP UNUSED COLUMNS

Drop those columns which are no more in use.
For example, After Upgrade from MOSS 2007 to SharePoint Server 2010, we have...

Free SQL Server 2012 Installation Guide

Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...

Microsoft GeoFlow new Excel 2013 add-in

Hi

Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...

PowerShell – Find Disk Drive Details of local or remote Server

Name of the Function : Get-DiskDriveDetails
Input Parameter : ServerName
Ouptut : Grid view, you can sort and force condition on specific output column
Function call...

PowerShell – Find top 10 Largest files of a local or remote Drive

Name of the function: Get-LargestFile
The Input parameters are ServerName and Drive.
Function call
PS:\>Get-LargestFile HQDB001 E
In this case HQDB001[ServerName] and E[Drive]
****************************
Code:-
***********************
Function Get-LargestFile([String]$server,[char]$drive)
{
Get-ChildItem \\$server\$drive$...