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

Reblog: September 13 to September 19

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Secrets of successful projects…:)

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

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

Extract DacPac Using Command Line

When extracting Dacpacs it’s quite straightforward to go through the UI and extract, however what if you want to do this for more than one database, or automate the...

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

Hit Fast Forward: Converting and deploying DTS packages

This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...

How to Split a string by delimited char in SQL Server..............

However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...

Introduction to Integrity: Data Purity Errors

The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...