T-SQL Tuesday #37: JOIN Formatting… It’s all about S-T-Y-L-E…

T-SQL Tuesday #37 is upon us, with this month’s topic being about Joins, as hosted by Sebastian Meine.  While there will be many others writing about the how’s and why’s about Joins, I’d like to contribute something about style of formatting the syntax of Joins.  In my experience working from project to project, it can be truly daunting to inherit T-SQL code where the Join syntax is difficult to read due to bad or no formatting.  Consider this simple yet unformatted T-SQL query, displayed in the monospaced font, Courier:

While it may take no more than a minute to read and see what is happening here, consider the following three examples on better ways to format the query (note that the default TAB size if four characters):

Each of the examples above has their own pros and cons as to why they’re preferred over the other.  I have seen many blogs where the version 1 example is used by many.  I myself prefer version 2, but in my last project I worked on, my colleague who was the lead on the project team preferred version 3.  Whichever or however Join formatting is used, my message would be: format your Join syntax with more than just the version 0 example above, and be consistent with it in your T-SQL code.  With this in mind, I followed the lead of my colleague and used the version 3 formatting on the project, to keep consistent the look and feel of the T-SQL we deployed for the project.

Just remember, pick a formatting style for your Joins that make the Join syntax readable, and stay consistent with that style!

My two and a half cents!…

Posted in T-SQL Tuesday | 3 Comments

Recounting PASS Summit 2012, Part Three…

So now we’re at day three of PASS Summit 2012, or at least, my third day.  You can follow these links to see my day one and day two recaps.  The third day, Friday, followed a wonderful Thursday evening at the EMP, and it did not have a key note in the morning.  Still, I made it to the conference for the second session of the day…

Lightning Talks : Friday November 09 : 09:45 AM – 11:00 AM

  • Christian Wade – Is It an Alligator? Is It a Crocodile? No, It’s a Gecko!
  • Edwin Sarmiento (Blog / @EdwinMSarmiento) - Presentation WOW
  • Julie Koesmarno (Blog / @MsSQLGirl)- TRY CATCH in a Nutshell
  • Laerte Junior (Blog / @LaerteSQLDBA) - T-SQL Health Check to Excel in Email in 10 Minutes with PowerShell
  • Neil Hambly (Blog / @Neil_Hambly) – Effective Error Log Parsing

Now this was a treat.  Several presenters doing 10 minute sessions, focusing on the highlights or the important aspects of their topics.  I will admit, I wanted to catch Julie for the most part, as I tried to attend her SQLLunch.com presentation, “Ready Steady Catch”, a couple weeks back.  I was able to attend initially, but given I was in the office at the time, work duty called, so I could not sit for the entire presentation.  So I made sure to get to her lightning talk.  And really, I’m just a fan.  However, the other speakers were great in their own right.  Christian offered his reptilian take on BI.  Edwin, fellow Filipino extraordinaire, had a very engaging and energetic session on how presenters, no matter the topic, should wow their audiences; you can really tell Edwin rehearsed his presentation many, many times, and it truly showed.  Laerte is a diehard Star Wars fan, adding fandom-inspired humor to his PowerShell demo.  And Neil gave us an abbreviated yet in depth look as parsing the error log.  There was one no-show to the lightning talk session, so Edwin dug up another 10 minute presentation and proceeded to provide another inspired and enlightening talk.

The Key2 Consulting crew took time at lunch to hit the Pike Place Market and had a great lunch at Lowell’s Restaurant.  After a little sightseeing of the Seattle waterfront, it was back for one final session…

Extending SSIS 2012 Reports with Analytics - Friday November 09 : 02:45 PM – 04:00 PM
Patrick LeBlanc (Blog / @PatrickDBA )

