« first day (1485 days earlier)      last day (3392 days later) » 

12:01 AM
Sort of
I was doing a simple gci Cert:\LocalMachine\My | select DnsNameList
Did you run the same sort of lookup on a server where the parameter works?
 
oh, haha on the foeach
I can't always remember which supports which ..
I did not yet
 
You can also do Get-ChildItem -Path Cert:\LocalMachine\my | ? {$_.DnsNameList.Count -gt 0}
 
so ..
I do get different ... results on each of those
I'll follow up on that .. add it as a comment
I'm actually gonna pawn that off on a coworker
For some reason, I'm more likely to ask the internet how to do things. I blame it on my coworkers being younger than me.
 
 
2 hours later…
1:40 AM
@PaulWhite Much appreciated
 
2:04 AM
@billinkc Even more exciting - it has arrived in LA. Two hours before it left NZ. Love time zones.
 
2:26 AM
And here I figured they packed it away with the elves going East
 
That would have cost extra.
 
 
3 hours later…
5:28 AM
hey
anyone here?
 
6:06 AM
anyone?
hey bluefeet
0
Q: query explain saidd row is a few but it too an hour to load

user965347i have a query down here select if ( month(td.date) = month('2011-01-01') and year(td.date) = year('2011-01-01') and month(td.date) = month('2011-01-02') and year(td.date) = year('2011-01-02') , timestampDIFF(DAY,'2011-01-01','2011-0...

@billinkc
 
 
2 hours later…
8:19 AM
@PaulWhite O for awesome.
Morning all
 
@ConcernedOfTunbridgeWells Keeps getting more exciting. It's in Cincinnati, OH at the moment. Go package go!
 
9:09 AM
@PaulWhite Processed (twice) now. I guess it's about to departure from Concinatti
 
9:27 AM
@ypercube Ooo! Not far to go!
I guess it might even go by air.
 
by a drone?
 
One day I expect so.
For the moment, Delta would do:
Google is getting spooky
 
9:59 AM
@PaulWhite I'm eagerly awaiting a photo of @billnkc wearing a Lava-Lava. Enquiring minds want to know.
 
 
1 hour later…
11:01 AM
This was closed:
-1
Q: I have an Access 2013 split database. How can I save the data when the network is down?

user57478Sometimes the network goes out, and the front ends can't reach the back end. What is the best way to save the data in this situation?

Should we leave a comment for the OP?
 
@ypercube You mean something along the lines of 'You're buggered'?
 
I mean the standard message displayed:
> There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.
is rather formal, impersonal.
(taking into account it's the OP's first encounter with the site)
 
I liked my one better :)
 
11:58 AM
How many bad answers can this q get? dba.stackexchange.com/questions/19536/…
Hurray!
> Departed from DHL facility in Cincinnati, OH - USA as of: January 28, 2015 06:49
 
Yay!
 
I'd say we're awaiting to see them arrive with baited breath, but that actually means we might see pictures of @billnkc wearing a skirt. Be careful what you wish for.
 
@ypercube Done.
Parcel tracking can never provide too much detail. I want to know what mode of transport it's using. Hey no, actually I want real-time GPS and the name and phone number of the driver/pilot!
We were going to slip some items from the local KFC into the package, but we forgot :(
 
12:21 PM
I like The Heap. You're my kind of people - Even shipping ethnic clothing can be a source of entertainment.
 
Tracking random parcels can be fun, too.
 
@ypercube Ha! Next level.
 
@ypercube you made me serially downvote those answers (Martin's already had my upvote)
 
user image
3
 
@ypercube I guess you can directly link to xkcd, too
 
12:35 PM
Oh, I didn't know that. Let me try.
 
@ypercube XKCD|SMBC to the rescue - again.
 
12:49 PM
Interesting. Cairo to Tunis though UK, Belgium and France: dhl.com/cgi-bin/tracking.pl?AWB=8487724836
 
@ypercube Hub and spoke routing
 
Is this something that could be in dba.se?
0
Q: How to list all past remote login information on remote SQL server

Bonus KunInstead of using "Remote Desktop" for connecting to SQL server, I and my coworkers are using SQL Server Management Studio to apply the changes on remote server (each users have their own credentials). One of us made some changes on SQL tables to risk the whole data. I'm pretty sure is one of us g...

 
What's being delivered?
 
1:08 PM
@Phil Two Lava-Lavas to add to @billnkc's extensive collection of kilts.
On one hand we're eagerly waiting to see a picture of @billnkc wearing a lava-lava.
On the other hand we're dreading the thought of seeing a picture of @billnkc wearing a lava-lava.
 
@ConcernedOfTunbridgeWells "eagerly"
 
1:38 PM
morning all
 
morning
 
afternoon
 
JNK
2:19 PM
daytime!
 
2:33 PM
Not for much longer.
 
3:19 PM
VtC: (the last IOT link in the comments is for Oracle and should be the duplicate target imo)
0
Q: table not taking records sequencially

user57526While inserting rows into a table in oracle 10g, the rows are not inserted in the order I am putting them, like for the following inserts: insert into emp values (1000, 'debjani', 30); insert into emp values (1001 ,'rani', 33); insert into emp values (1002, 'rabi', 35); insert into emp values (1...

 
3:44 PM
I think I just got three lots of agency spam for the same job - within 10 minutes of each other.
 
4:21 PM
@swasheck You around?
 
@ConcernedOfTunbridgeWells It seems to have suddenly picked up this week for some reason
 
@JamesLupolt End of Jan I guess. You tend to see a spike in contract work around the beginning of the financial year and another spike just after the summer holidays.
@billnkc - January 28, 2015
09:45

Kansas City, MO - USA With delivery courier
 
@MikeFal what's up
 
@swasheck Wanted to ask how you guys handle service accounts with your SQL Server sysprep
 
What is a good expression for wishing a DBA luck in a difficult task? "Break an LSN chain"?
 
4:27 PM
@JamesLupolt "Just don't murder them"
 
@JamesLupolt may you safely remove the corrupted page without any data loss
 
Both good choices
 
@MikeFal need more information than that. you mean, how do we handle encrypting the password in the config file?
 
@swasheck So there are 2 steps, right? You prep the install, then you complete the install, right?
 
ya
@MikeFal better yet ... ask brandon. it's his process
 
4:29 PM
So when you prep the install, do you declare the service accounts? Or only when you complete the install?
k
@swasheck Is btuck around?
 
i'm wfh so i hope he's not here with me
 
Hey man, I'm not judging.
 
@ypercube most of them are gone
 
4:45 PM
@dezso Yeah, just noticed.
PaulWhite, ypercube, Aaron, Rolando powers
> deleted by Paul White, ypercube, RolandoMySQLDBA 1 hour ago
> deleted by ypercube, Aaron Bertrand♦ 1 hour ago
> deleted by Paul White, Aaron Bertrand♦ 1 hour ago
 
Interesting statistics
 
The chart of Seagate's stock price has an interesting and probably related pattern since that finding was announced.
 
I read that it doesn't apply to newer drives eg 4TB
and it's only the cheapo versions
WD SE/RE are good for people who care about their data
 
5:07 PM
anyone here know anything about Sybase?
 
@bluefeet @swasheck does
 
i know it sucks giant goat gos
i mean. i know a little bit about it
 
just wondering if anyone would know an answer to this
 
@bluefeet "because sybase"
 
helpful
 
5:13 PM
i just honestly dont know. i dont care about the sybase engine.
 
ok, I figured I'd ask. Seems like a reasonable question and it's been asked by a mod on a different site
 
@bluefeet Sybase seems to have a statement cache but with so many different versions/OSes, who knows if it's relevant.
 
<rant>I gave my current employer just over 3 full weeks notice. He decides to take the last two days to try and go over all the documentation I sent him on clients and a few major processes I take care of. </rant>
 
<rant id="0" name="not_my_problem_bossman" />
 
Oh, didn't mention...this is the president of the company
 
5:25 PM
@ypercube I know nothing about Sybase so I've no clue. Thx for looking though
 
@bluefeet @ypercube I'd also wonder if it might be something similar to indexed views and indexes on computed columns in SQL Server. The query optimizer won't consider them if the the client has certain SET options.
 
@JamesLupolt Yeah, you should comment. Different settings looks like a reasonable cause.
I doubt it has anything to do with the drivers.
My foot is killing me the last 5 days. I think I have tendonitis.
 
5:43 PM
@ypercube what part of the foot?
Is there anything you can see on my query that would slow it down this much? is there a more efficient way to do this query? — Jeff 55 secs ago
just post the execution plan
 
@bluefeet In the arch mainly
 
@ypercube my favorite linux
 
@ypercube might be Plantar fasciitis
extremely painful. I had to wear a boot for 2 months for the swelling to go down
 
@bluefeet How can I tell which is it (if it is one of these 2)?
I have no swelling though.
It pains when I walk.
 
My swelling wasn't visible
If you stretch your leg and try to point your toes towards you, does the arch hurt?
Plantar fasciitis (also known as plantar fasciopathy or jogger's heel) is a common painful disorder affecting the heel and underside of the foot. It is a disorder of the insertion site of ligament on the bone and is characterized by scarring, inflammation, or structural breakdown of the foot's plantar fascia. It is often caused by overuse injury of the plantar fascia, increases in exercise, weight or age. Though plantar fasciitis was originally thought to be an inflammatory process, newer studies have demonstrated structural changes more consistent with a degenerative process. As a result of this...
 
5:49 PM
@bluefeet no
 
might not be Plantar fasciitis, I'd see a doctor for it.
 
just had one of these kinds of interactions with a dev
it felt good
 
6:29 PM
sigh
Hi Aaron, This link requires me to register to the site. Is there a url that I can follow that does not require a login. Thanks! — predestination 2 mins ago
 
JUST GIMMIE DA ANSWERS
I don't see anything in the bcp documentation, but I thought it didn't support non-local folders. Am I making that up?
 
6:55 PM
impromptu poll: Triggers, good or DIE YOU EVIL SCUM WHY DO MY DEVELOPERS KNOW THESE THINGS??? Star the following option for the one you agree with ....
4
Triggers are ok, sometimes good
8
Triggers are the spawn of satan and should never defile my database
4
 
It depends ™
2
 
Triggers, like cursors, have a deserved bad reputation. If I ask you, why did you chose to use X, you should be able to explain what you tried previously, how it failed and doing The Bad Thing (tm) was the only appropriate choice to solve the business neeed
5
 
7:44 PM
@swasheck What happened?
 
7:54 PM
@jcolebrand sometimes ok, never good
 
@AaronBertrand hehe, right?
Obviously I see a problem here today or I wouldn't be bitching, right?
 
If you don't have control over the data access layer, sometimes the only way to enforce certain logic is through a trigger.
 
Sure. We're the stack tho, so we have control :p
 
But usually I would first enforce all data access through stored procedures. Just about anything you can do in a trigger you can do in a stored procedure. What you have to account for is the case where people go around your stored procedures anyway.
(Not end users, but devs/dba folk with direct access.)
 
@AaronBertrand THANK YOU. I wish I could get these people to use sprocs but nooooo, we're an NHibernate shop
everything is in embedded XML resource files
These things do NOT make me happy
 
7:59 PM
But ORMs are so awesome and they get you to market quicker
</sarcasm>
 
ORMs are good for getting you to places where you don't want to be quickly
8
 
Had to
OH: "ORMs are good for quickly getting you to places you don't want to be."
5
 
@Zane Like this, for example, is either an idiotic or genius thing to say. Because it's either true or he's trying to make the Patriots think it is.
This will be useless research if the officials didn't actually record the starting air pressure of a single ball. http://www.latimes.com/sports/sportsnow/la-sp-sn-deflategate-investigator-columbia-20150128-story.html
 
8:18 PM
he told me something hadnt been done. in email. with my boss cc'd. oh. and his boss too. so i politely asked him how he was attempting to confirm.



he hadnt been diligent.
@AaronBertrand this makes so much more sense since i learned what "OH:" means a few months ago
 
@swasheck can you share that knowledge?
 
Overheard
 
ah, thanks
 
also ... i seem to have the plague
 
I am reading right that RESTORE HEADERONLY column CompressedBackupSize stated here is in bytes? msdn.microsoft.com/en-us/library/ms178536.aspx
 
8:24 PM
@swasheck the plague?
 
apparently
 
really?
 
figuratively
 
I'm lost
 
He's sick
Plague is a common exaggeration
 
8:27 PM
ah, thanks. Was trying to figure out if he was exaggerating or talking like people was avoiding him like the plague or something else.
 
@Lamak yes. sorry. i dont know what i have, but i am not feeling well. i've had a migraine for about 3 days and a low-grade fever.
@Lamak no. high school conditioned me to accept being avoided :)
 
jeez, I'm so slow this week
 
welcome to the club
also --- i'm completely rewriting my presentation
it's going to be a trainwreck ... and i'm casey jones
 
I hate the internet sometimes.
 
8:44 PM
@swasheck what was wrong with it?
 
@Lamak nothing. incomplete
 
@swasheck then why rewriting completely?
 
@Lamak ... better ideas that dont really fit ... but i'm becoming increasingly aware that my better ideas are only valid in sql 2014
 
well, it is a better idea to use SQL Server 2014 than previous versions
 
9:03 PM
i guess. but not when you're using an unsupported DMV ;)
 
 
1 hour later…
10:09 PM
oh snap! sql saturday cameroon!
 
11:07 PM
0
Q: How to add FK on a column of composite type in PostgreSQL?

EonilI have a table which contains a composite type and I am trying to connect a column of it to another table's PK. CREATE TABLE aaa (col1 SERIAL PRIMARY KEY); CREATE TYPE bbb AS (col2 INTEGER); CREATE TABLE ccc (col3 bbb); I tried to add FK but it was syntax error. CREATE TABLE ccc (col3 bbb, F...

I think this should be closed but cannot vote on it anymore...
 
@dezso Why?
Did you retract your vote?
 
I find the idea a bit strange, it looks like some misconception on the OP's side. Furthermore, the Q looks abandoned, too.
 
11:25 PM
@dezso I agree on that. I haven't used the TYPE in postgres, so I/m not sure if the answer to the question is simply "no you can't do that"
The why was for your "I can't vote"
 

« first day (1485 days earlier)      last day (3392 days later) »