Speaking at PASS Summit 2012

Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! ...

Command Line Prompts for Checking Active Directory Membership

Using Active Directory groups are a great way to manage and maintain security for a solution.  Think about if you...

New SSIS 2012 Expressions

SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.

LEFT
The LEFT...

SSIS Project Connection Managers

With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...

Converting to the SSIS 2012 Project Deployment Model

The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...

Upgrading Packages to SSIS 2012

Many of you may now or in the future have the need to upgrade your SSIS packages to the new...

SQL Rally Wrap Up

Another SQL Rally has wrapped up in Dallas, TX and it was great event.  My favorite part about these larger...

Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision

We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”.  Which tool(s) is the best...

OPASS April Meeting Recap

Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting.  I spoke on Extending...

Choosing the Right Microsoft Reporting Technology Part 5: Power View

In part five of this on going series about choosing the right reporting tool we will discuss the newest of...