Shane O'Neill 's Avatar

Shane O'Neill

@sozdba

SQL Server Database Administrator PowerShell automation Coffee, whiskey, etc.

388
Followers
456
Following
220
Posts
13.08.2024
Joined
Posts Following

Latest posts by Shane O'Neill @sozdba

Speaking at PowerShell Summit 2026 - Gilbert Sanchez

Speaking at PowerShell Summit 2026 - Gilbert Sanchez

Talk #1: "From Burnout to Built-to-Last: The Open Source Org Advantage"
Passion is a great start. It's just not a great bus factor mitigation strategy.
Come learn how orgs keep projects alive - plus the free tools FOSS projects are sleeping on.
cloud.umami.is/q/Dzd...
#PSHSummit26 #PowerShell

07.03.2026 02:56 πŸ‘ 9 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0

"It's not enough to see who's at the table. We have to see who's missing." I heard this at the MA Conference for Women several years ago and it's stuck.

I'd like to add this:
"Let's move over and add a seat for you. I see you. You belong here."

#datawit #celebratingwomen #womensmonth

03.03.2026 13:36 πŸ‘ 13 πŸ” 4 πŸ’¬ 0 πŸ“Œ 1
New to PSReadline? Start here.
New to PSReadline? Start here. PSReadLine is shaping your PowerShell experience whether you realize it or not. In this session, I'll break down what PSReadLine is, why it matters, and how to start using it intentionally. We’ll cover history, predictions, key bindings, and simple customization that can immediately improve your wo

Tara asked me about PSReadLine and I said, β€œGood question. I'll tell you on Wednesday.”

If you use #PowerShell, you’re already using PSReadLine… you just might not know it.

Tomorrow, well cover:
What it is. Why it matters. How to level it up.

04.03.2026 11:20 πŸ‘ 4 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Awkward Judd's Dad Joke 2026-02-13
Awkward Judd's Dad Joke 2026-02-13 YouTube video by Awkward Judd

Happy Weekend! I hope you like #dadjokes about #AI and #tourettes

youtu.be/Yt-JXqVMay4

13.02.2026 23:14 πŸ‘ 2 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Preview
Announcing Free SQL Server Performance Monitoring That Doesn't Suck Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing fees, no telemetry, no cloud dependency. Here's what it does...

Announcing Free SQL Server Performance Monitoring That Doesn't Suck

Announcing Free SQL Server Performance Monitoring I built a free, open-source SQL Server performance monitoring tool. Two editions, no licensing...

11.02.2026 17:19 πŸ‘ 17 πŸ” 8 πŸ’¬ 4 πŸ“Œ 3

I'm excited for this talk. Hey #PowerShell people! Let's hang out and learn something together.

10.02.2026 05:30 πŸ‘ 9 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0

#subscribe

26.01.2026 20:35 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Data CΓ©ilΓ­ 2026: Call for Speakers Data CΓ©ilΓ­ 2026 is a free, in-person event focusing on the MS Data Platform taking place in Dublin, Ireland.Pre-cons taking place on the 11th of June ...

Call for speakers at Data CΓ©ilΓ­ is open and I've just submitted 4 sessions :). More info: sessionize.com/data-ceili-2...

26.01.2026 07:21 πŸ‘ 4 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

Seeing as I woke up this morning to a locked out account, I guess it's official.

I've had my last day of work with Global Payments!

Here's to a little bit of weekend downtime before I start my new gig!

23.01.2026 10:15 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Congrats! And thanks for creating such a big part of my career!
Sorry for going "nah" when I first saw powershell v2 πŸ™ˆ
I'm less stupid now

21.01.2026 15:42 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Known Issues in SQL Server 2022 CU23

Known Issues in SQL Server 2022 CU23

If you use Database Mail in SQL Server, you should not install SQL Server 2022 CU23 (which breaks Database Mail).

learn.microsoft.com/en-us/troubl...

