Voice of the DBA

Tag: syndicated

  • Daily Coping 14 Sep 2020

    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.

    Today’s tip is to notice the things you do well today, however small.

    I live on a horse ranch, and there is never a shortage of work. While I do enjoy the break from sitting at a computer, I’m glad I don’t do that type of work every day. It’s hard, and gets harder on my body every year.

    There’s something strangely satisfying by accomplishing a physical task well. I take a lot of pride in being able to build software or deliver a presentation online, but it feels ephemeral.

    Shoveling a stall clean, or some other mindless task brings me a good sense of accomplishment. Yesterday, this was fixing fence. We have vinyl wires for horse fence, and those will break at times. It’s not hard to fix them, but it does take some attention to get a new line spliced in and tight.

    I planned on fixing a couple spots I’d noticed while feeding Saturday and ended up finding 3 more. I think I did a good job, since my wife noticed the fence was whole Winking smile

  • Daily Coping 11 Sep 2020

    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.

    Today’s tip is to plan a fun relaxing activity for this weekend.

    Weekends have been quiet, but they’re getting busier. I have some fall chores and volleyball coaching keeping my busy this weekend. I also have some holiday next week, and I’ll do something those days.

    For this weekend, I’m going to try and plan a night out with my wife, likely a socially distanced dinner, and maybe a walk along the river or local trail in our area. Something fun, easy, and without a lot of effort.

    Date night is always a relaxing thing for me.

  • Daily Coping 10 Sep 2020

    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.

    Today’s tip is to focus on the basics: eat well, exercise, and go to bed on time.

    I believe in self-care. I’ve pushed myself without regard for my own well-being at times in my life, but I do it less and less, especially for work. As my wife has said many times, the things we do in technology usually aren’t “saving babies.” We’re pushing bits around for profit, and we don’t necessarily need to go above and beyond constantly.

    Balance is important here. I try hard to take care of my physical body, my mental health, and my relationships, with efforts to reach out and touch base with those I care about. Each of those takes work, and in 50+ years, I’m still working out how to do this.

    I’m better at taking care of my physical body. Not great, as my diet isn’t anything special. I’m a comfort eater, and I like food. However, I am working through being better more often than not.

    For me, as I write this, I had a good day yesterday. Cooked some food at home, making reasonable choices for ingredients, limiting portions, and balancing different types of food. I drank lots of water, and I hit the pool for one of the last times this year.  I didn’t stay up late, relaxing with my wife and watching a little TV and getting to sleep at a reasonable hour to let me get 8 hours of rest before work.

    I’d like to think I do this more often than not, which is good enough for me.

  • FILESTREAM v FileTable –#SQLNewBlogger

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

    I was really interested in the FILESTREAM technology when it came out. Unfortunately, the access from only Win32 APIs made this a pain for many people. I get why this is needed, but without having some tooling to make it easy to add/edit/delete blobs.

    In SQL Server 2012, we got FileTable, which simplified development and allowed everyone to easily get data in and out of SQL Server.

    This post looks at a few differences between the technologies.

    FILESTREAM is essentially a folder surfaced as a column in SQL Server. You can create a filegroup to hold FILESTREAM files, and these are paths. The path is managed by SQL Server, and when you designate a column as containing FILESTREAM data, a new folder is created.

    None of that matters, as you should NEVER go to these folders, but this is also how some other things in SQL Server  (like In-Memory OLTP) also work.

    Access to this data is with a Win32 API, and it’s semi-complex. Not hard, and really you can use the sample code (with some additional error handling) to do the work you need. On the application side, you need to do some stream handling and manipulation, but that’s really not difficult. It can be cumbersome, but it’s easy.

    FileTable was an additional layer that gives you SMB, or Windows Explorer, access to the data in the FILESTREAM column. Except, you can’t make a FileTable column, you create a FileTable, which has some restrictions, limitations, and required columns. You can add some things to the table, but really you want your FileTable to be a vertical partition of your regular OLTP data. Separate out the blob stuff from other items in your entity.

    Both save your data in database backups, both are more efficient for semi-large blobs moving in and out of SQL Server.

    Neither works in the PaaS cloud, though they could. I’d hope that FileTable especially would be added, with some enhancements to smooth the way a FileTable is structured, ubt I think with the focus on database level technologies (contained in a db), this technology is likely never getting any enhancement.