CASSUG hosting the Modern Migration Tour, June 19

The Modern Migration Tour is coming to Albany!

End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy.

But, do you have a plan in place? What approach should you take to ensure a smooth transition?

To guide you through these questions, PASS, Microsoft, and Intel® have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform.

For information about this event and to register, click here to view the EventBrite announcement. You must register on the EventBrite link to RSVP.

See you there on June 19!

Advertisements

Monthly CASSUG meeting — May 2019

Greetings, data enthusiasts!

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

Our guest speaker is Mike Jones! His talk is entitled: “Using Pure ActiveCluster for SQL High Availability.”

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

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

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!

Security: Close isn’t good enough!

I am reblogging an article written by my friend, Greg Moore. Hopefully, we all have our data locked down, but I felt that what he wrote was important enough that it was worth passing along.

greenmountainsoftware

I was going to write about something else and just happened to see a tweet from Grant Fritchey that prompted a change in topics.

I’ve written in the past about good and bad password and security polices. And yes, often bad security can be worse than no security, but generally no security is the worst option of all.

Grant’s comment reminded me of two incidents I’ve been involved with over the years that didn’t end well for others.

In the first case, during the first dot-com bubble, I was asked to partake in the due diligence of a company we were looking to acquire. I expected to spend a lot of time on the project, but literally spent about 30 minutes before I sent an email saying it wasn’t worth going further.

Like all dot-com companies, they had a website. That is after all, sort of a requirement to…

View original post 626 more words

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!

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.