#SQLServer #SQLServer2022

20.01.2026 19:34 πŸ‘ 10 πŸ” 5 πŸ’¬ 3 πŸ“Œ 1

The Nobel Peace Prize becoming so prestigious that wars are fought over a head of state coveting it is some real monkey paw stuff for Alfred Nobel.

19.01.2026 08:47 πŸ‘ 10098 πŸ” 1779 πŸ’¬ 144 πŸ“Œ 52
BRIN Indexes in PostgreSQL – SQLpassion

[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres

19.01.2026 10:21 πŸ‘ 2 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Statistics io and statistics time for 2 queries in SQL Server. 
Original top one shows elapsed time is 63 million milliseconds and the bottom one is 2 thousand milliseconds

Statistics io and statistics time for 2 queries in SQL Server. Original top one shows elapsed time is 63 million milliseconds and the bottom one is 2 thousand milliseconds

What a difference....a NOT EXISTS makes 🎡

That's it, that's all.

Changed a NOT IN to a NOT EXISTS, and we go from 17hours 39mins to 2 seconds.

DBs are amazing...

#SqlServer

15.01.2026 14:43 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Home | PowerShell + DevOps Global Summit PowerShell + DevOps Global Summit is the gathering of PowerShell and DevOps professionals and enthusiasts. Join us for North America's only PowerShell Conference.

I'm hitting the stage @powershellsummit.org with my friend @sdwheeler.bsky.social to talk about all things PlatyPS and what's new in the 1.0 release! Join us as we show you what it is, how it can help you, and how to use this powerful documentation tool for your #PowerShell modules!

13.01.2026 19:49 πŸ‘ 7 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0
Preview
the man is wearing a suit and tie and clapping his hands . Alt: Leonardo DiCaprio is wearing a suit and tie and clapping his hands .

Love the outro.
I've down the straight port from SQL Server to Postgres with a start_date and end_date column; didn't even know about tsrange type.

Thank you!

12.01.2026 21:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

_frantically catches up on reading_

12.01.2026 21:45 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Looking forward to any post on Gist indexes you do (yes, I'm totally using you to explain these index types to me πŸ˜…)

12.01.2026 21:37 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
GIN Indexes in PostgreSQL – SQLpassion

[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL

12.01.2026 12:57 πŸ‘ 3 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0

No lie...I could have used GIN indexes once or twice
Nice one

12.01.2026 21:29 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
A book of Maori Myths and Legends, with the cover showing a Maori youth and a giant bird

A book of Maori Myths and Legends, with the cover showing a Maori youth and a giant bird

First book of Maori myths I've found!

I have a weird goal of getting as much different myths as possible

11.01.2026 15:46 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Well things don't seem so good all around right now, and even tech things ain't looking too good.

Think I'll just read and write for a while until things seem better...

07.01.2026 20:59 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I didn't even know that was a thing!
I'll check it out, thank you!

06.01.2026 20:45 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Once you get past the cant-use-butter-for-all-flavour aspect, it's not too bad

The cant-use-dairy-to-make-things-less-spicy gets me, though

06.01.2026 20:23 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
2 bowls of slighlty charred salmon pieces on egg fried rice

2 bowls of slighlty charred salmon pieces on egg fried rice

Happy Nollaig na mBan!

I luckily found another dish that she likes! Hot and spicy salmon with egg fried rice.

The gluten-free & dairy-free requirements still add a bit of difficulty when finding a dish.

06.01.2026 20:14 πŸ‘ 4 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Stealing these...
The amount of times work has kept going and going and going is too damn frustrating

06.01.2026 13:20 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Make files!
Not only indentation, but tabs only; no spaces

04.01.2026 19:05 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Congrats!

01.01.2026 20:38 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Yo! Happy (belated?) Birthday

18.12.2025 13:56 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Great! Cause my big head is the problem 😑

17.12.2025 11:38 πŸ‘ 1 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0