Voice of the DBA

Tag: syndicated

  • A Byte of Redgate

    When the global pandemic shut down much of the world, we started the Community Circle at Redgate, with the idea that we would try and help others cope with the challenges of being stuck at home the vast majority of the week. There have been a number of efforts, many around learning, but also some other non-technical, non work related items. One of those was released recently.

    front-cover-212x300A Byte of Redgate is a cookbook with recipes from our employees and Friends of Redgate. You can read the story in this blog, and I’m excited to be mentioned. Andy Warren, fellow SQLServerCentral founder, mentioned that a cookbook would be a fun corporate project. I suggested it at one of our meetings and it turned into reality.

    You can download your free copy in pdf and epub formats now and try some new dish.

    I’ve found cooking to be a nice, relaxing, coping mechanism from the blandness of everyday life. I am trying out new recipes every week and enjoying the time with family that hasn’t had many evenings together as my kids have grown into adults.

    Whether you like cooking or not, pass along the link to those that do, or that you might want to make something for you. I’m looking forward to trying a few of the dishes for my family in the coming weeks. These are on top of my list:

    • Banana Bread (gluten free)
    • Tomato Soup Cake
    • BBW Chicken Shawarma Wraps
    • Charlott’s Kofta Curry
    • The Fussy Eater Frittata

  • Daily Coping 21 May 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 find a way to craft what you are doing to give it more meaning.

    I do a lot, both at work and on the ranch. One of the things that I do regularly is cook dinner. While my kids can cook, they don’t do it much. My wife doesn’t like cooking at all, but I enjoy it. It’s a relaxing exercise for me most nights. Sometimes I need a break, but most times I enjoy it.

    I am trying a variety of things since it’s one of the few places we can get some routine as a family. With kids in school (teaching or learning) and days full of similar activities, I’ve been trying to build some routine in cooking. A few things I’ve tried:

    • mixing gluten free and non gluten free meals
    • often having a veggie/fish main with a meat one
    • doing some favorites everyone has enjoyed once or twice a week
    • trying a new recipe at least once a week

    With a mix of preferences and diets, it’s an interesting challenge. Often I combine some things and separate others. For example, I made spaghetti squash enchilada boats. My wife and son got plant based ground meat in theirs, while my daughter and I got chicken.

    I’ve also added in some once a week baking. I’m not trying to gain weight, but a sweet treat is a nice thing periodically, so I’m doing a bit here and there.

    A small thing, but it’s become more meaningful as our lives slowed down slightly and we’re all together.

  • Connecting to SSAS–#SQLNewBlogger

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    In a previous post, I installed SSAS on a machine. Now I need to connect to it. This post covers a quick, how do I do that.

    Do connect in SSMS, you can use the Object Explorer. If you click the down arrow on the Connect button, you’ll see choices.

    2020-05-04 10_18_51-

    If you pick SSAS, you get a similar connection dialog. The SSAS instance is named the same as your base instance. In this case, I had a named instance, so I enter the same name as I’d use for the database engine.

    2020-05-04 10_18_59-Connect to Server

    There’s not much to see, but I’m connected. My installation is working.

    2020-05-04 10_19_15-SQLQuery4.sql - Plato_SQL2017.way0utwest (PLATO_Steve (89))_ - Microsoft SQL Ser

    I could also connect with  a query window. The toolbar has a couple choices.

    For MDX:

    2020-05-04 10_22_04-SQLQuery5.sql - Plato_SQL2017.way0utwest (PLATO_Steve (54)) - Microsoft SQL Serv

    For DAX:

    2020-05-04 10_22_19-SQLQuery5.sql - Plato_SQL2017.way0utwest (PLATO_Steve (54)) - Microsoft SQL Serv

    For either one of these, the connection process is the same.

    SQLNewBlogger

    After the post where I installed SSAS, I needed to test it. Rather than add that to the post, I ran through the steps, grabbed sceenshots, and then wrote this post as a second one.

    Focus on one thing, not multiple things, in a post.

  • Daily Coping 20 May 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: Hand-write a note to someone you love and send them a photo of it.

    A good idea. I haven’t written a letter in a long time to anyone, but I have been reaching out to people randomly to check on them. I decided to send a note to someone I know, but haven’t seen in a few months since the lockdown. I was looking forward to seeing this person in late May, and a few times in April, and didn’t get the opportunity.

    It’s a private note, so nothing here, but it was a good exercise.