Voice of the DBA

Author: way0utwest

  • Schema Filtering in SQL Prompt

    I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue to make in the product. One item that I found interesting recently was schema filtering. This post takes a quick look at this feature.

    If I go to look for an object, intellisense is amazing. In this case, I’ll type “SSF <tab> cust”. I’ll see this:

    2020-02-27 15_03_37-ObjectDefinitionBox

    There is the customer table first, and as we see on the right, this is the dbo.customer table. Below this, we see there is a Customer table in the ETL schema and two CustomerLoad tables, which are in two different schemas.

    I might actually be working in one of those schemas. Let’s say I’m an ETL developer. I don’t want to accidentally be coding against dbo.Customer when I want to use ETL.Customer. Certainly I might need each one, but in this case, I might just care about loading stuff into the ETL schema and want to work there.

    I can add filtering in SQL Prompt by going to the Options and then the Connections section. As you can see below, I have a drop down for schemas.

    2020-02-27 15_05_03-SQL Prompt – Options

    The default is all schemas, in all databases, but I can change this. I can set a filter. In this case, I’ll choose the “Only load…” option. When I do this, I see a generic wildcard here.

    2020-02-27 15_06_45-SQL Prompt – Options

    I see schemas for all servers and databases. However, I can set filtering for a specific server and database. Or a database on all servers, or certain servers, but all databases. Here I’ll just edit the schema.

    2020-02-27 15_06_05-SQL Prompt – Options

    This will change behavior to only show the ETL schema in all databases on all servers. Now when I type the same thing, I see the ETL schema objects only.

    2020-02-27 15_08_32-ObjectDefinitionBox

    Good, right? Plus, the refreshes and loads are faster. The downside here is that in another database, I see no tables.

    2020-02-27 15_09_14-CandidateList

    I can fix this, and just look in that one database by entering the database name. I’d suggest you set this by server and database, just so you are clear what behavior is happening, but it’s up to you.

    This was a request from developers that do work in some large schemas, and only want to see those objects. It’s been added to SQL Prompt, so update today, upgrade, or download a trial and give it a try.

  • Back from My Sabbatical

    It’s been six weeks away from work, but I’m back now. It was a great break, I’m refreshed, and I am ready to get back to writing, speaking, and working with the data platform again. I haven’t done much SQL Server work, but I have been busy. With this being my first day back, I did spend a few minutes looking back at what it was like to have a voluntary, extended break from work.

    The time away was very refreshing. I was able to spend days on my own personal growth in a few areas as well as tackle personal projects that my wife and I have wanted to do around the house. I avoided the computer for the most part, only using it for personal tasks, like watching guitar videos on YouTube. I used my hands often, rarely sitting at a desk.

    At the same time, this was an enlightening break. I realized I enjoy my job, and I enjoy technology. During a two day stretch near the end of my time away, I attended a conference and spoke. I engaged with other technologists and realized that I really enjoy working with and talking about databases and technology.

    I am ready to go back to work and looking forward to what 2020 brings to my career. I’ve missed Redgate, and I’ve missed interacting with many of you on a daily basis.

    Perhaps the best part of the sabbatical was that it have me a glimpse of retirement. I puttered around the house, did things I wanted to do, at my pace, without pressure. I handled it well, though I also think I do need a little more purpose or focus when I do retire.

    It was a good break for me, and I’m looking forward to the next sabbatical in a few years. In the meantime, I’m ready to get back to writing and speaking and SQLServerCentral.

    Thanks to Kathi, Kendra, Grant, and the others at Redgate for covering my work while I was away, and I hope everyone out there enjoyed their stewardship if the community.

    Steve Jones

     

  • Day 32, Sabbatical Part Deux

    This is the last post of my second sabbatical, covering the last few day so of week 6. I got sporadic near the end, for a few reasons, but this looks back at days 29, 30, 31, and 32.

    Day 29 was a bust. After finishing up at the Oracle conference on Day 28, I felt sick. I woke up worn out, with a running nose. I ended up staying in bed all day, playing a little guitar, but mostly just sleeping and trying to get better. It helped, as I felt OK for Day 30.

    Day 30 came with a lot of snow. It covered the property, and while no cars were stuck, it was a mess. Friday’s are my wife’s day to feed, and I agreed to help and try to dig things out. I ended up going through and trying to plow out some of the property. I got a bit done, but some was too covered. As a result, we ended up putting out large bales. That means I start here:

    20200221_120129_HDR

    and end up here:

    20200221_120937

    Then I drive this out to somewhere and leave it for horses to eat from. I joked with a few friends on Facebook that not only is this a skill I never expected to learn, it’s one I never knew existed.

    I ended up spending about 3 1/2 hours on the tractor trying to get things cleaned up and organized, including moving snow on the driveway to ensure my wife could get out Saturday morning with a trailer.

    From there, a little yoga, coaching, and then finally an evening out with my wife watching George Lopez.

    The weekend and Days 31/32 were spent in the mountains. My son and I got up early Saturday and drove up to snowboard. We had a great time on a rather warm day, going up and down at Keystone.

    20200222_121314

    We then retired to a house that my sister in law had rented for a week. She’s on vacation, and we went to spend time there. It was a beautiful place, and we enjoyed it.

    20200222_165107_HDR

    Everyone arrived Saturday night or Sunday night and we ended up with about 7 of us spending time there. Monday and Tuesday were very cold (around 0F) and windy, so we didn’t ski. Instead, it was good to catch up with family and friends. Rather than working at all, I enjoyed the last two days of my sabbatical with a relaxing morning each day. I cooked breakfast for everyone, which is relaxing and enjoyable for me. I also did one dinner.

    20200224_092104_HDR

    The days were spent talking, laughing, playing games, and wandering around Breckenridge doing a little shopping and eating. A bit too much indulgence, but I’ll get back to the routine now and improve the diet and exercise time.

    I wished I had brought a guitar, but it was a good time, and very relaxing.

    Day 1 back at work was getting up early and driving home.

    That’s it for my time away, and I’ll summarize a few things in another post. A few thoughts in today’s editorial, but now I’m looking forward to the next sabbatical in about 4 years.

  • DevOps Deja Vu with Oracle

    While I was out on sabbatical, I took a two day break to attend an Oracle conference and speak. The Rocky Mountain Oracle User Group Training Days 2020 was held a week ago a little North of Denver and I was there to speak about DevOps.

    In many ways, this was similar to the talks and discussions I’ve had with SQL Server developers and DBAs across the last seven or eight years. What was different, and fascinating, is that most of the Oracle people were in the place that lots of you SQL Server people were about 3-4 years ago.

    Not that we’re all in the same place, but between the work I’ve done with Redgate and the messages from Microsoft, many SQL Server users get the idea of better development and now are trying to work out the mechanics of implementing things. In the Oracle world it seems that many people are still trying to decide if they should change any development practices and what options are out there.

    It wasn’t just me. I watched 3 other DevOps talks and they all were similar. The message was more on what DevOps can mean and how it changes your work building software. In the MS world, we’re more often focused on the mechanics of specific ways to move to a more DevOps style work environment.

    Redgate is moving to release more tools for Oracle and other platforms, and we’re evolving the way we build these tools to help more groups. I’m looking forward to spending more time with Oracle procs and brushing up a little on my PL/SQL skills.