Author: way0utwest

  • Moving the Community Forward

    Today is the last day that the PASS and SQL Saturday websites will be active. It’s possible that they will be shut down as this post gets published, and if so, I will be sad for their loss. I’ve already moved my SQL Saturday.com bookmark to https://sqlsathistory.com/, where André Kamman has captured quite a bit of the data.

    In any case, the organization will cease to exist, though I expect to learn about the fate of SQLSaturday.com in the next few days. I put in a bid, but I know some other organizations have as well, and I expect one of them to acquire the brand.

    I don’t quite know how to move forward, but I have a few ideas here, at the local and global levels, and this is my proposal.

    One Day Free Tech Events

    SQL Saturday was dreamed up by Andy Warren, with Brian Knight and myself helping to implement it. The idea was to bring a conference experience to many people that would not otherwise get the chance to attend an event like SQL Bits, the Data Platform Summit, or the PASS Summit. The idea was to help the local communities run their own events.

    This succeeded beyond my wildest dreams, and I look forward to continuing this work. Whether under the SQLSaturday.com domain, DataSaturdays.com domain, or something else, I hope that these events not only continue virtually,  but that 2021 will see some live events in physical locations.

    In order to do that, I do think that some sort of organization is needed to help steer and manage the branding and common tools. Many organizers not only appreciate, but need help in running events. My view is that this organization needs to be open and transparent, unlike how the SQLSaturday brand was managed in the recent past.

    My hope is that a non-profit organization, with transparency, is formed and can manage any assets in a way that prevents a dependency on any individual or commercial organization. I would envision this as the following public characteristics:

    • open proposals from the community or board of directors
    • open discussion and debate of proposals
    • timely and open voting on issues by the board of directors
    • open source tools that enable event coordination and execution
    • open books of any and all financial details*
    • public guidelines, with limited rules or requirements for association with the brand
    • flexibility to allow organizers to run events in a variety of ways.

    There are many details to be worked out, and certainly many concerns from the previous way in which the PASS organization operated, but I am confident there are ways to continue to promote and advocate for local events.

    Local and Virtual Chapters

    Most local chapters have operated very independently with few dependencies on PASS, and I expect they will continue to do so. I do hope that they maintain connections with each other for mutual assistance and knowledge sharing.

    I would recommend that chapters ensure they have a mailing list that is accessible by at least two individuals. I would also say that they should ensure they have a public website. There are a few options available from different sources if anyone does not wish to manage their own. Please sign up with one or both of these.

    I would encourage user groups to also register their meetings with https://callfordataspeakers.com/ to help them find individuals that might present at their meetings.

    Andy Warren has other thoughts, and I would encourage chapter leaders to read and share them.

    Speakers

    Many speakers maintain their own schedules, lists of resources and more. The growth of many speakers and their willingness to present at events all over the world has been one of the incredible things that came about as SQL Saturdays grew and spread. I hope this continues, and that means speakers need to continue to find opportunities to practice and deliver their sessions.

    I would encourage all speakers to do the following:

    In addition, everyone should ensure they have a place to share code and Powerpoint/PDF/session materials. I have seen many options, and these are good options:

    • A blog (WordPress or otherwise)
    • OneDrive/Box/DropBox/etc.
    • GitHub repos/pages
    • YouTube – Save recordings of your sessions

    There are many ways in which people share, and I would certainly encourage speakers to share their own methods that others might learn from and implement on them.

    A Final PASS Chapter

    I’ve seen a few people write about the end of PASS and the future (Andy, Andy, Tim, Brent, and more). I’m disappointed that there isn’t an organization (right now) that promotes things, but I am glad PASS ended. It hasn’t been run well or with a primary focus on community good in a long time.

    Hopefully we can move forward in new ways that improve on what we’ve had and continue to drive the community forward.

    * I do recognize that the timeliness of financial disclosures can be difficult at times, but any and all filings, revenue received, and expenses incurred should be available.

  • Improving Availability Groups

    Availability Groups (AG) were introduced in SQL Server 2012, with the idea that we could dramatically improve (and ease) the burden of dealing with high availability in SQL Server. At the time the (code named) HADRON technology seemed full of possibilities.  Since then, there have been some enhancements, but it seems that setting up and managing an AG, especially across subnets, isn’t as simple as Microsoft would have us believe.

    One of the problems with AGs is that there are non database resources (logins, jobs, etc.) that create dependencies. Working around the issues is a headache for many administrators, and it shouldn’t be. While there are some enhancements potentially coming, I don’t know what shape these will take or if they will make things easier.

    Some of my previous work as a DBA relied heavily on SQL Agent and jobs, neither of which are handled by AGs, or by plenty of other HA/DR technologies. Instead, administrators cobble things together, save scripts, and manually repair issues after failover. To me, this is one area that I’d hope Microsoft enhanced for AGs.

    Another area is the listener, which seems to be brittle. It works great, or it’s a nightmare to get working, without always an easy way to debug. I’d certainly welcome improvements here, including the ability for tooling to support multiple listeners easily.

    Many of you work with AGs now, and many more of you may in the future as the need for HA grows all the time for databases. Are there improvements you’d like to see in AGs, or any other SQL Server HA/DR technology? Feel free to leave a comment or submit something to Microsoft.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

  • Daily Coping 15 Jan 2021

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

    Today’s tip is to find three good things to look forward to this year.

    I’m going to reach here, and not pick things I am sure will happen. Instead, I’ll be aspirational and choose some things I am hopefully will happen.

    First, I want to get back to the East Coast and see my Mom and brother. I have planned 3 trips out there, with my brother planning one out here, all of which were cancelled in 2020. I’m confident I’ll find out how to do this in 2021.

    Second, I think my daughter will get to compete in volleyball next fall, and I will get to take some trips to watch her play. I’m more confident in the former than the latter, but I’m looking forward to doing both.

    Third, I’m looking forward to visiting some parks and wilderness this summer. While I would like to travel somewhere, we are already making plans with friends for some trips in our camper with horses. We had hoped to get to Utah last year, or somewhere else, but didn’t go anywhere other than Mt Rushmore National Park. I am assuming my travel schedule is paused through summer, so I’ll have more time for trips.

  • Daily Coping 14 Jan 2021

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

    Today’s tip is to learn something new and share it with others.

    I do try to share things, and years ago I added tips, tricks, etc. to my blog. I’ve gotten out of the habit, but I changed that recently. I took the time to share something I learned.

    The rear hatch on my X5 stopped latching. In fact, I was driving back from the store and saw the interior light on in the trunk. When I got home, I couldn’t get it to close. I ended up taking some time to find the issue and repair it, but then I took a few pictures and added a blog entry.

    Hopefully it will help someone else.