Want to Learn SQL Server 2012?

andyleonard — Mon, 22 Oct 2012 13:00:00 GMT

Or SSIS 2012? SSRS 2012? SSAS 2012? There’s no substitute for getting your hands on the product, in my opinion.

I can hear you thinking, “But Andy, I can’t afford to purchase a copy of SQL Server 2012.” Are you sure? What if I told you that you can get a full-feature version of SQL Server 2012 Enterprise Edition for $50? Well, you cannot… it’s actually less than $50! SQL Server 2012 Developer Edition is available at Amazon on the day of this writing for $41.24USD. That’s about the price of eight cups of fancy coffee.

SQL Server releases follow a cycle. SQL Server 2005 was a major release with big changes from SQL Server 2000. SQL Server 2008 and SQL Server 2008 R2 were not drastic departures from SQL Server 2005. Take it from me: SQL Server 2012 is a major release.

Is taking your career to the next level worth the price of eight cups of coffee?

:{>

An Important Consideration for SSIS and SQL Server 2012 Business Intelligence Edition

andyleonard — Wed, 18 Apr 2012 11:00:00 GMT

I saw some recent email about SSIS and SQL Server 2012 Business Intelligence Edition. I thought I would share what I have learned.

It is very easy to misinterpret what one sees in SQL Server Data Tools (SSDT – the new BIDS). When you open SSDT all SSIS components are available, whether or not those components are allowed in your edition of SQL Server. In addition, SSDT will allow you to use and execute these components in the SSDT Environment at design time.

SSIS 2012 BI Edition is Not SSIS 2012 Enterprise

You can build and test an SSIS package using Enterprise-Edition-only components, but you cannot execute this package outside the SSDT environment. Here’s a screenshot of a BI Edition toolbox:

Note the Enterprise Edition-only components: Fuzzy Grouping, Fuzzy Lookup, etc. Take a look at what happens when I execute a Data Flow Task that contains a Fuzzy Lookup Transformation in BI Edition:

Now take a look at what happens when I execute that same package using DtExec on the same virtual machine:

Ugliness. And confusion.

Andy

Search results matching tags 'SQL Server 2012' and 'SSIS 2012'

Want to Learn SQL Server 2012?

An Important Consideration for SSIS and SQL Server 2012 Business Intelligence Edition