June Monthly CASSUG Meeting @CASSUG_Albany #SQLFamily #Networking

Greetings, data enthusiasts!

Our June meeting is scheduled for Monday, June 12, at 5:30 pm! We will meet in person at Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

For more information and to RSVP, go to our Meetup event page at https://www.meetup.com/capital-area-sql-server-user-group/events/290678900/

Our meeting schedule is usually as follows:

  • 5:30 PM: Food, soft drinks, and networking
  • 6:15 PM: Chapter news and announcements
  • 6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Our guest speaker for the month is Patrick LeBlanc

Topic: Analytics in the Age of AI: What’s Next for the Data Platform?

Join Patrick LeBlanc to learn about the latest developments in analytics with Microsoft. From data integration and engineering to data science and business intelligence, find out how next-generation services can transform your data into intelligence and innovation. Also, see how the new AI-infused Copilot experiences accelerate developer productivity while building in security and compliance for your data.

Advertisement

February Monthly CASSUG Meeting

Greetings, data enthusiasts!

Our February meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/283805310/ to view the Zoom URL!

Our February speaker is Heidi Hasting!

Topic: Power BI Building first report

You’ve heard about Power BI and now want to give it a go. In this session we will go through building our first report.

We start off with a quick intro into Power BI Desktop our tool of choice for Power BI report development.

Then we will go get some data and talk about basic transformation options to clean it up.

Once we have some clean data to work from we will add relationships and look at modelling.

From there we will create visuals to turn data into insights.

About Heidi:

Heidi Hasting is a Business Intelligence professional and former software developer with over seven years experience in Microsoft products. She is an ALM/DLM enthusiast and Azure DevOps fan and co-founder and organiser of the Adelaide Power BI User Group. Heidi is a regular attendee at tech events including Azure Bootcamps, DevOps days, SQLSaturdays, Difinity and PASS Summit.

Our online meeting schedule is as follows:

  • 6:00: General chat, discussion, and announcements
  • 6:30: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.

Thanks to our sponsor, Datto, for making this event possible!

#SQLSaturday #961 Albany — TOMORROW! July 25 #SQLSat961 #SQLSatAlbany

IMPORTANT!  If you are attending SQL Saturday, you MUST register on the SQL Saturday website (NOT Meetup or Facebook) at https://www.sqlsaturday.com/961!

This is a reminder that tomorrow, July 25, CASSUG will host Albany SQL Saturday for the seventh time!  And for the first time, Albany SQL Saturday is going virtual!

We will have a full day of great presentations that cover a variety of topics that include, but aren’t limited to, business intelligence, data science, database development, data architecture, and professional development!

We will also have our usual wrap-up and raffles at the end of the day!

To register, go to https://www.sqlsaturday.com/961.  It is important that you register at this site; RSVPs to Meetup or Facebook do not register you for SQL Saturday!!!

SQL Saturday is always a good time!  We hope to see you (virtually) on Saturday, July 25!

I “speak” Oracle. Can I go to SQL Saturday?

I’ve been involved with SQL Saturday for a while — since 2010, to be exact — and have worked with SQL Server for even longer than that. However, I currently work in an Oracle environment. This likely begs the question: if I work in Oracle, is SQL Saturday still worth my while?

The short answer: yes, absolutely!

The longer answer: there is more to SQL Saturday than just SQL Server.

Although Oracle and SQL Server are different platforms, they are both relational databases. Granted, there are differences between the two — having worked with SQL Server for so long, I’m still trying to grasp some of the concepts of Oracle. However, many of the concepts between the two relational databases are the same. Both databases share the same SQL language — albeit with some differences (akin to, say, differences between American and British English). Table structures are largely the same (again, there are differences, but they share enough similarities that knowing one allows you to grasp the other).

While differences persist between the two environments, cross-pollination between them is not necessarily a bad thing. Understanding their differences can often lead to a better understanding as to how they work.

On top of that, SQL Saturday is more than just the technologies. Speakers, myself included, present on a variety of topics that aren’t limited to just SQL Server. A number of speakers present on BI topics (some SQL Saturdays, in fact, are BI-specific; look for any event labeled “BI Edition”). Other topics include strategy, architecture, disaster recovery, and professional development. (As I’ve stated time and again, my own presentations are all professional development talks; they have nothing to do with SQL Server.)

And SQL Saturday isn’t just about attending presentations and learning. SQL Saturday is a huge opportunity for networking, which is essential for surviving today’s professional market. I’ve written and presented extensively about the importance of networking. A number of other people have also presented on the importance of networking; for PASS events, I highly recommend Matt Cushing‘s presentation about getting ready for a SQL event!

And if that’s not enough, SQL Saturday is just plain fun! I always have a blast at every event I attend!

So even if you work with Oracle, or NoSQL, or Access, or whatever your database of choice, SQL Saturday likely has something for you. Find an event near you, and come join us in the community!

July 20 — SQL Saturday, Albany, NY

On Saturday, July 20 (one week from tomorrow), the Capital Area SQL Server User Group (CASSUG) will host SQL Saturday for the sixth time in Albany, NY!

For those of you who are not regular readers of my ‘blog, SQL Saturday is a daylong conference centered mostly (but not entirely) around data topics related to SQL Server. It’s also a great networking event, and an opportunity to hook up with a number of data professionals! Check out the schedule to see what sessions interest you!

And yes, I am presenting, too! I will do a brand-new presentation about ‘blogging, as well as a lightning talk about business cards! I always look forward to doing presentations in my own backyard!

Additionally, there are three pre-con sessions on Friday, July 19. Unlike SQL Saturday, these sessions are not free, but they provide quality daylong training for specific topics at a decent price. Information about these pre-cons can also be found on the web site!

