The Heap™ – Consultancy ©®

Morning

Morning all

dezso

8:32 AM

morning some

Q: Sysadmin rights to local administrator

Questions like this always make me cringe

How I can give the sys_admin rights to the local administrator for the SQL Server 2014 database while I installed it using the domain admin account, not local administrator account? Below is the requirement of a manual. SQL Server installation During the installation of AlarmInsight ...

Why would a monitoring system for alarms in gas/oil factories have those security requirements

There is a good chance the entire piece of software is easily hackable

Paul White

morning

Q: Account compromised or timeout suspension?

8:49 AM

Morning

Paul White

9:35 AM

-19

I was logged out of Stack Overflow earlier, which hasn't happened to me before. When I logged back in I was informed by a moderator: We are suspecting that your account has been compromised. To clarify, we got flags on a post you made, that looked suspiciously bot-like in nature. I'm t...

support

SO meta rant of the day.

Reading the comments, the user concerned is a proper nutjob

Paul White

Fully.

or a botjob

@ypercubeᵀᴹ Probably just trolling

@TomV a troll-bot?

1 hour later…

dezso

11:16 AM

@ypercubeᵀᴹ I think you meant \dt to list tables - unless they want the list with all the details

@dezso Yeah, I use that as I often want to see all (tables, views, sequences)

They can add details in their answer

dezso

sure

3 hours later…

2:33 PM

@AndriyM shouldn't the p._DATE > '01-Jun-2016' be >= ?

@ypercubeᵀᴹ Should it? Let me see.

They have > in their query. But would be very weird if they want to skip the first millisecond of a whole month.

Yeah, it's in the original.

2 hours later…

4:36 PM

Ooh, SQL Server on Linux. docs.microsoft.com/en-us/sql/linux/…

Andy K

4:53 PM

The (en)Ballmer is truly gone

bye folks

swasheck

5:03 PM

clustered columnstore and compression and data security features ... available on standard

sqlperformance.com/2016/11/sql-server-2016/big-deal-sp1

3 hours later…

7:37 PM

grumpy tom

This isn't an answer to the question, but an 'i'm having this too', please add a new question or a comment instead of an answer. Oh, and please avoid using all CAPS, the shift lock isn't that far to the left of your keyboard. — Tom V 25 secs ago

@TomV WHAT'S WRONG WITH ALL CAPS?

@Lamak YOUR LEFT PINKY FINGER IS ABOUT HALF AN INCH AWAY FROM NOT SOUNDING LIKE AN IDIOT

I SEE, I GET IT NOW

GLAD TO HELP

@Lamak You are different.

7:43 PM

reference (old school)

@Lamak Hello, by the way :)

@AndriyM Hi

@AndriyM yup, changed it

Mar 31 '14 at 16:28, by ypercube

@AndriyM I was thinking of this story: (sorry, wrong link, corrected:) http://thedailywtf.com/Articles/Spool-Me-Once.aspx

@Lamak Oh, new avatar

Mar 31 '14 at 16:30, by ypercube

>

IS THERE A TICKET FOR THE ISSUE?

Sara knew she wasn’t being yelled at. The entire mainframe team had pressed their caps lock keys once in 1972, and hadn’t touched them since. Yeah- I’ll forward it to-

7:51 PM

didn't notice until @AndriyM 's comment

@TomV but you knew it was me anyway

Something fundamental remained unchanged.

I think so too

@Lamak I saw one of your recent photos on a SQL Chili event page, never was 100% sure it was you but somebody named Kamal in Chili would've been quite the coincidence

I don't remember if it was in the SQLSat pages or what, but I saw a Kamal and it had the same pic

yeah, uncommon name here....

@TomV and where's a photo of that?

7:59 PM

@Lamak I'm not sure I can ever find that again

might be for the best

didn't look for it back then, except maybe SQL event chili after you mentioned something, I forgot

or the time you mentioned teaching at uni

I have no idea what triggered me finding that

well, hopefully nothing triggers it again :-)

I remember you talking about SQLSat santiago, but re-googling it I come up with this so it's not the same pic

must've been something else

@TomV how the eff is that picture around?....oh, well

8:03 PM

@Lamak sqlsaturday.com/472/Speakers/Details.aspx?spid=4656

ah, I see

If you google my name this is the first result

hardly accurate

@TomV you are the guy in black, right?

I'm the skinny guy with glasses taking the picture I suppose

and I'm proud I don't look like a prize bull on steroids

makes sense

8:26 PM

I have SQL Server on my Leenooks

lols at the system32 and AppData/Roaming directories that have appeared

It looks like it runs SQL Server from a Wine-a-like program called palrun. SQL Server itself is inside 6 .sfp files, that look like barebones archive files that contain the Windows gubbins that the emulation/VM layer needs to run SQL Server

So it's not a proper 100% native port

James Anderson

9:15 PM

@Philᵀᴹ Interesting. Just installing on Ubuntu16 now

9:42 PM

Right, the *.sfp files a just .cab files, and cab extract will uncompress them

sqlcmd: `root@frozenhell:/opt/mssql/lib# file MPT_SQLCMD_EXE_64
MPT_SQLCMD_EXE_64: PE32+ executable (console) x86-64, for MS Windows
root@frozenhell:/opt/mssql/lib#`

Hehe

Ah, sqlservr.sfp was a .cab, the others aren't that simple

10:13 PM

PAL_PROGRAM_INFO=1 /opt/mssql/bin/sqlservr -v is interesting

` system.sfp 6.2.9200.6,16aab11+hls-win2-20161114225920,` Wonder how that relates to windows/ .net version numbers

sqlservr.sfp 14.0.1.246