Daily Coping 10 Aug 2022

Posted on August 10, 2022 by way0utwest

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 be kind and supportive to everyone you interact with.

An easy one today. I’m in Redmond, at VS Live, with the chance to smile, be kind, and helpful to everyone. I am writing this ahead, but I have a reminder to go out of my way today to follow this tip. From service personnel, to attendees, fellow speakers, and even other guests of the hotel.

2022-08-04 12_44_28-Calendar - steve.jones@red-gate.com - Outlook

Posted in Blog | Tagged , , | Comments Off on Daily Coping 10 Aug 2022

Daily Coping 9 Aug 2022

Posted on August 9, 2022 by way0utwest

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 send an uplifting message to someone you can’t be with.

I travel a lot, but I still don’t see as many people as I’d like, or see them often. I’ve been very lucky in life to meet so many people all over the world and have great moments with them.

There are plenty of people I can’t be with in the short term, but one of them is my brother. I’ve got a busy fall and not sure if I can find time to get out there, so I sent him a note to remind him I’m thinking of him and wishing him well. It was good timing, as the next week was his anniversary, so I got a reason to send another uplifting message.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 9 Aug 2022

The Conference of the Year–T-SQL Tuesday #153

Posted on August 9, 2022 by way0utwest

tsqltuesdayIt’s the second Tuesday of the month and it’s time for T-SQL Tuesday. This one is hosted at my request by a good friend, Kevin Kline. Kevin has been a large part of the #sqlfamily as a speaker, teacher, educator, friend, and driving force for PASS and the annual Summit conference.

This invitation is asking about a conference or event that changed your life, that created an opportunity, or just changed your life. Career, other otherwise. It’s a great topic, and it’s one reason that I am running SQL Saturday. Events and interactions with others can change your life. It did for me, and for many others.

1999

This year always stands out as a reminder of Prince (RIP). However, it was also the first year I lived in Denver. I moved out with my wife and two kids to work at a financial services firm. That summer I saw an advertisement for a new professional group, the Professional Association for SQL Server. They were having a conference that October in Chicago. I asked my boss to go, they agreed, and I made arrangements.

Two things stand out to me. First, my wife, sister-in-law, and toddler son came. We went to the last baseball game of the year at Comisky Park. My wife and SIL  also smoked cigars with me in the hotel bar. A memorable fun trip for me.

The second thing that stands out is that I met Kalen Delaney there. I’d read her Inside SQL Server book and watched her talk. Afterwards I went up to the stage and asked a question and shook her hand. An exciting moment for a young data professional at the time, and one that spurred greater interest in learning more about SQL Server and becoming a better DBA. I’ve also been honored to know Kalen and meet her at many events around the world since.

That event kick started me from being just a DBA to being someone that wanted to be involved with the community, that believed I could speak in front of people and teach them things, and I could help my career by attending other events.

Conferences and Career

Most years I attend 10-20 conferences and speak at them. I may attend a few others and not speak, and I usually have a few internal or Redgate run events. I’ve very lucky, and I enjoy getting to visit interesting places in the world as a part of my job.

While I pick up technical bits and might get an idea for how to solve a problem in code, the most valuable parts of conferences are talking with other people and networking. Yes, networking, which is really just shaking a hand and answering a question. Or shaking a hand and asking a question. Or even commiserating with someone next to me about how some technology doesn’t work. Sometimes those last conversations are the most memorable and enjoyable.

This networking is incredible and I’m amazed how I hear about different opportunities. Even before I ran SQL Server Central, talking to people at events drove my career forward.

Whether you go to a user group meeting, a local SQL Saturday, or a larger paid conference like the PASS Data Community Summit or SQL Bits, if you make an effort to chat with people, interact, and take notes, I think you’ll find it as invaluable to your technology career as I have.

Getting Involved

The last thing I’d note is that I run SQL Saturday as an independent, US charitable 501.c.3 corporation, independent of Redgate. I’ve found user groups to be great, but hard to manage every month. When Brian, Andy, and I set up SQL Saturday, we did so to bring local conferences to people whose employers might not pay to send them to Ignite, the PASS Summit, or other expensive conferences.

I would love to see more SQL Saturdays in more places in the US. It’s not that hard to run one, and you don’t even have to speak in front of a crowd. If you’re interested, ping me at admin@sqlsaturday.com.

Posted in Blog | Tagged , , , | Comments Off on The Conference of the Year–T-SQL Tuesday #153

Working with Neo4j Imports–I HATE CASE SENSITIVITY

Posted on August 8, 2022 by way0utwest

I’ve been working to better understand graph databases and where they can be useful.

There is a file from Neo4J that comes with the Desktop and contains a data export from Northwind. This looks like this when you open it:

2022-08-02 16_24_48-employees.csv - Excel

On the page where Neo4j talks about the employee imports, they have this code:

// Create employees

LOAD CSV WITH HEADERS FROM 'https://gist.githubusercontent.com/jexp/054bc6baf36604061bf407aa8cd08608/raw/8bdd36dfc88381995e6823ff3f419b5a0cb8ac4f/employees.csv' AS row

MERGE (e:Employee {employeeID:row.EmployeeID})
   ON CREATE SET e.firstName = row.FirstName, e.lastName = row.LastName, e.title = row.Title;

This loads fine.

When I run this code, it works. When change to this, it fails. It’s erroring out on my file. I tried moving the file, removing nulls, etc.

LOAD CSV WITH HEADERS FROM 'file:///employees.csv' AS row
MERGE (e:Employee {employeeID:row.EmployeeID})
ON CREATE SET e.firstName = row.FirstName, e.lastName = row.LastName, e.title = row.Title;

Here’s the error in the Neo4j Browser:

2022-08-02 16_35_03-neo4j@bolt___localhost_7687_neo4j - Neo4j Browser

I kept editing the file and trying different things. I compared what I had locally with what was on GitHub. Eventually, I realized this is the issue:

{employeeID:row.EmployeeID}

In the GitHub csv, the first row has headers with EmployeeID. In my local file, the header is “employeeID” (lower case). As soon as I edited this, it worked.

THIS IS THE FILE THAT CAME WITH NEO4J DESKTOP.

They make mistakes, just like I do. I hate that there are too many things like that that are care sensitive. I get that sometimes you want data to be in a particular format, but I think in the modern world, making metadata case sensitive isn’t productive.

Posted in Blog | Tagged , | 3 Comments