Patrick ended up co-presenting with Julie Koesmarno for his session on SSIS 2012.  Really, though, he made Julie do all the work.  The bum!  All kidding aside, Patrick is a great fellow who I follow on Twitter and is the man behind SQLLunch.comNo fluff, just stuff. Now, he’s a Microsoft guy, having been a part of Thursday’s BI Power Hour.  But watching Patrick in person is a must see for those who have only listened to him from SQLLunch.com or other online sessions.  If you’re late to his session, he’ll pick on you, for sure.  But aside from levity, Patrick and Julie both offer thier seasoned views on taking data from the Cloud via SSIS 2012 and consolidating the analytic data now available via SSIS 2012.

After the session, the Key2 crew headed off from Summit 2012 to take in the latest James Bond flick, capping off a great PASS Summit 2012 experience.  The rest of the crew has either a redeye or early Saturday AM flight back to Atlanta, while my flight was not until 11 AM on Saturday morning.  Next year, PASS Summit 2013 will be closer to home in Charlotte, NC.  Hope to be there again to learn, to network, and have some fun.  Thanks for reading!

Just my two and a half cents…

Posted in SQL PASS Summit 2012 | Comments Off

Recounting PASS Summit 2012, Part Two…

The other day, I recapped my first day at SQL PASS Summit 2012. By the second day, Thursday November 08, the time difference from the East Coast to the West Coast was getting to me, so I did not make it to the second keynote; I’ll have to follow up on the recording another time. However, I made it to four sessions during the day, while making sure to be able make it to the Microsoft sponsored event at Seattle’s EMP later that evening.

At the EMP, later in the evening...

Query Tuning Mastery: The Art and Science of Manhandling Parallelism : Thursday November 08, 2012 : 10:15 AM – 11:30 AM
Adam Machanic (Blog / @AdamMachanic)
This session interested me the most even to this day, as I review the recording that was added to the end of the Day 2 Keynote that captured this session. I follow Adam via Twitter so it was great to see the man in person during his presentation, though he was in the big auditorium room where the overflow for the Keynote was held. I would have loved to apply his tuning principles right away, but I’m off to another client that has more ETL needs that SQL tuning, but this would have helped tremendously with a prior client. Who knows? I may find myself there again… Anyway, big tip Adam shared while tuning SQL within SSMS was to do the following:

  • Actual Execution Plan enabled
  • Client statistics enabled
  • Discard results after execution

While it’s best to review the recording as a whole, in short from Adam’s sample files, the APPLY pattern he uses is as such:
–The Parallel APPLY Pattern
SELECT
x.[columns]
FROM [driver set] –< This is where you define your chunks
[CROSS/OUTER] APPLY
(
[correlated payload] –< This is where all of the work is done
) AS x

What to Look for in Execution Plans : Thursday November 08, 2012 : 01:30 PM – 02:45 PM
Grant Fritchey (Blog / @GFritchey)
Grant is another gentleman I follow on Twitter, so again, it was a joy to see the individual in person for his presentation. And after Adam’s session prior to lunch, Grant’s session would reinforce what to look for while examining execution plans. However, I will admit, the past two lunches provided by PASS (Wednesday and Thursday) were very good, and thus it was a challenge to stay totally alert throughout the session. Thankfully, there’s Seattle’s Best coffee waiting outside.

Database Design Throwdown : Thursday November 08, 2012 : 01:30 PM – 02:45 PM
Thomas LaRock (Blog / @SQLRockstar) , Karen Lopez (Blog / @DataChick)
Ahh, the Rockstar versus the DataChick. This was a great session to attend, seeing another pair of Twitter peeps that I follow. It turned out to be SRO (standing room only), so I was glad to have gotten a seat in the room. Tom and Karen via a throwdown session offered two opposing sides of database design issues. Normalization versus not; Nullable versus non-Nullable fields; DBAs versus Developers versus PMs. It was great! The energy was high and helped to keep the audience engaged, educated, and entertained. Plus the coffee beforehand was kicking in, too!

