So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field databases for each report. That is, go in the database, pull the data, load into temp. Go in the next database, pull the data, load into temp. Go in next, […]
Cast datetime as varchar
I stumbled upon this great Q+A on Stack Overflow when I was looking for options to cast datetime for a report. (The customer didn’t like our standard mm/dd/yyyy format.) I actually like the third answer the most, because it gives you a chart on all the styles. A pretty helpful shortcut, if you ask me. […]
Rochester Wing Theory
Today I learned that apparently the best wings in Rochester can be found at *drumroll* the Klassy Cat. This was shocking news to me. Imagine the last place on Earth where you would look for wings, and you have the Klassy Cat. (As the name suggests, people come here for other sort of entertainment.) And […]
When a blocked procedure alert comes in
And I realize I was the one who launched those procedures
When the Senior DBA sits by me
And I pretend I totally understand the whole query plan
The most disturbing SFW gif on the whole internetz
Ebola
I have quite a few friends living in Liberia. They have been posting about Ebola for two months now. Today a patient died in a hospital in Texas and the US is losing their shit. Mind you, in the meantime more than 2K people died in Liberia. Fox News, of course, is creating the hype […]
So Doge
Meanwhile, at the database department, we’re butchering English like it’s our job: Anna Hadnagy: very replace Anna Hadnagy: much database Anna Hadnagy: so new? Matthew S.: sooo new, wow Matthew S.: very proceed to testing much Anna Hadnagy: rly Anna Hadnagy: wow. Anna Hadnagy: much thanks. Matthew S.: so welcome.
Fun fact – SQL server truncates
Tl;dr – SQL server 2008R2’s results to grid output truncates string values above 43,680. Conclusion: if half of your script is missing, it might still be there.
When I announce to my online gamer friend I’ll attack a bunch of twats because they annoy me
On the 11.08.2014 23:04 Atom wrote: > > So on one side there’s your fleet which is historically tougher than a $2 ribeye. > > On the other side there’s going to be a team of bug-eyed dildo mong ringpieces fighting with only poor English language skills, sharpened garden tools, and weaponised unicorn farts. > […]