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

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

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

SQL Server – Import Data from Excel using T-SQL

To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You...

DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...

Determining when statistics were last updated in SQL Server?

I received an email from friend today asking how he can see when statistics were last updated in SQL Server....

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