Dirty looking SQL, MDX, or DAX? Clean it up

A quick tip for you:  Ever get some SQL or MDX sent to you in an email, or copied from a website, or pulled from SQL Profiler, that is difficult to understand because it’s not formatted?  Well, there are a couple of free tools that will clean up your SQL: SQLinForm and Instant SQL Formatter.  Simple copy and paste in the SQL, hit the “Format” button, and wallah, nice clean SQL!

DAX Editor for SQL Server is an extension to Visual Studio 2010 that implements a language service for the
DAX language.

The tools to cleanup MDX are from Nick Medveditskov at this Microsoft site (does DAX too) and from Mosha Pasumansky.

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in DAX, MDX, Quick Tip, SQL Server, SQLServerPedia Syndication. Bookmark the permalink.

One Response to Dirty looking SQL, MDX, or DAX? Clean it up

  1. Pingback: New Microsoft BI Labs site | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *