Beer Mode

David Perell has an essay on the different ways that creative people work. He calls these “beer mode” and “coffee mode”. When you are in coffee mode, you are getting things done. You have a list, and you work towards accomplishing the items on your list. Lots of us spend time in this mode every day, and often our bosses expect us to spend more of the time here. This has also been described as “closed” mode.

Beer mode is different. This is an open mode, where we are not focused on solving an idea, but rather playing with something. We are thinking widely, investigating, and not necessarily planning on getting something concrete completed.

For much of my career, I was in coffee mode. I think my ability to take a list and get things done contributed to my success in various positions. I could grind through a set of tasks, even repetitive ones, and show my boss what I’d accomplished each day. Going through a list quickly, even if slightly inefficiently, was often rewarded.

These days, I spend more time in beer mode. Not actually drinking beer, but rather experimenting, playing, thinking, and trying to find new insights into the database world, into how customers might re-imagine their use of our products, and how computing and technology can inspire the world. Those are the fun times. I still get a fair amount of coffee mode in editing, scheduling, etc., but I get more playtime than I ever expected in the past.

We need both types of working. Often we do want focus and concentration. This is where we build skills, develop strong habits, and produce something valuable. This is steady growth. However, we also need creative time. This is where we expand our minds, think outside the box, and how we grow in leaps and bounds. At least, we may. We can’t predict when we have a breakthrough or find an “aha” moment, but all of us have them, even when they are not life changing.

Some organizations are better than others at allowing some “beer mode” time at work. If your boss doesn’t think there is a need for unstructured work, maybe send them the essay above and see what they think. There might be all sorts of reasons why this doesn’t make sense every day, or every week, but I do think that having some experimental time is important for anyone doing creative work. This includes the DBAs and sysadmins trying to get your system to run better without a large budget.

Steve Jones

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

Posted in Editorial | Leave a comment

Using SQL Compare for One Procedure

A customer recently was concerned about the time to run SQL Compare for a large database. They were synching with the command line, but at times they want to just sync up a procedure or two from one database to the other.

I knew this could be done and passed along some ideas, but decided to write a post. This post looks at how to do this.

A CLI Comparison

The SQL Compare command line is pretty easy to use. Lots of switches and options, but the simple thing is point it to a couple instances and databases and get a comparison. Here’s a command line.

sqlcompare /server1:Aristotle\SQL2017 /server2:Aristotle\SQL2017 /database1:compare1 /database2:compare2

And the result. You can see below I have a table and three procedures that are different.

2021-06-09 17_31_32-cmd

If I want to limit what’s compared, I can certainly use a filter, but from the command line, there’s a simple way to see certain objects. There is an INCLUDE switch that I can use to just set a filter here without creating a file.

For example, if I want to just see stored procedures, I can do this:

sqlcompare /server1:Aristotle\SQL2017 /server2:Aristotle\SQL2017 /database1:compare1 /database2:compare2 /Include:storedprocedure:

This gives me just my three stored procedures.

2021-06-09 17_42_14-cmd

Likewise, I can also change this to a table and just get that object.

2021-06-09 17_42_33-cmd

If I want a specific object, I can get that as well. Here I use the include like this:

/Include:storedprocedure:\[GetMyTable\]

Then I get just my one object, with a faster compare. Only this one is checked.

2021-06-09 17_44_12-cmd

Then if I add the Synchonize switch, the changes will get deployed.

I often find that people are looking to deploy quickly just a known object or two for some hotfix or out of band change. Using the command line let’s me pick an object that I know about and build a comparison for just that object.

There are lots of options and ways to use SQL Compare, and I’d urge you to explore a bit as you look to improve your database deployments. If you don’t have it yet, download an eval and give it a try.

Posted in Blog | Tagged , , | Leave a comment

Daily Coping 11 June 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 out into a green space and enjoy nature.

I got to do this on holiday recently. My wife and I went to Key West, and we took a day to kayak around mangrove swamps. It was surprisingly fun, and it was neat to be in nature, quite separated from everything else. Going through the tunnels in the forest was quite an experience.

20210607_145213

Peaceful and quiet, almost like being in another world.

Posted in Blog | Tagged , , | Leave a comment

Daily Coping 10 June 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 think of three things you are grateful for this month and write them down.

In the last month, here are a few things I’m grateful for:

  • my wife – she’s supported me, challenged me, taught me, and helped me enjoy life the last month.
  • kids – they all are home for a short period, which is nice. This doesn’t happen often as they are adults.
  • health – despite getting older and things not feeling good, I’m thankful I can still do a lot of the things I want to do. Got to bike, kayak, and yoga on holiday recently, and did better than a lot of people younger than me.
Posted in Blog | Tagged , , | Leave a comment