BI Power Hour : Thursday November 08, 2012 : 05:00 PM – 06:15 PM
Matt Masson, Chuck Heinzelman, Matthew Roche, Patrick LeBlanc, Peter Myers, Sean Boon
This was another highlight from Summit 2012. There was lots to learn, especially about hugs and tapping everything. Suffice to say, you had to be there.

After the sessions, the Key2 crew headed out to dinner at Dragonfish Asian Café a block or so from the conference. What can I say? There was Tempura Bacon to be had, and Sake to boot!

And finally, the day ended at EMP http://empmuseum.org/. While there was SQL Karaoke to be had, one of the highlights was the Icons of Science Fiction exhibit, where this bad boy below can be found.

But the other highlight was the debut of the awesome rock band, the Krooked Keys 2 [Squared]! Follow the link below to watch our one-night only performance. Only true rock fans can appreciate the awesomeness!

Posted in SQL PASS Summit 2012 | 1 Comment

Recounting PASS Summit 2012, Part One…

So last week, I along with almost 4,000 attendees participated in PASS Summit 2012 in Seattle, Washington, between Wednesday November 14 through Friday November 16.  This didn’t include the many who attended PreCons on Monday and Tuesday, totaling over 5.5K of registrations.  The underlying theme I found while attending PASS Summit 2012 was SQL Family.  Now, I know I’m not that well connected to the SQL Family as many are, but I do like to watch from afar, keeping tabs on the notable SQL peeps via the internets and all.  So for me, finally being able to meet a few in person or via participating in their sessions was a real joy during PASS.

My blog entry today is part one of several entries made to recap the sessions I attended, what tidbits I was able to learn, and to highlight the people and events around PASS Summit 2012.  This first entry recaps day one of PASS, Wednesday November 07.

The First Keynote : Wednesday November 07, 2012 : 08:15 AM – 10:00 AM

An introduction was made by Bill Graziano (Blog: SQLTeam.com | @BillGraziano), where among speaking about SQL Family, Bill announced the upcoming PASS Business Analytics Conference (@BA_Conf), to be held in Chicago, Illinois in April 2013.  But the keynote itself would be handled by Microsoft’s very own, Ted Kummert, where he along with other Microsoft employees talked on how to “Accelerate Insight on any Data”.  The highlights of note were, as summarized by Steve Hughes ( Blog: Data on Wheels)

  • Hekaton: the project code name for a new in-memory OLTP engine
  • The Columnstore Index will be updateable
  • Next version of PDW will be out in H1 2013
  • Polybase: allows you to query across multiple types of data sources such as SQL Server and Hadoop with T-SQL
  • DAX Queries will be able to query SSAS Cubes
  • Microsoft HDInsight Server CTP: Hadoop for Windows Server
  • Windows Azure HDInsight Service Preview: Hadoop for Azure
  • Power View and PowerPivot fully implemented in Excel 2013

10 Extraordinary Things to Achieve with Integration Services 2012 : Wednesday November 07, 2012 : 10:15 AM – 11:30 AM

Peter Myers (PASS Bio), Matthew Roche (PASS Bio)

For the first session after the exciting keynote, the balance of calm and cool Peter to the hyper and electric Matthew made for an insightful recap of why we use SSIS in implementing ETL solutions.  Newcomers to SSIS can take away the many things that SSIS can do for them, while experienced users (I’d like to think I’m experienced, more so than where I was a year ago) can recap everything else SSIS can do.  Here’s the recap of the outline and the delivery points, from their posted slide deck:

Session Outline

  1. Exporting/Importing Binary Data
  2. De-Duplicating Data
  3. Implementing Custom Logic with Scripts
  4. Leveraging CDC
  5. Cleansing Data with Data Quality Services
  6. Integrating Data Mining Predictions
  7. Working with Environments
  8. Working with the SSIS Catalog API
  9. Implementing a Data Tap
  10. Monitoring and Analyzing SSIS Catalog Data

