Lee Markum's avatar

Lee Markum

@leemarkum.bsky.social

102 followers 144 following 342 posts

SQL Server geek, college football and basketball fan, and my happy place is Shem Creek in Charleston, SC. Also, I became a cat person at some point. They won me over with their cuteness.

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

That is so amazing and lovely!

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

It's a feeling of relief to get a different error!!

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Pretty cat!

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

The big weakness with Iowa that I saw in the game against LSU, and I'm already seeing it today, is they miss a LOT of point blank shots. They missed probably 10 layups against LSU. They have already missed two layups in today's game.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

This sounds awful for your little animal! Hopefully the issue can be definitively located.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Thoughts on a 32 hour work week?

thehill.com/homenews/sen...

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Good for you!

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Nice eye to notice and fix this so it's now sargable.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I think she is cold! 😀

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Thanks for the great write-up.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

For those interested in open source monitoring for SQL Server, check this out.

#sqlfamily

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Yep! I've done both of these recently!

1 replies 0 reposts 2 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Ha ha ha! Nice one! Probably some day.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

@pgrayson.bsky.social When I've used VMware, then all nodes on an AG were sized the same.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Interesting tool I didn't know about. We have cloud VMs sized differently to save money by not running the same large size on the secondary as on the primary. None of them have automatic failover enabled. I was trying to find out if others do something similar.

1 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

That's great. Query tuning is a great topic to focus on, especially as the cloud pushes tech toward managed services.

1 replies 0 reposts 2 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

And I learned that flightaware is a thing. I never had thought about wanting to track flights in real time for myself, so I didn't know this existed.

1 replies 0 reposts 2 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Woot! Very nice!

0 replies 0 reposts 2 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Absolutely, that counts!

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I invite you to share something you learned this week, whether tech related or not.

I learned how to do a silent install of SQL Server using Powershell.

I learned that the exercises from the chair exercise videos flooding social media are harder than they seem!

Happy Saturday!

#sqlfamily

7 replies 0 reposts 7 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

That does not sound pleasant. I hope you can make the best of your Saturday despite the lousy night.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

What?!! That's crazy. A wopping 4 indexes.

1 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Lol.... wow. This is amusing.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Right. I had always ran nodes at the same side, but here, the passive nodes are smaller to save costs, and automatic failover is not enabled. Just was wondering what others commonly do.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Ok. That's helpful. We have FCIs and AGs.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

So, my question isn't related to SQL Server licensing. It is about the cost of the VM in the cloud. If my primary is an r6i.4xl, and costs $1000/mth to run, do you also make your oassive seconday a .4xl? Or do you make it a .2xl or even .xl? Smaller size will cost less to run.

2 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

For folks using IaaS, when you have a failover cluster instance or AG, do you usually size the secondary node(s) smaller as a cost savings measure?

#sqlfamily

2 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

That is a bit surprising. Interested to hear what the answer from MS Support is once you get one.

0 replies 0 reposts 1 likes

Reposted by Lee Markum

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I feel like DBAs have to be multi-platform these days. The cloud seems to have made that a must.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I don't know if this is what you had in mind, probably broader than the example I'm about to give, but this made me think of how in tech I've often set out to solve 'x' problem and had to solve 3 others before I could solve 'x'.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Already doing that learning. It's been very interesting so far. I'm just getting started, but it makes sense so far.

1 replies 0 reposts 2 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

All of these poll results seem upsetting, but given that this was only a few decades since the tumultuous 60's and 70, maybe not unsurprising.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Sounds like a learning experience, for sure! What platform is this on?

1 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I saw today that this platform opened to the general public on Tuesday. Let's see if that helps draw in more activity.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

This is awful. So sorry for this event in your lives.

0 replies 0 reposts 1 likes

Reposted by Lee Markum

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Well, my journey with postgres has been rocky. I have ubuntu desktop with postgres on it. On 2 different VMs, I'm having a lot of problems with what seem to be OS/user setup issues that prevent me from following along with the videos or the book I have. Trying RHEL next.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I haven't seen any of those in forever. They were so funny.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Essentially, yes. When I click on a query on the left side of the UI, for some queries, nothing shows up inside the x/y axis on the right side as far as an icon for a plan. As a result, there's nothing to hover the mouse over to see runtime data. I need to circle back and query the raw data, too.

0 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Love love love that you got this award. I really hope we see more of you as Captain Seven of the Enterprise.

0 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I still need to try the github code that was shared with me to look at the raw data. Maybe there are plans and execution info there, and they just don't show in the UI?

1 replies 0 reposts 0 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Interesting. Ok. I searched your blog and didn't find it, but I think this lack of blogs on this topic means therr is room for me to write on the topic. I may design my own tests and blog my findings.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I may set up a demo and contrast it to a trigger to do the same thing. I can measure perf with profiler or extended events.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

I'm not sure with this feature. No blog I've read so far references there being a performance impact for this feature. That's in contrast to posta about triggers, replication, AGs, etc. The lack of reference to oerf issues for this feature is why I'm asking.

1 replies 0 reposts 1 likes

Lee Markum's avatar Lee Markum @leemarkum.bsky.social
[ View ]

Has anyone blogged about any performance impact associated with temporal tables in SQL Server? I keep getting this question, and I tell people that I haven't seen any information that indicates there is a measurable impact.

#sqlfamily

2 replies 0 reposts 0 likes