Monthly CASSUG meeting — April 2019

Greetings, data enthusiasts!

This is a reminder that our April CASSUG meeting will take place on Monday, April 8, 5:30 pm, in the Datto (formerly Autotask) cafeteria!

Our guest speaker is Monica Rathbun!  Her talk is entitled: Performance Tuning, Getting the Biggest Bang for Your Buck!

Note that our meeting location has moved!  Datto/Autotask is now located at 33 Tech Valley Drive.  Please do not map this address at this time, as most online maps have not yet been updated. Drive past the old building all the way to the end, where the new building is located! Refer to the map below for the new location.

For more information, and to RSVP, go to our Meetup link at http://meetu.ps/e/FWkVd/7fcp0/f

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

Advertisements

SQL Saturday Boston BI — this Saturday, March 30

This coming Saturday, March 30, I will be speaking at SQL Saturday #813, Buston (BI Edition)! This is my first SQL Saturday for 2019, and it will be the third time since last September that I will be speaking in the Microsoft facility in Burlington, MA!

I will be doing my presentation on how to talk to non-techies, called “Whacha just say? Talking technology to non-technical people.”

SQL Saturday is always a great time! It’s a great opportunity for free training, and it’s also a great networking event — you have an opportunity to meet a number of SQL Server and other data industry experts, as well as a chance to meet other peers within your profession!

Hope to see you in Burlington this Saturday!

Developing an introductory presentation to SQL Server

So far, all of my SQL Saturday presentations have been professional development talks — “soft topics,” as they’re often described. I don’t present about technical topics, but I do present topics that are of interest to technology (and perhaps other) professionals.

This is not to say that I don’t have technical skills. I do have a background in development and databases, but as I often introduce myself during my SQL Saturday presentations, I probably fall under the category of “knows enough SQL to be dangerous.” I am neither a SQL expert nor an MVP. While I am knowledgeable about SQL Server, I likely won’t be doing any presentations about power BI, data compression, or data security anytime soon.

I can, however, discuss rudimentary topics about SQL Server that might be of interest to people who are just getting started with SQL Server. When I first started my ‘blog, I wrote some articles about how to get started with SQL Server. As my ‘blog (and my professional life) has evolved, I’ve been moving more toward the soft topics about which I’m more knowledgeable and tend to present, and away from the hardcore technological topics.

An idea that has been in the back of my mind for some time is to develop presentations geared toward people who are just getting started with SQL Server and even databases in general. This idea is not new; I’ve toyed with it for a while, and only lack of time has kept me from developing it further.

One observation I’ve made during my frequent trips to SQL Saturday events is that many of the presentations are geared more toward “seasoned” SQL personnel; that is, people who already have some background knowledge of SQL Server and its workings. They are all very good topics, but for a person who is just getting started, they can be overwhelming — as is often described, a proverbial “drink from a firehose.”

There does seem to be a market for this idea. I’ve spoken to Grant Fritchey a few times about my idea, and he has encouraged me to pursue it. One thing that was mentioned to me was that part of the reason why many SQL Saturday presentations tend to be more advanced is that the presenters themselves are fairly advanced. A lot of them are SQL experts and MVPs, and are presenting topics at a much higher level from where a SQL beginner would need to start. It would be akin to asking a college professor to teach kindergarten.

Grant even suggested that I make these presentations into an entire precon — as there is way too much material to cover in a single SQL Saturday presentation. This is an idea that intrigues me, and it’s something that I’m interested in developing. It’s just a matter of me taking the time to sit down and putting it together.

I have a few reasons for writing this article. Among them are a form of self-encouragement to pursue this endeavor and a forum to list some of my thoughts. On the latter, I wanted to list a few topic ideas listed so that I can refer to and develop it as I go along.

Some of the topics I would cover would likely include the following.

  • A general high-level introduction to SQL Server and databases in general
  • Basics of T-SQL
  • An introduction to relational tables
  • Basics of data normalization
  • An introduction to database applications

I’m sure there are some other topics that haven’t occurred to me. If you have any suggestions, feel free to list them below in the comments.

This is an idea that has been kicking around my head for at least a few years. Maybe sometime, I’ll actually sit down and start working on it. Hopefully, that sometime will be soon.

Monthly CASSUG meeting — March 2019

Greetings, data enthusiasts!

This is a reminder that our March CASSUG meeting will take place on Monday, March 11, 5:30 pm, in the Datto (formerly Autotask) cafeteria!

Our guest speaker is George Walters! His talk is about security features from SQL 2005 through 2017!

For more information, and to RSVP, go to our Meetup link at http://meetu.ps/e/FWkSv/7fcp0/f

Thanks to our sponsors, Capital Tech Search, CommerceHub, and Datto/Autotask, for making this event possible!

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!

Monthly CASSUG meeting — January 2019

Starting with this ‘blog post, I’m beginning a new habit. Since I’m responsible for communications for my SQL user group (CASSUG — “Capital Area SQL Server User Group”), I will start announcing monthly meetings here in my ‘blog. This is my first such entry for this year.

Our next meeting — our first of the new year — is on Monday, January 14. Andy Mallon will give his presentation titled “Demystifying Data Compression.”

For more information and to RSVP, go to our Meetup link!

Hope to see you there!