SQL Server Integration Services delivers

  • A rich set of features and capabilities
  • A robust, flexible, fast, scalable and extensible architecture
  • While it was primarily designed to implement ETL processes, it is also useful in many other scenarios:
  • Assessing data quality
  • Cleansing and standardizing data
  • Merging data from heterogeneous data stores
  • Implementing ad hoc data transfers
  • Implementing ad hoc data manipulation
  • Automating administrative tasks

Adapting Your ETL Solutions to Use SSIS 2012 : Wednesday November 07, 2012 : 01:30 PM – 02:45 PM

Devin Knight (Blog | @Knight_Devin)

After lunch, I made a point to go see the session from an old friend from Jacksonville, Devin Knight.  And the topic was in line with an upcoming project I hope to be a part of and start in 2013 as the project will look to move existing ETL packages towards SSIS 2012.  A demo heavy session, I took away the following bullet points:

  • Use the SSIS 2012 Wizard to convert older packages to SSIS 2012 with SSDT, which is SQL Server Data Tools; it is no longer called BIDS
  • Packages can still use Legacy Mode to access file-based packages
  • However, use of Legacy Mode will not leverage SSISDB
  • SSISDB is where the advantages of SSIS 2012 happen

The afternoon ended some visits to the sponsor booths and some feet resting, as the jet lag from flying from Atlanta to Seattle the day before caught up with me.  I was able to later join my Key2 Consulting colleagues and participate in Bill Speidel’s Underground Tour of Seattle http://www.undergroundtour.com/.  It was a very educational and enlightening tour and history lesson of Seattle.  If you have about a couple of hours to spare to learn about crappers and seamstresses, and can handle some light walking up and down stairs, it’s a must see in Seattle.

After dinner and a few cocktails with Key2 crew, I was able to make a very late albeit brief visit to Pragmatic Works’ SQL Karaoke event at the Hard Rock Café.  Yeah, we arrived late, but arrived in time to see several SQL ladies entertain the crowd to their rousing rendition of Sir Mix-A-Lot’s “Baby Got Back”.  Yeah, you had to be there to see/hear it.

And after a brisk walk in the Seattle Fall night back to the Crowne Plaza hotel, it was off to bed, and one day down for PASS Summit 2012.  Next up, Thursday…

As always, just my two and a half cents…

Posted in SQL PASS Summit 2012 | 2 Comments

#Meme15 Assignment #3 – Why and how Jason uses LinkedIn?

#Meme15

I saw Jason Strate’s (Blog|Twitter) recent call out for the February #Meme15 assignment, “Why and how you use LinkedIn?”, so I figured I’d chime in.

“Why I use LinkedIn?’ Simply put, it is my online resume.  While I try to update an actual resume in MS Word, having my information on LinkedIn allows me one online location where the content is saved.  But in a day and age where job security is not always dependent on what you know, I myself try to keep my MS Word resume up to date, and simply have LinkedIn mirror it.

As far as “How I use LinkedIn”, I’ll take this moment to say that I do not use it to connect to every person I know of or read about or even tried to get a job from.  On that last comment, that means I always decline accepting connections from random recruiters or even other SQL Server Professionals with whom I have never talked to or even corresponded to.  It’s not that I am being an elitist or such; it’s just that if I haven’t talked with you or met you in person, I simply won’t connect.  To me, this ensures my connections are genuine.  Each and every connection made, I feel I have worked with them in some way or another, and usually there’s a back story to relay in regards to that connection.  Whether it’s former co-workers from my days at Humana, to my early SQL Server reports and applications work at WaMu or Citi, to even recent connections via SQL Saturdays or other SQL Server Community events, the people I connect to, I know.

Anyway, that’s my take on Jason Strate’s call for the #Meme15.  There is definitely more to LinkedIn, and opportunities abound within its network of connections.  But for now, this is why and how I use LinkedIn.

My two and a half cents…

Posted in SQL Meme Monday | Comments Off

Atlanta SQL Saturday #89 – Check out the BRAIN POWER!!!…

