The Heap™ – Consultancy ©®

« first day (3507 days earlier) ← previous day next day → last day (1354 days later) »

John aka hot2use

6:02 AM

Morning

@ConcernedOfTunbridgeWells Looks like it

Andriy M

6:43 AM

Morning

Faheem Mitha

7:10 AM

Hi folks. It's been a while since I was in here. I hope everyone is doing well, and coping with things.

I wanted to ask whether it's possible to scroll in the sqlite3 command line shell, or whatever it's called. It's possible in psql, for example.

Faheem Mitha

7:34 AM

This was asked on SO in 2012.

Q: sqlite3 command-line - How to show less/more output

I am using the sqlite3 command-line programme on Ubuntu. I'd like to see its output paginated on the screen. So for example, I'd start it like so : # sqlite3 SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> _ Then, at the sqlite pro...

2 hours later…

Faheem Mitha

9:25 AM

Litecli (Python) looks good.

John aka hot2use

9:46 AM

@AndriyM Could it have possibly been an a.* which was deleted by the editor?

Andriy M

@Johnakahot2use Would it work though? I don't think you can have a tablealias.* inside COUNT() in T-SQL.

John aka hot2use

I'll have a bash.

@AndriyM You are right. Doesn't work.

Paul White 9

10:18 AM

tvnz.co.nz/one-news/new-zealand/…

John aka hot2use

10:53 AM

That's strange.

Dormant RNA virus strands in humans?

Paul White 9

11:34 AM

No these people had C-19 symptoms. We don't know how they got it yet, but hopefully we will soon. With any luck there will be a clear path to offshore and we can contain it before it spreads. Going to be a tense couple of days.

1 hour later…

Michael Green

12:48 PM

@Johnakahot2use Do you sail?

John aka hot2use

1:17 PM

@MichaelGreen No, but I enjoy the occasional Americas Cup. Was in Auckland in 2003 just overlooking the (new) wharf from Ponsonby.

Was interesting to be there at that time.

Drinking Peter Lehmann's - Clancy's Red 1998 and eating Fish 'n Chips out of the bag.

3 hours later…

Peter Vandivier

3:52 PM

Q: Cannot connect to server with SSMS 18

I'm having an issue all of a sudden with SSMS 18. Today, the authentication method is grayed out and I cannot get it to connect to a server. I've rebooted, reinstalled 18.6, uninstalled and installed 18.5 and run it as an Administrator. I have no idea what the issue could be and cannot seem t...

ssms

is there a canonical answer for this, cause if not we need one

to be clear - I do not think this should be VTC'd unless we've got a bona fide well-answered dupe. but this question is a perennial annoyance that needs a good canonical response

1 hour later…