Summarizing a Script with SQL Prompt

I have never used this feature, but someone was asking for feedback on Prompt, and I noticed  this in the menu: Summarize script.

prompt_summary_a

I had guessed that it might look at the code and give me some outline, which is what it does, but I wasn’t sure how it might work. I decided to try it on a few scripts.

I had a demo script for a customer, and I ran it there. I got what I expected, an ordering of various operations.

2021-03-12 08_10_22-SQLQuery1.sql - ARISTOTLE.sandbox (ARISTOTLE_Steve (65))_ - Microsoft SQL Server

Useful in some sense. I can see I cleaned up the CREATE with the DROP. However, I could also see that easily if I looked at the script. Depending on length, this might be helpful to remind me or let me see if I’ve dropped all the code I expected.

I picked a longer script from some of the Advent of Code stuff I’ve been slowly working on. In this one, there is some looping, as it’s a looping type of problem (to me). In this case, I see something more complex.

2021-03-12 08_14_16-day3.sql - ARISTOTLE.AdventofCode (ARISTOTLE_Steve (57)) - Microsoft SQL Server

Not a lot of information from the SELECTs, but I do see some looping. The actual code is a bunch of math changes, and I could have used SET, which might have helped here. This let’s me see that the code is more of a procedural construct, which looks like this:

2021-03-12 08_14_51-day3.sql - ARISTOTLE.AdventofCode (ARISTOTLE_Steve (57)) - Microsoft SQL Server

What about other types of code? I looked at a CTE, which wasn’t that helpful. I can’t see the base tables here, which isn’t useful.

2021-03-12 08_16_26-SQLQuery1.sql - ARISTOTLE.sandbox (ARISTOTLE_Steve (61)) - Microsoft SQL Server

However, in AdventureWorks, there is a procedure that shows me a TRY CATCH. In a long set of code, this might help me make sure I’ve actually included the CATCH, among other things.

2021-03-12 08_17_41-SQLQuery5.sql - ARISTOTLE_SQL2017.AdventureWorks2017 (ARISTOTLE_Steve (61)) - Mi

I’m not sure how useful this feature is, but it’s now in my mind to try a few times and see what I think. What is the outline and structure of my code.

If you have other ideas, I’m sure Redgate would appreciate suggestions. Otherwise, give it a try and let me know if it works.

If you don’t have SQL Prompt, it’s an amazing developer productivity tool, and we now offer it as a subscription, so you can try it for a bit longer than than evaluation without committing.

Posted in Blog | Tagged , , | Comments Off on Summarizing a Script with SQL Prompt

Daily Coping 17 Mar 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 get outside and notice how the weather feels on your face.

While I live on a ranch, there are days that I don’t really go outside. I might work most of the day and then get in the car to go to the gym, but I sometimes forget to step outside.

However, this is Colorado, and we are blessed with amazing weather the vast majority of the time. We have over 300 sunny days a year, and that’s a big part of why I moved here.

Last weekend we had a big snowstorm. While it wasn’t what many could call the best weather, it was nice to go outside, even in some wind, and feel the weather. A cold winter day, snow falling, not miserable, but a refreshing day.

I could feel flakes drop on my cheeks, the wind chilling me where skin wasn’t covered up, but warm inside a coat, ski pants, hat, and gloves. My lungs opened up, I breathed hard while walking around and feeding some hay.

A good day to be alive.

Posted in Blog | Tagged , , | 2 Comments

Daily Coping 16 Mar 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 take a full breath in and out before you reply to others.

I used to respond quickly, sometimes even talking over others. I don’t know that I did this more with women than men, but I’ve tried to be more aware of this. Everyone deserves respect, but more importantly, I ought to be sure I listen more to others and hear what they are saying.

Recently I got a few messages across Slack while on holiday. I didn’t really check them until I returned, and even then, I interpreted them one way. I got a meeting request later that implied I had committed to something in Slack, which I didn’t think was correct.

It would have been easy to start complaining and get upset. Or just decline the meeting and refuse to do something. Instead, I took a deep breath, let go of annoyances, and responded in a positive manner. The other person wasn’t trying to be difficult, and as part of being more reasonable and understanding, I tried to remember that.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 16 Mar 2021

Rebuilding SQL Saturday–Picking a Board of Directors