Tim Radney (Blog|Twitter:@TRadney), our wonderful and most excellent leader in organizing our SQL Saturday #89 up here in Atlanta, GA, blogged recently about the difficulties involved in organizing such an event.  That blog post can be found here.  What stands out for me and what I feel is important to note is the number of Microsoft MVPs and even Microsoft employees scheduled to speak.  Currently, there are 14 MVPs and 3 MS employees.  And two of them are hosting PreCons!!!  Here’s the awesome list:

I don’t know about other SQL Saturdays, but that is a lot of brain power here.  So be sure to see and meet these fine folks, this coming September!  Be there, or be square!

My two and a half cents!!!…

Posted in SQL Saturday 89 | Tagged , , , | Comments Off

An alternate, perhaps better view of the SQL Saturday #89′s AWESOME schedule!!!…

I’ve seen on Twitter and heard over the grapevine that the SQL Saturday website can be managed a lot better.  Now while that is true, for an extension of PASS, it’s a common look and feel web tool for user groups to host a SQL Saturday event in their backyard.

But here we are now posting the schedule for SQL Saturday #89 to be held in Atlanta, GA on September 17!  Want to see a better view.  Check out the image below, linked to a bigger image.

Better yet, want to check it out in MS Excel?  Well here you go!

So check it out, and make plans to attend!!!

Thanks, and again, just my Two and a Half Cents!!!…

Posted in SQL Saturday 89 | Comments Off

T-SQL Tuesday #20 – T-SQL Best Practices – Formatting versus “The process worked and that’s what matters most, right?”

It’s that time of the month again for TSQL2sday, this time around, hosted by Amit Banerjee (Blog|Twitter).  The topic for the twentieth edition: T-SQL Tuesday #20 – T-SQL Best Practices.  Follow the link to see all of the other contributions made by the wonderful Online SQL Server Community, here is my humble contribution.  And many thanks to Adam Machanic (Blog|Twitter) for hosting the very first TSQL2sday event!

In my experiences and in my opinion as a SQL Server Developer, one of the best ways to help manage and mitigate SQL issues is to at least encourage consistent formatting within T-SQL code.  In one of IT shops I used to work for, each project was handled by a different IT resource, whether it was a developer or a DBA or even a Business Analyst who knew how to write T-SQL.  T-SQL would be written, would be deemed to work, and then implemented without question or with little to no peer review.  The process worked and that’s what matters most, right?

Cartoon Image from: http://c2.com/cgi/wiki?SpaghettiCode

Well, when I became a follow up IT resource tasked with Production Support on these processes, it amazed me how much the T-SQL itself was written with no formatting whatsoever.  For the most part, the term ‘spaghetti code’ came to mind when I witnessed T-SQL all garbled up with inconsistent or no formatting.  Ironically, the code would work, but something new was introduced—whether it was new data or new business rules—that now required the T-SQL to be fixed.  And my, did it need fixing.  I recommended using free online tools such as TSQLTidy.com (Blog|Twitter) to quickly clean up any T-SQL that came across that was deemed unreadable.  While I praised TSQLTidy.com to members of my team, only a few took note, and unfortunately for some, promoting better T-SQL formatting became a lost cause.

Spaghetti Code Image, as shown from WikiPedia

So while I encourage consistent formatting in T-SQL code, here is an example of how I would apply good formatting practices that I observed from two different shops.  The first image is just a sample query used against the AdventureWorks database:

Within the script above, there is a lot of inconsistent formatting and code use.  Mind you, the query correctly pulls the desired results, but I would hate to support Production code where the majority of the T-SQL looked like this.  (Actually, I did hate supporting this.)  The point is, if a little effort was done to clean up the script, maintenance and troubleshooting would be much easier for the next IT resource to manage.

So in one shop, I would reformat the query as such:

