Voice of the DBA

Tag: syndicated

  • Windows 11 Complaints

    I upgraded my primary laptop to Windows 11. A few people had said they liked it, I know that I needed to keep up at some point, and in the later stages of a pandemic, I thought this was the safest bet. I have a desktop I use regularly, and didn’t want anything risky there, and I have an older laptop, but it’s a 2015 era device, so I wasn’t sure that was a good idea. This was a 2019 laptop, so fairly new.

    In most cases, Windows is Windows. The task bar centers icons, and the start menu comes up in the middle, not the side. Not big changes.

    However.

    A few things I’ve noticed, which I find rather disturbing.

    Slow

    Windows 11 is slower, and often has interrupts or pauses that I didn’t have before. If I press the Windows key, the Start menu is slow to appear, and even then, loses some of the keyboard buffer. So if I type Windows+n+o+t+e, expecting notepad, I find the Start menu and “ote” or “te” in the window.

    Incredibly annoying.

    It also appears more checking online for stuff, and a poorer experience when I’ve changed networks.

    This is the most disturbing thing as it appears Microsoft has gone back to bloatware for Windows, assuming hardware gains. Windows 7 and 10 were slimmer, and felt like the OS was more hidden, understanding that it is a platform on which the software we need runs. The OS isn’t important for UI/UX most of the time.

    Get it out of the way.

    Task Manager

    Second thing is that Task Manager isn’t available from the status bar. I don’t know who thought this was ergonomically a problem, but when your Start menu doesn’t start, not being able to get Task Manager is a problem.

    In addition, I find at times the System Interrupts are using 100% of the CPU and outside of getting Task Manager up, nothing else works.

    Ugh.

    Too Much AI or MS Preference

    One of the more annoying things I’ve found is that if I look for some apps, Microsoft stuff gets in the way. For example, I will sometimes need to stat OpenLiveWriter. For some reason it sometimes disappears from my task bar where I pin it. If I try to start it, with the Windows key (pause) then type “open”, Excel is the first thing that appears. No other apps, but Excel.

    #$%##@#$#^%^

    Stop with the guessing here.

    I see similar things if I type “SQL” as the list of matching apps, SSMS + Redgate stuff, is hidden and I get the one, almost always wrong, guess.

    Overall

    I don’t see anything great about Windows 11 so far. Tbey’ve moved things, made minor additions, and likely made it easier for some users, but not for someone used to Windows that lives in the keyboard. Even finding some of the older things, like User Account names, is harder in W11.

    I wish I hadn’t upgraded. I dread the day I need to move away from Windows 10 on other machines.

  • Daily Coping 18 Oct 2022

    Today’s coping tip is to share an important goal with someone you trust.

    I’m not sharing an important goal here. Honestly, some of the things that are important to me make me more vulnerable and I really don’t want to hear criticism, comments, or even cheering. Until I move forward more, both mentally and in actuality, those things aren’t helpful for me.

    Instead, I’m sharing something that I want to accomplish with a close friend and my wife. Those are the two people that I trust to listen, just listen. I don’t need them to push me or encourage me. Just to share something that will help me think things through for myself.

    I started to add a daily coping tip to the SQL Server Central 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.

  • An Update to Skipping the Leading Digit in T-SQL–#SQLNewBlogger

    There was an interesting question in a forum, which I wrote about before. How do you skip the leading digit in a numeric value. I had looked at a UNION, but someone had a better suggestion, so I’m adding to the post.

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

    Another Predicate

    In the previous post, I used a <> and then a > and < with a UNION. Howver, someone noted that NOT BETWEEN is an option. I could rewrite the query this way:

    SELECT *
 FROM dbo.Room AS r
 WHERE room NOT BETWEEN  200 AND 299

    This gives me the same result:

    2022-10-05 14_32_43-SQLQuery6.sql - ARISTOTLE.sandbox (ARISTOTLE_Steve (61))_ - Microsoft SQL Server

    This also results in a seek.

    2022-10-05 14_33_30-SQLQuery6.sql - ARISTOTLE.sandbox (ARISTOTLE_Steve (61))_ - Microsoft SQL Server

    The BETWEEN or NOT BETWEN is sargable, meaning we can use an index to find those values that fall into this ordering and exclude them.

    Worth remembering BETWEEN when writing queries for ranges.

    SQL New Blogger

    An update to my post, showing a better way, showing I am happy to take advice from others, and I can improve code. This is a skill that employers need, especially when teams need to become more consistent with coding when working together. Showing you can adapt and grow is a good skill.

    You could write a simple blog like this that shows how you might change some code you wrote in the past. I bet it takes less than 30 minutes.

  • Daily Coping 17 Oct 2022

    Today’s coping tip is to make progress on a project or task you have been avoiding

    Most of the things I do for work are spent looking in the future. I’m always trying to prep and prepare things ahead of time because the difficulty of getting work done today for tomorrow is hard. Especially creative work.

    I’m writing this a week early, because, well, I needed to tackle something. I had been invited to be a part of a Learning Pathway at the Data Community Summit 2022. I knew this, but since I didn’t submit and plan for this, it wasn’t something I was that excited about. I enjoy the topic and talking, but I wouldn’t have picked this overview one.

    So I have been procrastinating and delaying working on this, but I realized I needed to get it done. I buckled down and took an afternoon where I worked on the deck, outlining the flow. Then another day to flesh out details and practice a first run through.

    Slow progress, but it got me moving.

    I started to add a daily coping tip to the SQL Server Central 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.