Shane O'Neill 's Avatar

Shane O'Neill

@sozdba.bsky.social

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

351 Followers  |  423 Following  |  166 Posts  |  Joined: 13.08.2024  |  1.885

Latest posts by sozdba.bsky.social on Bluesky

Is the command `git pull && git remorse`?

07.08.2025 12:24 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
dbatools is moving to Azure Trusted Signing TLDR: dbatools is moving to Azure Trusted Signing, which means Microsoft backs our reputation and dbatools won't trigger as many antivirus false positives. …

πŸŽ‰ Big news! dbatools is moving to Azure Trusted Signing, which provides base reputation on Windows SmartScreen. No more antivirus false positives.

The catch? If you use strict ExecutionPolicies, you'll need to trust our cert after each update (it rotates daily). But we've got automation scripts.

07.08.2025 10:34 β€” πŸ‘ 20    πŸ” 10    πŸ’¬ 2    πŸ“Œ 1

Two weeks to go until this year's edition of EightKB...the world's biggest SQL Server internals conference!

Registration is completely free...you can sign up here...
eightkb.online

#eightkb #sqlserver

07.08.2025 09:38 β€” πŸ‘ 9    πŸ” 6    πŸ’¬ 0    πŸ“Œ 0

Ah! Foiled by my colourblindness yet again!

04.08.2025 16:57 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Mangled text output of a `go test` command...

Mangled text output of a `go test` command...

Eh, if this is my output for `go test . -v -cover`, then I think I've done something wrong...

04.08.2025 16:54 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. - YouTube

β˜• Less Clicking, More Sipping!
@ja.mesrusk.in for @chocolatey.org shows how #Chocolatey for Business speeds up software deployment:
⚑ Build packages in seconds
⚑ Offline installs with Internalizer
⚑ Auto-builds via GitHub Actions
⚑ Central Management for rollouts

31.07.2025 10:00 β€” πŸ‘ 2    πŸ” 2    πŸ’¬ 0    πŸ“Œ 0
Preview
Ordering and Choices in PowerShell Ah! Hash tables! Ever since I saw a presentation by Anthony Howell ( Blog ), aka PoshWolf, about them, read the blog post by Kevin Marquette ( Blog ) about them, and was enlightened by multiple Pow…

Ah! It's nice to blog again!

Ordering and Choices in PowerShell

#powershell #sqlblog

nocolumnname.blog/2025/07/21/o...

21.07.2025 14:28 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Bomb disposal operative fully suited up in gear with a big stick to explode bombs...

Bomb disposal operative fully suited up in gear with a big stick to explode bombs...

Talking to all my cork friends today

20.07.2025 21:30 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. - YouTube

πŸš€ Containers β‰  black magic.
@dbafromthecold.com showed us how to go from #Docker to #Kubernetes with real-world clarity at #PSConfEU 25:
βœ”οΈ Persistent data
βœ”οΈ StatefulSets
βœ”οΈ Secrets & YAML configs
βœ”οΈ SQL Server in K8s
🎟️ Tix open for 2026 β†’ psconf.eu
#PowerShell

15.07.2025 10:00 β€” πŸ‘ 7    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0
Preview
a man with a beard is making a funny face and the word genius is on the screen . Alt: a man with a beard is making a funny face and the word genius is on the screen .
08.07.2025 18:27 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

*Be work* have a process that sometimes fails due to OOM errors.
*Le me* creates workaround process to not have to restart broken process
*le me* workaround process is faster than normal process

It's a once a week thing?
Do I tell people? They're going to ask me to do their work? 😫

08.07.2025 17:38 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

I’m petrified about today’s science news. Genetically modifying crabs to have cheetah genes? This could go sideways fast.

08.07.2025 09:45 β€” πŸ‘ 22787    πŸ” 4130    πŸ’¬ 818    πŸ“Œ 316
Preview
Stacked for Success: PowerShell Callstacks in Everyday Scripts, Wed, Jul 9, 2025, 6:00 PM | Meetup Unlock the power of PowerShell callstacks to track and manage the execution flow of your scripts. This talk goes beyond debugging, showing you how to use callstacks to unde

Hey #PowerShell folks! Friendly reminder that THIS Wednesday (2 more sleeps!) I'm going to be talking the PNW PSUG about abusing callstacks for ill-gotten gains.

This one is going to be pretty fun!

Details: www.meetup.com/pacific-powe...

