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. […]
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
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.
The morning after SQL server failed three times in one night
Today was the day
When the server ran out of both memory and disk space. On both drives.
When I talk with my ex supervisor about my current supervisor
@annahadnagy It really is the only way to “supervise” you. Give you a hammer and some gaff tape and leave you alone for a few hours. — Jason Noble (@lastashikabi) June 27, 2014
Linke
My brother asked me to come up with some pictures to show her girlfriend the many beautiful places of this world. Being the dedicated overachiever I am, in return I handed over a website. Where should Linke go? is a 3D ‘slideshow’ built on Hakim El’s reveal library. Of course it’s optimized to mobile and […]
When the leadership team works my hopes up
With a promise of another 32 GB of memory for the analytics server just to cancel the project in the last second:
Running sum for last 12 months, SQL style
I’m going to tell you a little secret. Come, sit closer. You know your running chart for every other dashboard, showing the SUM / Average / Top / Least / etc. of Sales / New customers / Quotes / etc. for the last… 1 hour / 1 day / 1 week / 4 weeks / […]