To clarify what I did, here are some notes with the following image:

  1. Use of the TAB value when indenting groups of lines.
  2. Use of braces to identify all returned columns from the query, where the name in braces is followed by the equal sign and the value for the returned column.
  3. Always aliasing all tables, and all fields appropriately prefixed with the alias.  This is done so that every referenced field can be traced back to which table it is sourced from.
  4. Use of the braced returned columns within ORDER BY clauses.

In another shop, I would reformat the code as such:

And again, to clarify what I did, here are some notes with the following image:

  1. Instead of returned columns noted by braces, the AS syntax is used consistently with each returned column in a quoted name.
  2. Use of a ‘river of white space’ over tabs in order to format the query around a column of spaces.
  3. Still, always aliasing all tables, and all fields appropriately prefixed with the alias.  This is done so that every referenced field can be traced back to which table it is sourced from.
  4. Use of the quoted returned columns within ORDER BY clauses.

This is by no means a how-to document on the best way to format T-SQL.  If anything, the message is to be consistent with whatever formatting style used by the company.  Check with senior team members and even the DBA team for their recommendation, and follow suit, if only to have a common look for all of the Production T-SQL code.  Sure, it may be a daunting task to re-format everything, but if anything has to be maintained or managed or enhanced, then theirs is your opportunity to clean up the inconsistent code.

As s quick note, here is what TSQLTidy.com will do for us:

So in short, a T-SQL Best Practice: Consistent formatting of T-SQL code.  It’ll save some stress, and it’s not only a best practice, it’s a good practice!

Thanks for reading my TSQL2sday entry!

And as always, just my two and a half cents!  Thanks!

Posted in T-SQL Tuesday | 1 Comment

I want you to attend John Welch’s Atlanta SQL Saturday #89 PreCon!!!

I want you to attend John Welch’s (Blog | Twitter) PreCon “Data Warehousing with SSIS DEEP DIVE” for SQL Saturday #89 Atlanta.  Yes, that’s what I want.  It’s to be held on Friday, September 16, and the details of which are below and can also be found here at the SQL Saturday #89 site.

Now why do I want this? Sure, it’s to be sure we have good number of attendees.  But also, it’s to share with you that as an attendee to John’s PreCon, you’re bound to participate in an engaging and informative day of BI training. I myself had attended one of John’s SQL Saturday session, way back in January this year in Tampa.  I even blogged about here over at BIDN.com. In about an hour, I learned a few things that I captured in the blog that I did not know before. But for a day’s worth of BI, there’s bound to be more. And as mentioned, it’s sure to be engaging and full of information and learning.

Whether you’re new to BI or a seasoned BI veteran, if you’re in the Atlanta area and can make it to Georgia State University (Alpharetta Center) on Friday September 16, please consider John’s PreCon.  At $99 for a full day of training, plus the networking amongst peers and the like, it’s definitely worth the price of admission and more!

Thanks again!  My two and a half cents!!!…

The details:

John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics.

Want to learn more about implementing data warehouse ETL with SQL Server Integration Services? Attend this full day seminar, and we’ll cover using SSIS for data warehousing in-depth. You’ll learn everything you need to know to populate your data warehouse with data. We’ll cover how to develop a common framework for your packages, automate the creation of rote packages for staging data, implement common patterns for handling various types of dimensions and fact tables, and how to instrument your packages to identify and recover from failures when loading data. We’ll be using the AdventureWorks databases for the examples, so bring along a laptop configured with SQL Server 2005 or later, and the AdventureWorks sample databases installed. We’ll also cover how the upcoming Denali release of SQL Server affects what we discuss in this seminar.
Topics will include:
  • Laying out a framework for your ETL
    • Logging
    • Restartability and Recoverability
    • Auditing
  • Handling Dimensions
    • SCD Type 1
    • SCD Type 2
    • Advanced Dimension Types
  • Handling Facts
    • Transactional
    • Periodic Snapshot
    • Accumulating Snapshot
    • Advanced Fact Patterns
  • Errors
    • Handling Processing Errors
    • Handling Data Errors
    • Recovering from Errors
  • Best Practices for Managing Your ETL