For more information and to register for the event, visit our website! Upstate New York is a great place to visit during the summertime! Hope to see you there!

The evolution of statistics

During my lunch break, I was perusing the ESPN website and stumbled across this article. It contemplates whether or not a .300 hitter (in baseball, for those of you who are sports-challenged) is meaningful anymore. As a baseball fan, the article caught my attention. I didn’t read through the entire article (it ended up being a much longer read than I expected — too long for me to read while on a lunch break at work), but from what little I did glean from it, a couple of things struck me.

First, they talk about Mickey Mantle‘s batting average and how important hitting .300 was to him. That struck me a little funny, because (as far as I know — as I said, I didn’t get through the entire article) there was no mention of the fact that he actually finished with a batting average under .300. His career batting average was .298.

The second thing that struck me was (Yankees’ first baseman) Luke Voit saying how he felt that “feel like batting average isn’t a thing now.” Indeed, baseball is a much different game than it was, say ten, twenty, or thirty years ago. Analytics are a big part of statistics these days. A lot of stats that are prevalent now — WAR (wins above replacement), exit velocity, OPS (on-base plus slugging), etc. — didn’t even exist when I was a kid growing up, closely following my Yankees. Back when I was eating and sleeping baseball, hitting was about the triple-crown statistics — batting average, home runs, and runs batted in (RBIs). But now, we have “slash lines,” on-base percentage, slugging percentage, and so on. Even as big of a baseball fan as I am, I haven’t a clue about many of these “new age” stats. I still have no idea what WAR represents, I’m not completely sure as to what the numbers in a slash-line are, and I don’t know what constitutes a respectable OPS.

That got me thinking about how statistics have changed over the years, and whether or not that applies to statistics outside of baseball (or sports, for that matter). Maybe people who study data analytics for a living might know this better than I do, but what business statistics have a different meaning now than they did ten, twenty years ago? Are there any numbers from way back when that I should now take with a grain of salt?

I’m sure there are many examples of this outside of sports, but I struggled to come up with any. Off the top of my head, I remember how a company where I once worked made a big deal out of perfect attendance — to the point that they gave out perfect attendance awards at the end of the year. However, that had to contend with situations such as coming to work when you were sick, and so on. Do you really want someone who’s sick coming into work? These days, workplaces do not want sick people in the office, and with the advent of work-at-home provisions, perfect attendance isn’t so meaningful, anymore. (By the way, my understanding is that company no longer recognizes or rewards “perfect” attendance.)

So I suppose the takeaway is, how well do statistics age? Can they be compared with the same statistics now? What needs to be considered when analyzing statistics from years ago? It’s true that numbers often tell a story, but in order to get the full picture, you also need to understand the full context.

SQL Saturday #835, Philadelphia — 5/4/19 (a week from this Saturday)

I just received an email from the organizers of SQL Saturday #835, saying that I should ‘blog about the upcoming event. Okay, I will oblige!

This is the fourth consecutive year that I am speaking at Philadelphia SQL Saturday, and they’ve all been fun experiences! (Last year, I even wrote an article in which I documented my trip!)

This year, I will be doing my presentation on tech writing and documentation.

Image result for chewbacca
Chewie says, “May the 4th be with you at SQL Saturday!”

And… because this year’s Philadelphia SQL Saturday falls on May 4, attendees are encouraged to wear their favorite Star Wars garb. Yes, I intend to participate. No, I’m not saying how. You’ll just have to wait until May 4 to find out!

So if you’re interested in databases, data science, technology, professional development, or just want to hang out with a bunch of computer geeks, and you’re in southeastern Pennsylvania or southern New Jersey a week from Saturday, go register on their site, and we’ll see you there. May the fourth be with you!

SQL Saturday #813 (BI Edition), Boston, MA — I’m speaking!

I just got the official word! I will be speaking at SQL Saturday #813 (BI edition), Boston (actually, Burlington), MA on March 30! This is my first scheduled SQL Saturday presentation for 2019!

I will do my presentation on talking tech-speak to non-technical people!

This will make three times (all in the same building, no less!) that I’ve spoken here since this past September. The first was for SQL Saturday #797, and the second will be in two weeks for the New England SQL Server User Group.

Hope to see people there — either in a couple of weeks, or at the end of March!

SQL Saturday #855 Albany announced!

The Capital Area SQL Server User Group (CASSUG) is pleased to announce that, for the sixth time, we will host SQL Saturday #855, Albany on July 20!

For additional information, to register for the event, or to submit a presentation, click the link above!

I’ve already submitted presentations, but I will be there, regardless of whether or not I’m picked to speak!

Hope to see you there!

Speaking near Beantown

sqlsaturday-logo

I got an email last night announcing that SQL Saturday #813 Boston — BI Edition has been scheduled for March 30, 2019.  I went ahead and submitted my presentations.

Because the Boston Microsoft office (despite the name, it’s actually in Burlington, MA, about twelve miles northwest of Boston) is a smaller facility, events such as SQL Saturday tend to be smaller; it’s more difficult to be accepted as a speaker, and a wait list for attendees is not uncommon.  Nevertheless, if I am accepted to speak at SQL Saturday #813 (far from a sure thing), that is potentially three trips I’ll make to Burlington within a span of seven months.  I am already scheduled to speak at SQL Saturday #797 on September 22 (a week from this Saturday as I write this) and at a New England SQL User Group meeting on February 13.  SQL Saturday #813 would make it trip #3.

Despite the fact that the Boston area tends to be hostile territory for a Yankee fan like me, I look forward to my upcoming trips.  I’m hoping to make it three trips in seven months.

Hope to see you there!