07.07.2025 13:34 β€” πŸ‘ 7    πŸ” 6    πŸ’¬ 0    πŸ“Œ 0
A picture of a comfy leather chair, laptop, whiskey, reading light, and library

A picture of a comfy leather chair, laptop, whiskey, reading light, and library

Today was... not great.
Before I battle tomorrow, I'm going to take tonight off.

Take care of yourself, folks.

30.06.2025 20:41 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
The Dos and Don'ts of PowerShell with Steven Judd and Gilbert Sanchez

@andrewpla.tech @gilbertsanchez.com @stevenjudd.bsky.social 3 buds talking #PowerShell
Dos and Don'ts.
Such a great episode lads, well done.
pca.st/episode/f8dd...

28.06.2025 19:15 β€” πŸ‘ 11    πŸ” 4    πŸ’¬ 0    πŸ“Œ 0

<# SPOILER #>
Expanding into Postgres; having to think about dead tuples in perf-tuning is so foreign to me right now!

Thanks for the post @kendralittle.bsky.social

28.06.2025 10:48 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
a man wearing a black shirt that says skyscraper is pushing a suitcase Alt: a man wearing a black shirt that says skyscraper is pushing a suitcase, with a man popping out of the suitcase

Bring me too!!!

26.06.2025 19:33 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A slide with the title and presenter name on it

A slide with the title and presenter name on it

Final session at #sqlbits before I head for my flight home is Bob Ward and SQL Server 2025 Community Edition

21.06.2025 13:39 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A presenter to the right-hand side of the photo, leaning against the podium, with the title slide on the wall behind them

A presenter to the right-hand side of the photo, leaning against the podium, with the title slide on the wall behind them

The Benefits of Mentoring at #sqlbits with @dgmelkin.bsky.social

21.06.2025 13:10 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A presenter on stage in front of their slide with the title of the talk on the slide

A presenter on stage in front of their slide with the title of the talk on the slide

The Flash, aka @claudioessilva.bsky.social is up at #sqlbits with X-Raying Schema Operations: Adding and Removing Columns

21.06.2025 11:22 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Also, good news! The notebooks are coffee proof!

21.06.2025 10:20 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A volunteer with sqlbits on the back of his shirt in front of a slide with the title of the talk

A volunteer with sqlbits on the back of his shirt in front of a slide with the title of the talk

And we have @funbucket.dev with Mind the Gap: Bridging PDFs and SQL Server with AI at #sqlbits

21.06.2025 10:19 β€” πŸ‘ 5    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
a man in a suit and tie is standing in the rain with his eyes closed . Alt: Dr Who (David Tennant) is standing in the rain with a sad expression

Ouch! πŸ«‚

It distracts me from thinking about having to leave for the airport and missing the last 2 sessions...

21.06.2025 09:46 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

The best way to improve your #PowerShell skills is to DO. That's why I wrote The PowerShell Practice Primer. No lab setup needed. 100+ exercises, including PowerShell 7 content. leanpub.com/psprimer

20.06.2025 20:01 β€” πŸ‘ 5    πŸ” 2    πŸ’¬ 0    πŸ“Œ 0
Preview
a cat wearing a hat is standing in front of a black background with the words `` which is very conflicting for me '' Alt: a cat wearing a hat is standing in front of a black background with the words `` which is very conflicting for me ''

At #sqlbits2025, there are two sessions I want to see that are at the same time...

21.06.2025 09:39 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Next up at @sqlbits.bsky.social is @tracisewell.com talking, "Talking about mental health for you and for them"

"How do dragons blow out birthday candles?" is staying with me!

20.06.2025 14:32 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Rows of people in seats before a presenter in front of his slides, with a intro slide on the screen

Rows of people in seats before a presenter in front of his slides, with a intro slide on the screen

We have a packed house for @kekline.bsky.social at @sqlbits.bsky.social

20.06.2025 10:25 β€” πŸ‘ 5    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
A presentation slide on a screen on a stage all illuminated in neon

A presentation slide on a screen on a stage all illuminated in neon

Kicking off day 2 at @sqlbits.bsky.social

19.06.2025 08:09 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

PySpark seems useful.
Given the choice, though, I'm not sure if I'd use it or #duckdb

Helps I don't know their proper use cases πŸ˜…

18.06.2025 13:32 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Just landed for it πŸ™Œ

18.06.2025 07:03 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@sozdba is following 20 prominent accounts