Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I...

Web Design & Azure

I’ve listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I’m friends with several...

Secrets of successful projects…:)

Power Map Enhancements and Presentation

Power Map for Excel 2013 has had some recent enhancements that are worth noting.  You can download the latest Power...

Monitoring and Baselines Presentation

Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...

Adding Top 10 Charts to Power View Which Honor Filters

Before I get too far in the weeds, I have to recognize Rob Collie, his blog (http://www.powerpivotpro.com) and his bookDAX...

SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)

Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...

Practical PowerShell: Merge SQLSaturday Speaker SpeedPASSes Into One PDF

To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...

Get SQL Command Compile time

1. SET STATISTICS TIME ON
It not only tell you the compile time of sql command, but also show you the...

Power BI for Office 365 preview released

I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was...