Hi Everyone -

We’ll be having our May meeting this coming Thursday, the 23rd at our usual place at the Microsoft Offices at 1290 6th Avenue at 6:00 PM. Kevin Goff, A Microsoft MVP, will be discussing the latest and greatest about SSIS. The full abstract is below. Please register at

https://clicktoattend.microsoft.com/en-us/Pages/EventDetails.aspx?EventId=170199 .

SSIS has always been a good ETL product. In SQL Server 2012, SSIS got even better. Microsoft simplified certain ETL tasks to help new developers learn SSIS more quickly, and added new features that will be a hit to experienced ETL developers. In this presentation, I’ll cover all the new features in SSIS 2012: parameters, new tasks, simplified tasks, new expression functions, data taps for dynamically “tapping” into a data flow pipeline, better handling of invalid metadata references, and a greatly improved deployment model. SSIS 2012 also uses the new SQL Server Data Tools interface (the Visual Studio 2010 shell). After participating in this presentation, you might very well agree with me that SSIS has gone from “good” to “great” in 2012.

Refreshments and giveaways will be provided.

Thanks,

Joe

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP Database architect/developer/speaker/author.

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

__._,_.___

Please join us on April 4th to hear Kimberly Tripp.  We will be meeting as usual at the Microsoft Offices at 1290 Sixth Avenue. Please click the link below to register.

https://clicktoattend.microsoft.com/en-us/Pages/EventDetails.aspx?EventID=169054
Making SQL Server Faster: Four of the Most Misunderstood Topics

Paul S. Randal and Kimberly L. Tripp, SQLskills.com

SQL Server doesn’t have a /FASTER switch, but there are a lot of areas where understanding what’s happening and taking corrective action can help SQL Server process your workload faster, without requiring better hardware. In this session, SQL Server experts Paul and Kimberly from SQLskills.com will discuss four of the most misunderstood areas of SQL Server. Paul will explain wait statistics and exactly how to deal with CXPACKET waits, plus the lesser known effects of index fragmentation and why you always need to care, even when using Solid State Disks. Kimberly will show you multiple interesting reasons why SQL Server won’t use your indexes and how to fix these problems using better indexing strategies and filtered statistics. Come along and learn a new trick or two (or four!).

Come hungry: SQL Sentry is sponsoring pizza. Check out SQL Sentry here.

Bring your business card:

• Every attendee will receive a FREE 30-day code (via email) for SQLskills Training at Pluralsight. Check out SQLskills Training on Pluralsight here.
• One attendee will receive a $500 coupon off of an Immersion Event training course. Check out our Immersion Event schedule here.