May Monthly CASSUG Meeting, May 9

Greetings, data enthusiasts!

Our May meeting will be a hybrid event! We will meet in person at the Rensselaer Chamber of Commerce, 90 4th Street, Troy, and online (the Zoom link can be found on our Meetup event link at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/285622042 )!

Our May speaker is Monica Rathbun!

Topic: Always Encrypted for Beginners
One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database. You have to overcome the obstacle of the application decrypting the data it needs. Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.

For more information and to RSVP, use our Meetup link above! Hope to see you there!

Thanks to Datto for sponsoring our event!

April Monthly CASSUG Meeting #SQLFamily #Azure #SQLAzure @CASSUG_Albany

Greetings, data enthusiasts!

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

Our April speaker is Rie Merritt!

Topic: Transitioning your On-Prem Database Skills to Azure SQL

Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases on-premises was something you long ago mastered. In this session, we’ll cover the most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Premises installs. One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you’re familiar with are all there. Let’s modernize those existing skills to make you a cloud DBA.

About Rie:
Rie Merritt has been working with SQL Server since 1999, when she started as a data analyst for a non-profit. She’s worked in many industries over the years including pharmaceutical, e-commerce, legal, financial, education and both federal & state government. Most recently, she was director of database management, Integrated Payments for WorldPay, Inc. She is currently Senior Program Manager with Microsoft Azure Data, serving as the MVP PG lead and as liaison between the product group and the data community. She is based out of Redmond, but works remotely from her home near Atlanta.

Over the years, Rie has done extensive work with the SQL Community. She was an MVP in the Data Platform for three years, speaking frequently at conferences across the US and moderating webinars, WIT panels and career panels. She has also served co-leader of the PASS Women in Technology Virtual Group and Executive Director of SQL Saturday Atlanta. Most recently, Rie helps run the Atlanta Azure Data User Group heading up Microsoft’s efforts for the Azure Data Community.

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!

March Monthly CASSUG Meeting

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

Our March speaker is Taiob M Ali!

Topic: Options and considerations for migrating SQL Server databases to Azure

Many tools are available to migrate your on-premises database to an Azure SQL database. Are you familiar with all of those tools, and how do you choose the best tool for you? How do you analyze and identify what objects are not compatible with migrating to Azure? Answer: It depends (of course) on the type, size, and complexity of the database you will be relocating.

This session will explore considerations before migration, appropriate targets, migration tools available, and the pros and cons of each tool. I will demo four different tools that you can use to analyze/migrate your on-premises SQL Server Database to Azure SQL.

At the end of this session, you will be aware of the various techniques available to analyze and migrate SQL Database to Azure and choose the best fitting one for your database.

About Taiob:
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 16 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.

Taiob is currently working at “GMO LLC” as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of ‘Database Professionals Virtual Meetup Group’, and organizer of Boston SQL Saturday.

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!

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!

January Monthly CASSUG Meeting

Our January meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL…/events/283055730/ to view the Zoom URL!

Our January speaker is Grant Fritchey!

Topic: SQL Server Query Performance: Common Problems, Possible Solutions

Identifying which queries are running the slowest, or using the most resources is relatively well documented. However, once you identify the query you need to fix, what are you supposed to do next? This session will walk through a bunch of the most common performance problems and how you go about identifying those problems. From there, we’ll discuss some possible solutions for those problems as a way to move you more quickly to a more highly performing database.

About Grant:
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011.

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!

December Monthly CASSUG Meeting

We are doing something different for our December meeting!

We will be hosting a forum with a number of SQL speakers in a quick-thinking “Whose Line?” format! The speakers will get a topic no more than a few minutes before they are to speak, and they will speak on whatever the topic is!

To join us for the festivities, RSVP at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/282546705/ (you MUST RSVP for the Zoom link to be visible).

Come join us for the fun!

#PASSDataCommunitySummit is here! (And I’m speaking!)

It’s here! PASS Data Community Summit starts today!

This is my third straight year speaking at PASS Data Community Summit (or its equivalent), and I look forward to this event each year! This is an event that has become near and dear to my heart, and I try to attend whenever I have the opportunity.

Today and tomorrow (Nov. 8-9) are the pre-con sessions. Unlike the Wed-Fri conference sessions, there is a fee for attending pre-cons. And while I, personally, am not attending the pre-con sessions, I can tell you that they are led by many world-class speakers. Check out their schedule, and if you see any sessions that interest you, they are well worth your time (and your money) to attend!

The rest of the conference (Nov. 10-12) is free to attend this year! There are a number of great sessions presented by many wonderful speakers! Again, if you see any sessions that interest you, I encourage you to check them out!

And, of course, I need to include a plug for myself! As I mentioned, this is the third straight year that I am speaking for this event. My session is titled: “I lost my job! Now what?!? A survival guide for the unemployed.” If you are out of work (or even if you’re looking for employment), this session offers tips on how to survive a jobless situation. I am scheduled to speak on Thursday at 9:30 am EST. Hope to see you there!

There are also opportunities for networking as well! You can speak with vendors, speakers, and other attendees. I encourage you to check out things like the Community Zone and the Expo Lounge.

It isn’t too late to register for this year’s free online PASS Data Community Summit! Just use the link to register and attend this great conference!

See you at Summit!

November Monthly CASSUG Meeting

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

Our November speaker is Pamela Mooney!

Topic: Code Smells – How to Keep Your Code From Stinking

Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server. Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.

Bad SQL coding practices are known in the SQL community as “code smells”. We will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.

About Pamela:

Pamela Mooney is a Senior Analyst with NISA Investment Advisors, LLC. he road to IT was a long and winding one for her, but she fell in love with SQL Server and knew that she wanted to be a DBA after her first database class in college. She was fortunate enough to be hired in as a junior DBA straight out of school, and never looked back. She is now a senior DBA who loves to mentor and teach – as well as to continue to learn. A one-time, part-time professional musician and songwriter, she has a medical background and am a passionate history nerd. In my spare time, she likes to hike, bike, read, go to the Ren Faire, write, and talk to you.

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!

October CASSUG Monthly Meeting #Networking @CASSUG_Albany #SQLServer #UserGroups

Greetings, data enthusiasts!

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

Our October speaker is Josephine Bush!

Topic: SQL Auditing

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!

September CASSUG Monthly Meeting #Networking @CASSUG_Albany

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

Our September speaker is Kathi Kellenberger!

Topic: What is DevOps and Why Should DBAs Care?

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 using the link above, 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!