March Monthly CASSUG Meeting

Greetings, data enthusiasts!

Our March meeting is scheduled for Monday, March 13, at 5:30 pm! We will meet in person at Datto, 33 Tech Valley Drive, East Greenbush, NY.

This will be a hybrid meeting!

  • For those joining us in person, we will meet in person at Datto, 33 Tech Valley Drive, East Greenbush, NY.
  • For those joining us online, use the Zoom link to join the meeting. We will send out the passcode as we get closer to the date. You MUST RSVP for the Zoom link to be visible!

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

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.

Thanks to Datto for sponsoring our event!

Our guest speaker for the month is Surbhi Pokhama!

Topic: Principles of architecting a cloud data migration

Is your company planning to move your on-prem, hosted application to cloud? Have you been asked to assess your on-prem data workload and design the new castle in the cloud?
Designing the new castle is an important aspect but also this is more important to live happily in that castle once you migrate to the cloud. That’s where the art of architecting the operationalization aspect comes into play.

In this demo centric session, we will understand the fundamental building blocks of migrating on-prem SQL server workload to cloud via lift and shift or to Azure SQL/Managed Instance. We will build our hierarchy of needs checklist, a secured data migration plan and perform a sample migration to IaaS and PaaS Azure SQL databases keeping Data Security, Size, Performance, and Cost aspects in mind. By the end of this session, you will have a good idea on how to execute a secured and scalable cloud data migration solution.

Advertisement

February Monthly CASSUG Meeting

Greetings, data enthusiasts!

Our February meeting is scheduled for Monday, February 13, at 5:30 pm!

This will be a hybrid meeting!

  • For those joining us in person, we will meet in person at Datto, 33 Tech Valley Drive, East Greenbush, NY.
  • For those joining us online, use the Zoom link to join the meeting. We will send out the passcode as we get closer to the date. You MUST RSVP for the Zoom link to be visible!

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

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.

Thanks to Datto for sponsoring our event!

Our guest speaker for the month is John Morehouse!

Topic: Accelerated Database Recovery – A Deep Dive Behind the Magic
Hocus Pocus!

We have all heard the stories. Horror story after horror story being regaled from database administrators all over the world of waiting for hours or sometimes days for a rollback operation to complete. DBA’s hoping beyond hope that the rollback finishes soon before someone else gets the notion to reboot the server.

With the release of SQL Server 2019, a new talisman was conjured that will save us all from hearing about future horror stories. Accelerated Database Recovery or also known as “ADR”. This new mystical feature changes the way transaction rollback performs and will undoubtedly prove invaluable in your arsenals of magical tricks!

In this session, we’ll show you the secret behind it!

You will –

  • Learn about new components of the transaction log
  • Discover the magic behind ADR
  • Determine when you wouldn’t want to implement it

Don’t be the protagonist in a rollback horror story! After all, the time you save might be your own!

January Monthly CASSUG Meeting — @CASSUG_Albany #SQLUserGroup #Networking

Greetings, data enthusiasts, and welcome to 2023!

Our January meeting is scheduled for Monday, January 9, at 5:30 pm! We will meet in person at Datto, 33 Tech Valley Drive, East Greenbush, 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/290677447/

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.

Thanks to Datto for sponsoring our event!

Our guest speaker for the month is Taiob Ali!

Topic: What the heck is a checkpoint, and why should I care?
An 8K page is the fundamental unit of data storage in SQL Server. SQL Server performs every data modification operation in memory (buffer pool) for performance reasons and does not immediately write it back to disk.

This is where checkpoint comes into play. The Database Engine periodically issues a checkpoint on each database. A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk. It also records this information in the transaction log.

This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.

Taiob Ali

Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 17 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 a 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 the New England SQL Server User Group, founder of ‘Database Professionals Virtual Meetup Group’, and organizer of Boston SQL Saturday.

Happy holidays, winding down 2022, and what’s in store next

As I write this, it’s the day after Christmas, 2022. Hopefully, those of you who are reading this had a wonderful holiday season. I hope you had a great Christmas, Hannukah, Kwanzaa, Festivus, or whatever your holiday celebration of choice is! For me, personally, Santa didn’t leave me much, but honestly, the older I get, the less important tangible Christmas gifts get. I got to spend quality time with my wife and my (now-13-year-old — !!!) niece, and that was the best Christmas present I could’ve asked for.

Now that 2022 is almost over, a lot of people spend time reflecting upon the past year, and trying to figure out what the new year will bring. I am no different, and I have to say that it has been a very eventful 2022.

I won’t get too much into it, as I try to avoid writing about things that are too personal in my very public ‘blog, but I will mention that 2022 was a very trying year. I had to deal with family issues this past August, which included one parent’s death and the other parent facing twilight years of life. (As I write this, the latter is still an issue and is ongoing.) Around the same time, we also dealt with the deaths of one of our beloved pets and a couple of friends of mine from college. To say that this made 2022 a very trying year is probably an understatement. All I could think about is a quote from the fourth Indiana Jones movie: “We seem to have reached the age where life stops giving us things and starts taking them away.” Professionally, I lost a job, got another one, and nearly lost the second one (disclosure: I managed to pull myself out, and am still employed there as I write this). I will not get into any details about the second one, except to say that I discovered something very personal about myself, and although it wasn’t directly related to the other personal issues that I just wrote about, those issues did nothing to help my situation.

What I will mention is that my personal issue was the fodder behind the article I wrote about taking care of yourself.

But enough about the crap that I had to deal with in 2022. Let’s talk about the good things that happened.

