Stack Exchange
log in
users (48)
rooms (48)
faq
gbn
general
recent
conversations
The Heap™ – Consultancy ©®
General on- and off-site discussion for
dba.stackexchange.com
....
12
18
gbn
Sep 17, 2020 13:01
Good afternoon all. I see the same usual suspects still here
gbn
Feb 18, 2020 06:32
@TomV-trytopanswers.xyz I'm claiming the crown back
gbn
Feb 18, 2020 06:31
Who's the current village idiot then? Me, because I have to ask...?
gbn
Feb 18, 2020 06:30
Good morning all. Did I miss anything?
gbn
Dec 20, 2018 14:06
@Philᵀᴹ One day at a time
gbn
Dec 13, 2018 11:30
@Philᵀᴹ I answered a question on db2 on SO once
gbn
Dec 13, 2018 11:29
nah
gbn
Dec 13, 2018 11:29
<_ do i have a hat?
gbn
Dec 11, 2018 17:11
one for dba.se?
stackoverflow.com/questions/53728997/…
gbn
Dec 3, 2018 14:07
looks ok here
gbn
Dec 3, 2018 13:48
Beep you have reached the answer phone...
2
gbn
Nov 30, 2018 16:01
@George.Palacios ah, yet another OCDBA
3
gbn
Nov 30, 2018 11:21
option 1 or 2 if you do please
gbn
Nov 30, 2018 11:21
Anyone use sp_databaserestore from Brent O?
github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/…
gbn
Nov 26, 2018 11:12
@George.Palacios At least it didn't happen on a Friday
gbn
Nov 22, 2018 11:36
@ConcernedOfTunbridgeWells I'll try and blag a trip to the London office
gbn
Nov 16, 2018 13:12
@TomV True. I'm just old and cynical
2
gbn
Nov 16, 2018 13:01
I look forward explaining that one to management
gbn
Nov 16, 2018 13:01
@TomV replacement infrastructure partner due next year. We might only have db level access which means we can't run some "special" applications
gbn
Nov 16, 2018 13:00
@George.Palacios 3rd party
gbn
Nov 16, 2018 11:07
That is, you manage only the databases and some (lesser) monkeys deal with the SQL Server patching, server level settings, security, etc?
gbn
Nov 16, 2018 11:06
Anyone actually using "SQL as a service" for real stuff?
gbn
Nov 15, 2018 14:16
xaprb.com/blog/2010/02/08/…
gbn
Nov 15, 2018 14:16
Basically it's a workaround for MySQL not doing proper WAL
gbn
Nov 15, 2018 14:14
@pavelkolodin a quick google shows
percona.com/blog/2006/08/04/innodb-double-write
gbn
Nov 15, 2018 12:16
@pavelkolodin Why do want to know? I know PGSQL has some good resurces about this (and WAL etc) in their docs. What is missing from these?
gbn
Nov 15, 2018 10:36
@Philᵀᴹ ...again
gbn
Nov 15, 2018 07:19
@SpringLearner Utter horseshit
gbn
Nov 8, 2018 10:39
my old DBAs (back when I was in a developer role) used to amuse themselves doing Google translations of SQL Server docs and back again
gbn
Nov 8, 2018 10:33
@hot2use Isn't his "multiculturalism" or something?
gbn
Nov 8, 2018 10:21
I found something that will do anyway, I just have to translate "documentation English" to "English for foreigners"
gbn
Nov 8, 2018 10:20
@hot2use I'm not using SQL Server FCI. Just AGs on top on Windows FCI.
gbn
Nov 8, 2018 10:08
I've been asked, can't Google up a nice one-liner to sum it up authoratively, now I'm second guessing myself...
gbn
Nov 8, 2018 10:02
been a while...
♦
stop the merry-go-round
Gallery room. Feel free to request write access if you read SQ...
gbn
Jan 30, 2019 15:35
eh?
gbn
Jan 30, 2019 15:35
null bitmap?
gbn
Jan 15, 2019 15:33
I'm going to go with "something is different in the environment"
gbn
Jan 15, 2019 15:26
@PaulWhite it probably doesn't affect. it's more likely a bad comparison setup
gbn
Jan 7, 2019 14:25
or "it depends"
gbn
Jan 7, 2019 14:25
about 15 seconds
gbn
Dec 28, 2018 12:50
Even in your Merkin babble it's still Sergeant
en.wikipedia.org/wiki/Sergeant
gbn
Nov 22, 2018 15:22
@MaxVernon First "trick or treating", now "Amazon putting bricks'n'mortar out of business"
gbn
Nov 21, 2018 15:05
And synonyms are, er, quite new... I don't use them now unless I really have to...
gbn
Nov 21, 2018 15:04
@sp_BlitzErik Sometimes different servers
gbn
Nov 21, 2018 15:02
@sp_BlitzErik If I really needed, I'd use a sensible linked server name so any code can be consistent. And change the data source (sp_setnetname etc). I have some SO answers on it.
gbn
Nov 21, 2018 14:50
@JoeObbish See previous line
gbn
Nov 21, 2018 14:49
@sp_BlitzErik Abstracts different databases names away between enviornments. For example
gbn
Nov 15, 2018 14:42
@JoeObbish This cloud thing means fewer server rooms with locked doors and mattresses
gbn
Nov 15, 2018 14:18
@MaxVernon Shurely the shame rules about "stoned" apply to being "rat arsed"
♦
Trash
DELETE FROM "The Heap" WHERE message IS NOT DISTINCT FROM tras...
gbn
Jan 8, 2019 14:08
Can you bugger off to a new room please?