Event Notifications 101 – Intro to Event Notifications

Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.  And...

Finding SQL Server Installs with Powershell, Again

But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...

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

Last Weeks Top “Reading” Links #28

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

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

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

PASS Business Analytics Conference Presentation Slides

Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...

PASS SQL Saturday in Chicago Presentation Slides

Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...

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

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