Bikers Against Child Abuse helps children feel safe and empowered. Please take a minute to watch and share. #BACA

youtu.be/tuF3WqJUMKc?is…
0
0
0
Earned my Professional Certificate in Designing & Building AI Products and Services from MIT.

The course pushed beyond theory; practical frameworks for turning AI concepts into real products, from ML algorithms to human-machine interfaces to org-level business cases.🚀
0
0
1
AI as a thought partner is next level!

Given the right prompt, AI helps me broaden my thinking and stress tests my assumptions.
0
0
0
When Claude is down
0
0
0
Replying to @GFritchey
@GFritchey I feel ya.
0
0
1
When you are on a Zoom call and the person screen sharing has tabs from your blog open in Chrome.
0
0
2
Mock-ups and requirements are necessary, even for personal projects. They keep the vision in sight.
0
0
0
Have you seen this? There are 40+ roles open at @Olo! Some roles represent more than one slot to be filled.

Apply now

US only. Direct apply only.
0
0
1
Well... it happened.
0
0
2
Ring my video doorbell and then intentionally walk out of its view while you wait for me to come to the door? #nope
0
0
0
I love this visualization. I'm told it was produced by Spotify.
3
1
5
Replying to @jen_hammer
@jen_hammer That dark side is calling you.
0
0
1
@lynnswayze @thecaitcode I took the SQL server administration cert exam the morning of the interview and failed it.
0
0
4
Replying to @Jamie_Wick
0
0
0
Ever wonder whether the blue light filter on phones and on Windows is worth it?

Try to get some work done with your pupils dilated. After a little while, turn on the filter. This is when the value becomes apparent.
1
0
0
Putting my idle processors to good use. Focusing on the COVID-19 research.

foldingathome.org
1
0
2
Replying to @SQLHammer
Oops
0
0
0
It is one of those #daydrinking kind of days. Please send tolerance my way.
0
1
3
Developers of the world please stop this!

Names are extremely important.

(No this was not auto generated code)
1
1
0
@db_g33k No. Also, I enabled/disabled some of these to no affect. Drivers all say they are updated.
0
0
0
Trying to avoid the table scan. Usage of sort keys on outer join queries, within views. sqlhammer.com/amazon-redshif…
0
0
0
IT Responsibility – Informed Consent sqlhammer.com/it-responsibil…
0
1
0
Today I have been distributing these to my team as positive reinforcement.
0
0
2
Disney.... Day!!!
0
0
4
.@SentryOne can you help me understand what path needs to be added to the PATH var? My google-fu is not working. The download button goes to the v3 but I installed it and v2. Neither got into my PATH, though. #sqlhelp
3
0
0
I just spent 12+ hours loading 11 weeks of 50 million records per week between two remote systems.

I also just noticed that I didn't use my parameter in my WHERE clause so it was hardcoded to load only one of the weeks 11 times instead of 11 weeks 1 time each.
0
2
5
Re:invent begins
1
0
4
Defined Success and Role Clarity sqlhammer.com/defined-succes…
0
1
3
I am shocked to see my one and only Amazon Redshift post out performing my typical SQL Server high performers.
0
0
0
The Collaboration Commission – Part 5 sqlhammer.com/the-collaborat…
0
0
1
The Collaboration Commission – Part 4 sqlhammer.com/the-collaborat…
0
0
0
The Collaboration Commission – Part 3 sqlhammer.com/the-collaborat…
0
0
0
The Collaboration Commission – Part 2 sqlhammer.com/the-collaborat…
0
0
0
The Collaboration Commission – Part 1 sqlhammer.com/the-collaborat…
1
1
0
How can I do something like this (from T-SQL) in PostgreSQL or Redshift?

This only returns one of the values for me:

teststr := '';
SELECT INTO teststr
teststr || ' ' || column_name
FROM maint.table;
#sqlhelp
2
0
0
Developer asked me to contact the vendor of a COTS project to see if they would reduce their project dump json file size.

Reason: because they can't figure out how to connection Azure DevOps git repo through VS and the VSO web interface has a max upload file size.
0
0
1
Learning to Manage: Recovering from a crash sqlhammer.com/learning-to-ma…
1
0
2
Them: "Make sure to test these 50 use cases and do both functional an UAT."
Us: "Of course. We'll deploy in 2 weeks."
Us: "By the way, preliminary results are in, that data load which takes 5 days today will take <10 min."
Them: "Can we skip the testing and deploy tomorrow?"
0
0
0
So, is it taking it's last dying breath or restoring itself to new life?
0
0
0
#sqljobs by the way, @SUBWAY has a number of IT jobs open.

