I just posted this fun little video (77 seconds) to my LinkedIn feed! It was fun to make and I really like building solutions for the Community. Feedback much appreciated, including suggestions for functionality you’d like to see added to SSIS Catalog Browser.
My chief concern is the scalar nature of the selections (the “Naked Scalar”). As I pointed out in both posts, I’ve been delivering presentations to the SQL Server Community for more than a decade and I’ve never – not even once – delivered a presentation that was strictly Beginner, Intermediate, or Advanced; or Level 100, 200, 300, 400, or 500.
That said, I really like the definitions for PASS Tracks. Click that link and read through them. PASS did a good job distinguishing different types of helpful presentations and defining tracks.
As a data person, I get the logic behind the scalar values. Scalars are easier to store and way easier to search.
My post about presentation levels was inspired more by feedback from attendees who shared they thought my session level was incorrect – that it should have been higher or lower (I’ve actually received both complaints – that the session level was advertised as too high and too low for the same delivery of the same presentation…).
As an engineer, I’d like more accuracy:
I’m not sure sharing more accurately would improve the conference attendee experience. Sharing more than a scalar – at least like the chart above – would increase the costs of printed material. It would require more engagement on the part of the attendee and more detail – and management – on the part of the presenter. Why management? My presentations evolve over time (I like to think they get better but I am biased…)
Would it be worth the investment? I think probably not.
So, while I continue to loathe the Naked Scalar wherever I encounter it, perhaps a scalar is the best solution after all.
I will continue to place these charts in my presentations and share them at the beginning of my session, in case someone thinks the presentation will cover more of one topic they wish to learn about. In this way, people have enough information – early enough in the presentation – to vote with their feet and attend a different presentation.
It’s been a while since I wrote a TSql2sday post – too long, in fact. But I saw the topic trending on Twitter in the SQL Server Community and knew I needed to add my 2 cents…
It’s difficult to list all the people who have inspired me. Many continue to inspire me in small and great ways. I will mention as many as I can here, but please know there are dozens of people who inspire me in our awesome community.
Years ago, I wrote – in a post called Things I Know Now – about meeting Ken Henderson and Kalen Delaney (@sqlqueen) at the PASS Summit 2004. They helped me keep my first data-focused job (“Application DBA”) while working to tune my very first data warehouse. Both were inspiring in person and through their training and writing.
I’ve been blessed to work in vocational and community capacities with others who have and continue to inspire me: Scott Currie (@scottcurrie), Steve Jones (@way0utwest), Brian Knight (@brianknight), Andy Warren (@sqlandy), Brian Moran (@briancmoran), Bennett McEwan; all of whom stretched my understanding, all of whom taught me (some continue to teach me). I’ve been honored to work alongside two dozen authors on a dozen book projects. I’m a proud member of the Richmond Technology Community – an eclectic collection of philosophical geeks in .Net, SQL Server, and other technologies. I get to communicate often (and occasionally work with) with people I consider masters of this trade: Brent Ozar (@brento) and Kimberly Tripp (@kimberlyltripp) and Grant Fritchey (@GFritchey) and Kendra Little (@Kendra_Little) and Paul Randal (@paulrandal) and Adam Machanic (@adammachanic) and Andrew Kelly (@GunneyK) and Brian Kelley (@kbriankelley) and Jimmy May (@aspiringgeek) … and so many others.
And, of course, this awesome community inspires me.
Who inspires me today?
Tom Roush (@GEEQL) inspires me each time we interact. I often refer to Tom as “the best unpublished writer I know.” Tom has an inner strength hidden beneath his calm, cool exterior. He’s wise and kind and “in him there is no guile.”
Frank La Vigne (@Tableteer) – my partner in crime at Data Driven. Frank and Brent are tied for the most productive people I know personally. Whenever people ask me how I get so much done, I immediately think, “I’m not Frank or Brent.” Frank is a survivor. He delivers. He gets things done. He’s a voracious reader and learner. I could say the same things about Brent Ozar.
What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an SSIS Framework.
Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.
Attendees will learn: – a holistic approach to data integration design. – a methodology for enterprise data integration that spans development through operational support. – how automation changes everything. Including data integration with SSIS.
Topics include: 1. SSIS Design Patterns Data Flow Performance ETL Instrumentation 2. Executing SSIS in the Enterprise The SSIS Catalog – the good, the bad, and the ugly. 3. Custom SSIS Execution Frameworks 4. DevOps and SSIS A (Condensed) Sprint in the Life of a Data Integration Solution Version Control and SSIS 5. Business Intelligence Markup Language A Brief Introduction to Biml in the free utilities, BimlExpress and BimlOnline 6. SSIS Design Patterns + Biml Putting the DILM (Data Integration Lifecycle Management) components together. 7. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks Executing the new combinations. 8. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks => DevOps Enterprise-class data integration with SSIS.
The target audience for this course is data integration developers and architects who want to learn more about SSIS performance, DevOps, execution, and automation.
Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.
We’ll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we’ll explain a Data Flow Task’s bottleneck when loading binary large objects – or Blobs.
Finally, we’ll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.