The Heap™ – Consultancy ©®

« first day (4943 days earlier) ← previous day next day → last day (79 days later) »

Criggie

12:09 AM

@Vérace a little - I do the commute mostly. Recreational rides kinda went away.

3 hours later…

Michael Green

2:49 AM

@ErikDarling are you the racoon or the .. not racoon?

Criggie

"LEARN SQL IN 2 DAYS" ? I can has be Dee Bee Aye ?

Michael Green

3:25 AM

@SeanGallardy Good enough. Ship it. Once you fix the title bar shade, of course.

2 hours later…

Hannah Vernon

4:56 AM

@SeanGallardy nice!

Hannah Vernon

5:06 AM

Wordle 1,124 3/6*

⬛⬛⬛⬛🟨
🟨⬛🟩🟨⬛
🟩🟩🟩🟩🟩

Vérace

5:40 AM

A chairde - Morning all!

@MichaelGreen norvig.com/21-days.html

2 hours later…

Erik Darling

7:45 AM

@MichaelGreen not the raccoon obviously

1 hour later…

Yano_of_Queenscastle

8:54 AM

Morning.

Wordle 1,124 4/6*

⬜⬜🟩⬜🟩
⬜⬜🟩⬜🟩
🟨⬜🟩⬜🟩
🟩🟩🟩🟩🟩

Broken trident.

2 hours later…

Sean Gallardy

10:57 AM

@MichaelGreen of course, I shouldn't miss the "big picture" :D

2 hours later…

Josh Darnell

12:34 PM

@SeanGallardy Ooh, what are you working on?

Paul White

1:00 PM

Wordle 1,124 4/6*

⬛⬛⬛⬛🟩
⬛⬛⬛⬛🟩
⬛🟩🟩⬛🟩
🟩🟩🟩🟩🟩

John K. N.

1:12 PM

Wordle 1,124 5/6*

⬛⬛⬛⬛⬛
⬛⬛🟩🟩🟩
🟨⬛🟩🟩🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

turdle

2 hours later…

Paul White

3:06 PM

@SeanGallardy Will that sort of thing be affected by the VS 2022 shell in SSMS 21?

Cade Roux

3:22 PM

Wordle 1,124 4/6

⬛⬛⬛⬛🟩
⬛⬛🟩⬛⬛
⬛🟩⬛🟩⬛
🟩🟩🟩🟩🟩

That was neat, every letter was in my probe words in exactly the right place. I'm not sure how many words could even do that. Need to figure out a query to run an analysis for that.

Peter Vandivier

3:37 PM

TIL stackoverflow.com/a/16581591/4709762

Sean Gallardy

4:21 PM

@JoshDarnell I figured it was time I tried to make an extension to do the things I want natively in SSMS :D

@PaulWhite Yes but AFAIK it just requires a compile with the different SDK references... but I'm not a @Josh level .net dev so not 100% sure.

Josh Darnell

@PeterVandivier That's really neat.

Peter Vandivier

now i just need to figure out how to disable solution explorer >.<

well - disable solutions i guess

has that always been a thing and it's just been so long since i used an older version that i've forgotten how annoying it wasn't?

i feel like i have no idea why a solution initializes and then it becomes a blocking dialogue to close SSMS

2 hours later…

Josh Darnell

6:30 PM

I don't know what that is, and don't think I've ever had it happen.

I get the object explorer on startup, but no solution explorer.

Peter Vandivier

it's not the explorer interface per se - rather that open tabs get automagically added to a new solution :-\

the solution explorer doesn't open, but the solution gets initialized somehow

maybe i ticked a setting somewhere ¯\_(ツ)_/¯

Josh Darnell

7:19 PM

@PeterVandivier Oh interesting. I don't think I've had that happen either, but I'm not sure if I'd know if it did or not :D

Peter Vandivier

yea, it's a bummer 'cause AFAICT it's preventing me from using the unblocked SSMS shutdown feature you get from SQL Prompt tab history :-\

Josh Darnell

7:38 PM

That sucks.

Paul White

7:55 PM

@PeterVandivier I don't think you can do anything about the reminder to save the solution

It's annoying, but I don't find it too bothersome since I rarely restart SSMS

Maybe this sort of advanced feature will be in SSMS 25

Peter Vandivier

AFAICT it's getting removed in 21 actually

Paul White

It was only relatively recently that the tick box arrived to not remind about unsaved files

@PeterVandivier Well, that'll b gr8 if it eventuates

Josh Darnell

This is so weird. I've never been prompted about anything related to a solution when closing SSMS. I don't have SQL Prompt installed. Maybe it uses them "behind the scenes" somehow.

Paul White

I just hope they get the colours right

@JoshDarnell Do you close all your tabs neatly before shutting down?

Peter Vandivier

learn.microsoft.com/en-us/sql/ssms/solution/solution-explorer

> This feature will be removed in a future version of SQL Server

Paul White

8:00 PM

@JoshDarnell Also, are you on some ancient SSMS

Josh Darnell

@PaulWhite No. But...now that you mention it, I've just don't read very carefully 😵‍💫 I've never noticed that the popup says something about a solution. I just thought it was a generic thing about having unsaved script files open.

Please excuse my insanity.

Paul White

Unblemished brand

Josh Darnell

@PaulWhite 😂

Paul White

Thank @Zikato again for that

A: Suppressing the SSMS prompt to save changes

In SQL Server 2016 this is apparently coming. The pre-release docs says New option to skip prompt to save T-SQL files We have added a new option under "Tools|Options|Query Execution|SQL Server" to control if a prompt is shown for unsaved T-SQL files. In previous versions there is no setting to...