Search results matching tag 'Presentations'

Announcing the 2013 Biml Workshop 15 Oct 2013 in Charlotte NC!

andyleonard — Sat, 18 May 2013 04:00:00 GMT

When:

October 15, 2013
8:45 am - 4:45 pm
Charlotte, NC

Where:

Wake Forest University Charlotte Center
200 North College Street
Charlotte, NC 28202

What:

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. Come see why BI professionals around the world think Biml is the future of data integration and BI.

Registration is just $69. Register before July 15th and receive early bird discount of just $49. Breakfast, lunch, & refreshments are also included. Seating is limited. Register now to guarantee your spot.

:{>

SQLBits XI : Bad Habits & Best Practices in T-SQL

AaronBertrand — Sat, 04 May 2013 14:01:00 GMT

Yesterday I gave my session to the fine folks in Nottingham, UK. Below is a zip file containing the deck and samples:

Bertrand_BitsXI_BadHabits.zip

Little Data Remains Important in Healthcare IT

andyleonard — Tue, 30 Apr 2013 14:31:24 GMT

In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be maintained.

It hasn’t. At least not yet.

My doctor and I speak about this almost each time I visit with him. The corporation that operates his practice nowadays seems endlessly locked in cycles of changing billing and EHR systems in search of low-cost compliance and integration. They’ve (literally) spent millions of dollars and my doctor hates the interfaces forced upon him and his patients (well, one, at least) hates the complexity of the billing and patient records systems. Can’t these systems all just get along?

The result? Higher medical data management costs. I’ll give you one guesses who pays these costs.

Munro posits the following from his article:

By at least one estimate (here) there are now about 500 independent EHR vendors. Out of that large group is a subset of about 400 with at least one customer that has applied for Federal stimulus dollars through the labyrinthine process of meaningful use attestation. That would suggest a “first-cut” of about 100 vendors who made some commitment around certification – but have no reported customers (at least to date). That’s a staggering number of single-purpose software vendors for any industry to support – even bloated healthcare. The simple fact is it can’t. While there have been a few high-profile cases of EHR vendors shutting down, this last week was the first high-profile example of a vendor that was effectively decertified by the Feds for both their “ambulatory” and their “inpatient” EHR products. From the HHS.gov website last Thursday:

“We and our certification bodies take complaints and our follow-up seriously. By revoking the certification of these EHR products, we are making sure that certified electronic health record products meet the requirements to protect patients and providers,” said Dr. Mostashari.“Because EHRMagic was unable to show that their EHR products met ONC’s certification requirements, their EHRs will no longer be certified under the ONC HIT Certification Program.”

You may ask yourself, well, how did we get here? This, folks, is a mess. What’s missing? Applied standards.

“But Andy, you’ve told us standards slow down development!”

And I stand by that statement; standards do slow down development…unless you’re building interfaces. And then standards become the means for decoupled snippets, functions, methods, applications, and even platforms to communicate with each other. In some cases, we simply cannot be productive without standards – like TCP/IP. What would happen if everyone coded their own version of internet traffic? If that was the case, very few of you would reading this post.

Yes, standards slow things down. And yes, they are necessary to insure base functionality. In my humble opinion, we have to get this right with healthcare data. We simply must. While we see similar issues of data management across many fields, medical data is too important to mess around with; it’s (often literally) life and death. And it is certainly a high cost.

More to Consider

Standards exist. Administering and certifying 400-500 vendor solutions is hard.

Part of the Solution

From the actions of the Department of Health and Human Services last week, one can ascertain HHS is taking steps to address the matter. But will all 400-500 companies voluntarily congeal their schemas? Possibly, but doubtful.

My experience delivering US state Medicaid ETL solutions informs me there will be a need for data integration – regardless of the existence of standards and in spite of certification. Why? Standards are not static. The idea of de facto standards emerges from the life cycle of software because software is organic. Even if everyone agreed on the same interpretation of rigid standards (and they won’t), versions 2.0 through n.n will – at a minimum – add fields to the schema. And with additional fields comes additional data.

Standards will be revised when enough product schemas adopt the de facto, and this will drive the need for yet more integration. Don’t take my word for it, examine the entropic history of ICD-9 and ICD-10 codes – the direction of progress is more data, not less.

Learn More

This is one reason we at Linchpin People are focusing on Medical Data Integration. The recording of our first (free!) webinar about Medical Data Integration with SSIS 2012 is available here. Kent Bradshaw and I continue the series tomorrow presenting Medical Data Integration with SSIS 2012, Part 2 in which we focus on loading Provider and Drug data.

I hope to see you there!

:{>

Scripting and SSIS - Free Webinar!

andyleonard — Wed, 17 Apr 2013 15:51:00 GMT

Join SQL Server MVP Tim Mitchell (blog | @Tim_Mitchell) and I as we demonstrate and discuss the many uses of scripting in SQL Server 2012 Integration Services 8 May 2013 at 11:00 AM EDT! In this demo-packed session, two co-authors of the book SSIS Design Patterns share their experience using the Script Task and Script Component to accomplish difficult transformations and improve data integration performance.

:{>

Medical Data Integration with SSIS 2012, Part 2 - 1 May 2013 11:00 AM EDT

andyleonard — Tue, 16 Apr 2013 14:27:00 GMT

Kent Bradshaw and I are pleased to announce another free webinar: Medical Data Integration with SSIS 2012, Part 2 - Providers and Drugs. Register today!

The recording of the first part of this series is available here.

:{>

Presenting at SQL Saturday 189–Costa Rica!

andyleonard — Tue, 09 Apr 2013 15:00:00 GMT

I am honored to present Creating a Custom SSIS Task this Saturday – 13 Apr 2013 – at SQL Saturday 189 – Costa Rica!

Espero que se unan a mí!

:{>

Presenting Hacking the SSIS 2012 Catalog to PASS DW/BI VC Tomorrow!

andyleonard — Thu, 21 Feb 2013 17:57:00 GMT

PASS Data Warehouse / Business Intelligence Virtual Chapter Co-Chair

Web: http://bi.sqlpass.org | Email: PASSDWBIVC@sqlpass.org | Twitter: @PASSBIVC

Friday February 22nd 11am EST(US)

Hacking the SSIS 2012 Catalog
Speaker: Andy Leonard

URL: https://www.livemeeting.com/cc/usergroups/join?id=H4C3NK&role=attend&pw=7%3Ec%2FM5PwM

Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!

Presenting at the Greenville SC SQL Server Innovators Guild 5 Feb 2013!

andyleonard — Mon, 21 Jan 2013 13:00:00 GMT

I will be unveiling a shiny new presentation – Hacking the SSIS 2012 Catalog – at the SQL Server Innovators Guild in Greenville South Carolina 5 Feb 2013! The location of the meeting is:

ECPI, Greenville, SC
1001 Keys Dr
Greenville, SC 29615

If you will be in the area that evening and if you read this blog, stop by and introduce yourself. I’m the fat guy with a fu.

:{>

Using Enterprise Data Integration Dashboards Recording Available

andyleonard — Thu, 13 Dec 2012 12:00:00 GMT

The recording of the presentation Using Enterprise Data Integration Dashboards is now available!

Enjoy!

:{>

Free Webinar - Using Enterprise Data Integration Dashboards

andyleonard — Tue, 20 Nov 2012 12:00:00 GMT

Join Kent Bradshaw and I as we present Using Enterprise Data Integration Dashboards Tuesday 11 Dec 2012 at 10:00 AM ET!

If data is the life of the modern organization, data integration is the heart of an enterprise. Data circulation is vital. Data integration dashboards provide enterprise ETL (Extract, Transform, and Load) teams near-real-time status supported with historical performance analysis. Join Linchpins Kent Bradshaw and Andy Leonard as they demonstrate and discuss the benefits of data integration dashboards.

Space is limited, so register today!

:{>

About Kent Bradshaw:
Kent Bradshaw is a SQL Server database/ETL developer and database architect. His background is in Medicaid claims, public school, government, retail and insurance systems. He was born in Richmond, Virginia and has remained in the area throughout his life. He attended the University of Richmond where he received a Bachelor degree in Information Systems as well as an Associate degree in Public Administration. In 2011, he founded Tudor Data Solutions LLC to pursue new development opportunities as well as join the family at Linchpin People. Outside of work, Kent enjoys spending time with his family, road trips with his wife, playing golf and laughing at the non-stop antics of his dog (and office assistant), Llian the Goldendoodle.

About Andy Leonard:
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns. His background includes Visual Basic and web application architecture and development and SQL Server 2000-2012.

About Linchpin People:
Linchpin People LLC exists to create generations of technology entrepreneurs who are true servant leaders. We desire to serve our customers with integrity and skill. We are here to help and we strive to infuse the Golden Rule and love of God into every aspect of our business. Call us crazy but our goal is to change the world, one career, and one person at time.