I did experience a lot of good things this year. Let’s start with my speaking schedule. Although things are still picking up after the pandemic, I did make it to speak at four in-person events this year, including a new one that had nothing to do with PASS, and my fourth consecutive time speaking at PASS Data Community Summit (or its equivalent).

I still shake my head that I’ve spoken at four straight PASS Summits. I don’t consider myself a SQL expert; as I often say, although I do have SQL experience, my knowledge of SQL falls under the category of “knows enough to be dangerous.” But I’ve been picked to speak there four times, so I must be doing something right!

I think the sentiment of speaking at events like these was best summed up by this tweet from a first-time speaker during PASS Summit.

Not all my 2022 successes were professional. I got to play several gigs with my rock band. I spent some time accompanying a local musical. My alma mater’s football team went 7-5 and is heading to a bowl game. And I got to attend countless events that allowed me to connect (or, in some cases, reconnect) with friends and family. While I did deal with a lot of issues in 2022, I’m happy to say that I’m definitely on the upswing.

That brings me to what’s next moving forward. I’ve received word that I’ve been invited to speak at two more events: another WE Local conference, and at STC Summit! I’m especially excited about the latter, because I’ve been a member of STC for a little while, and speaking at STC Summit has been a bucket list item for me. I also saw save-the-date entries for SQL Saturday as well (including one in NYC that my friend, Thomas Grohser told me about when I was in Seattle last month), so there will likely be more opportunities for me to speak as well. There are also numerous opportunities that are crossing my path. I won’t write about them all now, partially because none of them are in stone, but mostly because there are a lot of them, and I don’t remember them all! So I have a lot to look forward to in 2023 and beyond.

So, that pretty much sums up my reflections. I hope to be doing more as my issues are farther in my rearview mirror, and my upswing continues! Stay tuned for my exploits in 2023, and I hope all of you are on a similar track!

Greetings from #PASSDataCommunitySummit day 1!

Before I get started, let me just say that I’m talking about my first day at PASS Data Community Summit, not necessarily the first day of the Summit. Although today is the first day of general sessions, the first round of pre-cons started Monday, and I didn’t arrive until yesterday (Tuesday).

Getting here was a long trip. I woke up at 3:00 am (Eastern time) to catch my flight, which left at 5:38 am. I had about a five hour layover in Detroit, where I got myself breakfast and took a bit of a catnap, before catching my flight to Seattle. My flight from Detroit to Seattle actually arrived almost an hour ahead of schedule, so there’s that! I checked into my AirBnB, dropped off my things, and headed to the Seattle Convention Center.

I didn’t expect much from my first evening here, but it ended up being quite busy! First, I tracked down my friend, Andy Levy. We chatted for a bit (while taking a little time to recover from our travels), and I suggested we go scope out my room where I would be speaking in the morning. It’s interesting, because since I was last here, there have been changes to this venue. First, there’s the name change. It used to be Washington State Convention Center; now it’s Seattle Convention Center. Second, it has expanded; there is now additional space where there wasn’t before, and my session is in one of them. I’m in a room called Skagit 3, which is located across the street from the main Convention Center. I just hope people are able to find my room!

I signed up to volunteer here, but communications have been both scattered and voluminous, and I’ve had a hard time keeping up with them. I did make it to the First Timer’s Buddy Event, which was an opportunity for first-time attendees to network and get together with veteran attendees (like me!). It was a great event, and tired though I was, I managed to catch my second wind here. I sat at a table with a few friends of mine and about five first time attendees.

It was here that I realized that I’d made a mistake. Those of you who follow my ‘blog likely know about my networking business cards. It was then that I realized that I’d left most of my cards back at my AirBnB (and I wasn’t about to hop back on the light rail to go back and get them). I did have a few in my wallet, so I handed out what I had.

There was also a networking slide presentation. I looked at the slides, and I’m absolutely convinced that Steve stole them from my presentation! 😀 Much of what was on those slides was material that I will be covering during my presentation this morning! With that, I did my best to promote my session! (I also saw my friend Taiob, who also told me he was promoting my session as well!)

The welcome reception followed. When I first attended PASS Summit in 2019, I was overwhelmed (in a good way!) by this event, and although the attendance numbers are down this year, I felt a very similar vibe this year! There were food tables serving a variety of items, along with drink stations (I’m generally not a cocktail drinker, but I decided to use my drink ticket on a Jack and Coke. Hey, if I have a free drink ticket, I’m going to take advantage of it!). I met up with a number of friends, including Ed Pollack, John Miner, Kathi Kellenberger, Grant Fritchey, Peter Shore, and several others whom I can’t remember right now. (Ed. note: I’ll come back later and edit this to include names I forgot and link their pages, if I can!)

I did have one lady at the reception tell me that she recognized me, and told me I was “internet famous.” Well okay, I’m not entirely sure that I buy that, but whatever! I also ran into a Kappa Kappa Psi brother from Northwestern State whom I’d met before, when I was last here in 2019! I made it a point to wear my letters cap to identify myself as a fraternity brother; you never know who you’ll run into!

I had signed up this morning to attend a vendor breakfast, but when I arrived, they had run out of food. I’m not going to lie; I signed up specifically for breakfast, not the sales pitch, and if there isn’t any food, what’s the point? Instead, I went downstairs to get the general continental breakfast that they were serving.

I’m writing this article from the speaker’s room at Summit. My session is in the very first time slot of the three-day session schedule for Summit, and as I write this sentence, I will be speaking about a little less than an hour from now.

Events like this are always a good time, and so far on my Day 1, this one has not disappointed! I’m looking forward to seeing what the rest of the week brings!

Well, I need to get ready to go do my presentation! Wish me luck!

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!