Category: Blog

  • Daily Coping 5 June 2020

    I’ve 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.

    Today’s tip is to decide to look for what’s good, even on difficult days.

    I’ve had a number of difficult days. Some days I think most people just suck. Some days, I look forward and think about how the world might improve over time.

    It’s easy to nitpick and find fault. Find a complaint. We see it constantly in social media, where someone can find a reason not to like or appreciate what many others might.

    These last couple weeks have been difficult in the US for me. As a minority, I find myself angry, sad, and generally upset. I disagree with some people over their views, their posts, their thoughts, but I also know some personally and I know they are good people.

    Our small, personal world where we shake hands, toast over drinks, and share meals is far removed from the larger issues of race, ethics, business, and politics. I try to remember that disagreement is just that, a difference of how we view things. Maybe because of some fundamental reason, maybe because of ignorance of naivety, maybe because of our experience and frame of reference.

    I can still appreciate and smile at my friends and colleagues for the things that they do well, the good, the respect, the favors, and the gentle way they behave in person.

    Even if I think they do a poor job of expressing themselves at times.

    Try to be a better version of yourself online, not a worse one.

  • Daily Coping 4 Jun 2020

    I’ve 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.

    Today’s tip is to look up at the sky. Remember we are all part of something bigger.

    I am blessed in that I have a very wide open, beautiful sky where I live. Sometimes when I’m out at night, it’s amazing how many stars I see. During the day, there’s vastness as it stretches from horizon to horizon. Here’s a recent shot of how widely I can see.

    20200525_165937

    I notice this, as it’s something I don’t get in NYC, London, or many cities, where buildings and narrow streets block views. The flatness of the land limits how far and wide I can look.

    I think that sometimes is how I view the world, getting caught up in some situation, some problem, some challenge, and I think about things from a narrow point of view.

    The world is amazingly large. Larger than most of us can imagine. The amount of people, land, money, resources, opportunities, challenges, difficulties, and more are huge. There is more that we are apart of than we can imagine.

    If you have faith in a higher power, that’s another level that is worth remembering.

    The world is bigger than any of us.

  • Creating a New Sequence–#SQLNewBlogger

    I wrote about sequences in an editorial recently and decided to start using them. Creating one turned out to be surprisingly easy.

    I had a table I’d been logging some data in, with a PK, but no natural key or identity bound to the table. Instead, this was low volume (1x per day) and I just manually adjusted the PK value.

    I decided to create a sequence. As I did this, I found it interesting and consulted the BOL page for some ideas on the options.

    The first part is simple. A name and datatype.

    CREATE SEQUENCE dbo.MyKey as INT

    That makes sense. Next, I need a starting value. In my case, I had 7 values in the table, so I added this:

    START WITH 8

    That gets me what I need. The last part I added was the INCREMENT BY clause. In my case, 1 works fine. My code:

    2020-05-09 09_33_59-SQLQuery7.sql - ARISTOTLE_SQL2017.way0utwest (ARISTOTLE_Steve (56))_ - Microsoft

    The last query is how you get the next value. The NEXT VALUE FOR phrase can be used in various places, but that’s for another day.

    If I needed to bind values, I could use the MINVALUE or MAXVALUE, which I’ll look at in a different post. I could also control caching and cycle values if I needed to.

    SQLNewBlogger

    I actually started a post on binding this to a column and then decided to add this short post in about 5 minutes.

  • An All Star Lineup for EightKB

    An online conference is coming on June 17, 2020 that is full of high level content. It’s the type of event that I think contains information relatively few people will truly understand and use, but most will find interesting. This is EightKB, a SQL Server Internals Conference featuring these speakers:

    • Bob Ward
    • Erin Stellato
    • Joey D’Antoni
    • Pam Lahoud
    • Argenis Fernandez

    That’s quite an all start lineup of speakers. Levels of content range from 400 to Insanity.

    This is put on by Andrew Pruski (T|B), Mark Wilkinson (T|B), and Anthony Nocentino (T|B).

    If you want an entertaining day of content, sign up today and enjoy the ride.