The IIF operator is one that I use. Honestly, that's more because I've used it in MS Access and VB.NET.

At a PowerShell prompt when I run

sqllocaldb info mssqllocaldb

I get the following response:

Name: MSSQLLocalDB

Version: 15.0.4382.1

Shared name:

Owner: TARDIS\rodf

Auto-create: Yes

State: Stopped

Last start time: 1/8/2025 6:55:04 PM

Instance pipe name:

It looks...

• This reply was modified 1 week, 3 days ago by  Doctor Who 2.

Merry Christmas and Happy New Year!

WOW, I thought I had responded to this earlier this morning. I guess I failed to respond and some of my thoughts are now lost. So, here goes a shorten...

Thank you, Steve and Bob, for reminding me to have grace towards others who are having a rotten day. Like you said, I've no idea what went wrong to cause...

I don't know what to think of this advice. In my state government job, the IT division (I'm including both operations and developers) is about 200 people. As far as...

What I fear the most is TurboTax. The instructions on TurboTax is sometime ambivalent. It normally takes me a month to finish doing my income taxes, because I have to...

I did perform a backup of the database. That created the .bak file on my laptop, which I copied to my desktop. There I tried to perform a restore, but...

Thank you, Grant, for responding. I am using the SSMS graphical UI. Here's what it looks like in SSMS:

Is it the LogBackup that I've messed...

Scalability or popularity first? From what I've seen its popularity first, but who's popularity are you looking for? From my point of view, it is an upper-level manager whose popularity...

I can think of a complex solution which, in my estimation, is overkill. At work we started on a project of rewriting an old Microsoft Access application, into a WPF...

I've known about observability for a while now, but still struggle to get my head around it. Especially how it is different from monitoring. I look forward to this series...

I like your suggestion, Steve. I've been wanting to rewrite this app for many years, as it has so many weird things about it. Concerning just the database, the people...

Thank you, Steve, for the link!! Now I've got something to read and begin thinking about how to use it in my career.

The issue of cloud transformation is an important one to me. The organization I work for doesn't really have any cloud presence. During the pandemic, we obviously had to try...