subway.com/en-US/Careers
2
1
0
My favorite Outlook icon.... the meeting cancellation icon.
0
0
2
8 year ago today, I shot that shit... I mean ship. Was a fun way to decommission a ship.
0
0
3
Me on-boarding "another" employee/consultant/contractor and dealing with all the missing system access and remote connectivity issues.
0
0
0
Replying to @Office365
@Office365 I'm not sure Download and Delete being so close together is a good thing for @SharePoint Online.
1
0
0
Replying to @SQLintheWild
@SQLintheWild I wish your power lines a speedy recovery!
1
0
0
I think their projection will be hard to satisfy since it has not yet shipped.
0
0
0
Amazon Redshift Unexpected Commit sqlhammer.com/amazon-redshif…
0
0
2
Replying to @SQLHammer
Getting real close to 1/2 million all time views.
0
0
0
Such a long time ago but posts like these still drive traffic to my blog.
1
0
2
NYC Yellow Cab Data in Azure SQL Data Warehouse sqlhammer.com/nyc-yellow-cab…
1
2
5
No one is scared away from the Scary DBA (@GFritchey) today at #sqlinthecity
2
1
6
OH: "we are getting deadlocks nightly on the redactedname processes which is filling the 'dbxxx' database logs"
0
0
0
"We are having timeouts in QA and we do not know why."

"Just cut it over to production and see if it happens there, it might not."
0
0
0
When the little quirks of your computer finally get annoying enough to require a reboot.
1
0
0
When you have too many things to do and you know that no amount of effort will make tomorrow's TO-DO list any shorter.
0
0
0
Replying to @SQLHammer
0
0
1
Replying to @rememberthemilk
1
0
0
I didn't realize @McDonalds is taking the opposite approach that @Starbucks takes.
1
0
0
My pretty, new, dish washer
1
0
2
I'm excited to learn how to better turn user stories into tables with @dgmelkin at #SQLSatAlbany
1
1
9
Replying to @SQLHammer
0
0
0
Why would this be a default recommendation? #sqlserver
1
0
3
Senior ETL Developer position open at Subway. On-site only, Milford, CT. Req. SRETL01345 | recruiting.ultipro.com/FRA1004FWHQ/Jo… #sqljobs #sqlfamily
0
0
1
Settling into the zone for a late evening of catching up on work items.
0
0
0
When a $1 million guestimate turns into a $3 million estimate.
0
0
0
1. Consultant presents amazing documentation during knowledge transfer.
2. He is praised heavily for being detail oriented and leaving us in a good spot.
3. We throw a good-bye party for him.
4. 2 days later the first resolved defect that we look up is completely missing all docs
0
0
1
I hope this estimate is not accurate.
0
0
0
This NAS just got better
0
0
0
@DBArgenis schooling professionals on the big orange monster. #sqlsaturdaychicago
0
0
2
Introducing #Azure SQL Database Managed Instance!!!
youtube.com/watch?v=W8feSZ…
0
1
0
It is amazing how I still meet people for the first time, in person, that I've virtually met years ago. #sqlfamily #mvpsummit #mvpsummit2018 cc/ @DesertIsleSQL
0
0
12
My head is spinning today. Too much to deal with.
0
0
0
@ALevyInROC Good point.
0
0
0
Amazon Redshift Temporary Tables sqlhammer.com/amazon-redshif…
0
1
0
#SQLServer #sqljobs Subway on-site only, Milford, CT. DBA and Sr. ETL developer. Apply on Subway.com.
0
0
1
Replying to @AaronBertrand
0
0
1
Replying to @SqlrUs
0
0
0
Replying to @SQLHammer
If you are ever wondering what I do when I am waiting for a presentation....

I pretend I'm Lieutenant Commander Geordi La Forge.
0
0
1
When I don't want access to PROD but still have to argue to get full access to DEV.
1
1
1
Replying to @jen_hammer
@jen_hammer double down and demand it, or keep your hand up until it falls off.
0
0
1
Replying to @BrentO
1
0
2
I just finished presenting over YouTube Live via Hangouts On Air for the @WausauPASS user group. Please check out the recording here. youtu.be/13y-Uxk_o7U?t=… x.com/SQLHammer/stat…
Less than 2 hours (7:30pm EST/6:30pm CST) until I present on Architecting Availability Groups for @WausauPASS via YouTube Live youtube.com/watch?v=13y-Ux… #sqlpass #sqlfamily
0
1
2