Shane O'Neill 's Avatar

Shane O'Neill

@sozdba.bsky.social

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

386 Followers  |  455 Following  |  220 Posts  |  Joined: 13.08.2024  |  2.0439

Latest posts by sozdba.bsky.social on Bluesky


Awkward Judd's Dad Joke 2026-02-13
YouTube video by Awkward Judd Awkward Judd's Dad Joke 2026-02-13

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 โ€” ๐Ÿ‘ 10110    ๐Ÿ” 1782    ๐Ÿ’ฌ 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
A bookcase with a shelf with broken headphones on it.

A bookcase with a shelf with broken headphones on it.

I now have a shelf in my office filled with broken headphones that MY FAT HEAD has broken ๐Ÿ™ƒ

17.12.2025 10:06 โ€” ๐Ÿ‘ 5    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Oh you evil genius ๐Ÿคฃ

16.12.2025 17:15 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Hey all, just a reminder that the @dataceili.bsky.social call for speakers is open!

dbafromthecold.com/2025/12/16/d...

#sqlserver #fabric #powerbi #sql2025 #conference

16.12.2025 17:08 โ€” ๐Ÿ‘ 4    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@sozdba is following 20 prominent accounts