Posted in SQL Saturday 89 | Comments Off

Atlanta SQL Saturday #89 – The Blitz Is On!!!…

The blitz is on!!!

Well, technically, there’s no official NFL Football yet for the fall, but if you’re in tuned in the online SQL Server Community, you may have noticed a fair number of us are filling the social network media with new about this September’s Atlanta SQL Saturday #89.  Details on SQL Saturday in general can be found at SQLSaturday.com, but for those in the Atlanta area or even in the South Eastern United States, we are encouraging you all to come on down (or up) to North Atlanta to the fine campus of Georgia State University on Saturday, September 17.  With three other SQL Saturday events across North America occurring on the same day, your team from Atlanta wants to make sure you all are in the know with what’s happening for SQL Saturday #89!

So again, a number of us have been filling Twitter with messages about Atlanta SQL Saturday, specifically using the hashtag #SQLSat89.  This fine group comprises the organizing committee that’s dedicated to bringing one of the best SQL Saturday events out there.  Team members include the following SQL Server Community notables:

  • @Erin_IntellinetErin Hicks is the wonderful Director of HR & Recruiting at Intellinet, a management and Microsoft-centric technology consulting firm in the Atlanta area.  At our last meeting, leave it to Erin to make sure we had deliverables and deadlines with all of the many tasks we have to juggle to get SQL Saturday organized and ready for you all.
  • @SQLThugetteKristy Mishra is the excellent DBA for iPartners.net, that designs “’on-demand’ management information and analysis solutions for P&C [insurance] companies”. When not too busy, you can find Kristy tweeting away under the handle @SQLThugette, often referencing the many works of the great Josh Whedon!
  • @Datachix1Julie Smith is the “way cool” co-worker of mine here at Key2 Consulting. Even before I began working at key2, I met Julie down at SQL Saturday Tampa, back in January 2011.  A friend of mine from Jacksonville and I were both at her session, and he pointed out “Hey Jason, Julie works with Key2… Isn’t that the company you’re talking to?”… Lo and behold, I met Julie, and now I get to work with her in a great company and with a great SQL Saturday Team!
  • @Datachix2Audrey Hammond, the other great half of DataChix.com is no longer with us at Key2…  Boo.  But she’s doing what she loves working more SQL Server  work versus BI, so she’s in a great place!  (What, you don’t love BI???)  Audrey has been great welcoming me to the Atlanta area, and I must thank her for introducing me to Taco Mac.  PS., I still have laptop-envy for her cool Alienware laptop!
  • @SQLvariantAaron Nelson.  For many, Aaron needs no introduction.  A master (or perhaps grandmaster) of PowerShell, I did meet Aaron briefly at SQL Saturday Orlando back in October 2010 (which he didn’t remember meeting humble, old me), but I remember him best participating in SQL SmackDown in SQL Saturday Tampa, January 2011.  He’s a great guy, but in a SQL SmackDown, beware the fury of the @SQLvariant!
  • @TRadneyTim Radney, I must say, is the most humble yet most organized leader of our cool Atlanta SQL Saturday team.  Tim has a vision to bring the best SQL Saturday event to all, from speakers to sponsor, and to attendees and volunteers.  Myself and the members above just need to keep up and just supplement the work Tim has before us.  It’ll be great, and I know with Tim as our lead, we’ll have the best Atlanta SQL Saturday, if not one of the coolest SQL Saturdays out there.

So that’s out team.  Don’t be surprised to be called upon by one of these fine folks.  Don’t be surprised to asked to speak, to volunteer, or even just attend.  SQL Saturday is a free event in nature.  But SQL Saturday is also brought to you by great people behind the scenes, as you can see by the list above.  I just hope I too can do my part to bring to you all the best Atlanta SQL Saturday of them all!

Thanks for reading!  As always, just my Two and a Half Cents!

Posted in SQL Saturday 89 | 1 Comment