Archives: December 2011
SELECT GetDate() – 30 AS [This actually works??];
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works. If you run the title of this blog post, you’ll get the date 30 days ago. I had no idea you could do this…I’m very… Read more
4 comments, 476 reads
Posted in SQL Awesomesauce on 19 December 2011
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD election, ending 12/20. Here is Nic’s take on the subject. So, who am I voting for?
I’m not telling you.
It’s not that I don’t… Read more
0 comments, 232 reads
Posted in SQL Awesomesauce on 15 December 2011
#SQLLove for my Mentor
In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later by gifting various Apple games to me, and teaching me about pre-Internet BBSs.
In 1992, my high school purposefully encouraged me on that same road by offering Programming… Read more
2 comments, 228 reads
Posted in SQL Awesomesauce on 14 December 2011
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
- Them: “Are foreign key constraints more performant than referential integrity triggers?”
- Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.”
Let’s start with a generic statement, and get more specific. Generally speaking: Don’t try to circumvent… Read more
2 comments, 319 reads
Posted in SQL Awesomesauce on 8 December 2011
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain key functions are very hard to perform. In this case, not having a resume makes the job-getting difficult.
We’ve talked about resumes, and even reviewed a few, on the show… Read more
6 comments, 2,508 reads
Posted in SQL Awesomesauce on 6 December 2011



Subscribe to this blog