Category Archives: Presentations

A Biml Case Study

Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine. A Story of Productivity A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts between customers and enterprise reporting needs. They contacted a friend who contacted me. When we spoke they asked, “Can you help?” “Yes,” I replied, “I can help.” We scheduled a three-day visit. On Day…(read more)

Some Thoughts on Event Speaker Selection

I write this from the perspective of experience. I’ve helped organize dozens of events over the past ten years. Feel free to take the parts of this advice that help and discard the parts that don’t. Enjoy! Planning an event is hard work. If you’ve never volunteered to help your local User Group or SQL Saturday, I encourage you to get involved. You will work hard and put a lot into it. But I promise you will get more out of it than you put in. Every organizer is free to organize their event in whatever…(read more)

Presenting on Biml to the SQL Midlands in Birmingham (UK) 11 Sep 2014!

I am honored to present “Using Biml as an SSIS Design Patterns Engine” to SQL Midlands in Birmingham 11 Sep 2014 starting at 18:15! As at SQL Supper the evening before, the other presenter is my esteemed friend, Chris Webb ( @TechniTrain ). Chris’ session is titled, “Everything you wanted to know about Power BI but were too afraid to ask.” I look forward to learning more about Power BI from one of the masters. The abstract for my session: Business Intelligence Markup Language provides a powerful…(read more)

Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 May!

I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here . Art Rask will kick-off the event with an overview of new features of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for mission-critical workloads Cloud and on-premises scenarios support Resource governance improvements Advanced security enhancements After this introduction, two tracks…(read more)

Presenting SSIS 2014 Data Flow Tuning Tips and Tricks in Boston 14 May!

I am honored to announce I will be presenting SSIS 2014 Data Flow Tuning Tips and Tricks at the New England SQL Server User Group Wednesday, 14 May 2014! SSIS 2014 Data Flow Tuning Tips and Tricks Want to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration enterprise. If you will be in the Boston area 14 May, join us! Details here . :{>…(read more)

SQL Saturday #262 : Boston

Today I gave my T-SQL : Bad Habits & Best Practices session at SQL Saturday #262 at Microsoft in Cambridge. Fun event with a lot of friendly faces. A few mishaps along the way: had to wake up at 5:00 AM to take the only sensible commuter rail option to get me there on time; spilled, then proceeded to smear, bagel droppings all over my pants on said train; blew up the projector (literally!) pressing F5 during one of my demos; had to proceed with just hand-waving and a little interpretive dance…(read more)

Presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday 241–Cleveland!

I am excited to be presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday #241 – Cleveland on Saturday 8 Feb 2014! If you’re going to be in the Cleveland area, check out these smart presenters (plus me!) and consider attending! Register here . I hope to see you there! :{>…(read more)

Presenting Using Biml as a Design Patterns Engine to Midlands PASS 9 Jan 2014!

I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014! Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns , demonstrates the flexibility of BIML in this session. Register here ! If you will be near Columbia, SC one week from Thursday and read this blog, stop by and introduce yourself. I’m the fat guy with a fu….(read more)