With Redgate planning to donating the SQL Saturday brand, trademarks, and domain to a non-profit foundation, there is a need to build a group of individuals to voluntarily manage the organization. Redgate has tasked me with the initial work, and as I work through this process, I am looking to provide some transparency into how this works for now.

NOTE: This is for the initial board, as someone has to make the first decisions. I expect the board themselves to decide how future directors are chosen, with input from the community.

There are a lot of people, including myself, who have been unhappy with the way that the previous organization’s board of directors functioned. The combination of a contracted managing director and restrictive bylaws resulted in far too little transparency over the years. At least, that is my view.

Moving forward, my vision for the foundation is to not recreate an organization that mandates, but rather serves the community, in an open, transparent way. There should be a minimal budget, and no compensation for directors, and no full-time staff.

I am trying to think aloud here, as I work through this process. None of these items have been decided, and I welcome advice and thoughts from others.

I also welcome interest and nominations. If you are interested, please leave a comment, or contact me. If you think someone else deserves nomination, please contact them first and ask them to contact me. I do not want to pressure anyone to serve that might not wish to or be able to donate time.

Qualities for Directors

I want to outline a few things that I think are important in finding individuals that can serve the foundation and steer it into the future.

Transparency

One of the things that bothered me with the previous organization is that there was not enough guidance on what directors would do on a regular basis, and certainly not enough information on what they had done. To me, this means that one of the main qualities for anyone serving this foundation is that they freely and willingly share information.

My goal is that as close to 100% of debate and discussion, as well as financial information, be publicly available.

Diversity

Much of my career has been US focused, though that has really changed in the last decade. When we started SQL Saturday, we didn’t think about the world outside the US, but many events under the SQL Saturday banner have been outside the US.

We need diverse thought on the issues that organizers and events face.

This means a diversity of not only geography, but gender, race, orientation, and more. We need to understand that each of us only sees a small portion of the world, and only from our perspective. With that in mind, I aim initially aiming for a breakdown something like this:

  • US – 3-4 directors (knowing I am representing Redgate, 1 of these spots is filled)
  • EU – 2-3 directors
  • APAC – 2-3 directors
  • Rest of world – 1-2 directors

I would like to have a number of women on the board, as I truly value the different perspectives they bring. I’d also like to have someone of a different race, ethnicity, or orientation than myself.

If you know of someone that you feel fits this goal, please ask them to contact me.

Financials

I have read Steph Locke’s Lessons learnt on the PASS Board, which I think anyone who cares about this should read. She outlines a number of items, which are important in most boards. While I think that the need to fund the organization is important, when this is the main goal, this becomes a problem. Directors should have some business sense, having either run their own company, or served as a high level executive in some company, however large or small, so that they do treat financials with the appropriate importance.

The goal of this foundation is to run itself on less than US$10,000/year. Any sponsorship funds will go towards events, not expenses.

Community Drive

This foundation will exist to further SQL Saturday events, providing resources and assistance where possible. Directors should be oriented towards doing good for others by supporting education and networking, giving back to the world, and driving events forward. While they will not do the work, they will be the voice and inspiration for many through this foundation.

A director ought to be thinking: how do I get more organizers excited enough to create an event? How can we better support speakers? How do I attract and serve attendees to learn and grow their careers? How can we ensure events feel successful, whether physical or virtual, whether there are 50 or 500 attendees, whether there is one track or 12?

These are the goals of the foundation.

While I started my list thinking about people that are thoughtful, measured in their words, and giving of themselves, that was really the bar of what I was looking for. Finding other qualities outside of these are likely more important.

Candidates

I have asked a few people if they are interested, to start getting a short list together. Ultimately myself and a few at Redgate will have to make some decisions about who to choose. We’ll appoint an initial board and then let them run the foundation as they see fit, including deciding on how the next set of directors are chosen.

I haven’t named any names, as I’m not sure it’s fair, and I don’t want to put any pressure on anyone.

If you are interested in shaping the future of SQL Saturday, please let me know. I have a list, but I’m sure there are people I haven’t considered. If you think someone is a good candidate, encourage them to contact me.

Above all, remember this is a community first effort, and we’re looking for people that feel the same way.


Posted in Blog | Tagged , , , | 18 Comments