Category: sqlserverpedia-syndication

Answer the Question Asked

Post author By Jen McCown
Post date January 13, 2012
Categories In Random helpfulness, sqlserverpedia-syndication, SSC
4 Comments on Answer the Question Asked

“Bill, are you running SQL R2 on your desktop?” This seems like a simple enough question, yet I usually cannot get an answer to a question like this on the first try. Why? The simple answer is that people don’t hear the question you ask. People hear a question through filters. What this means to me […]

SELECT GetDate() – 30 AS [This actually works??];

Post author By Jen McCown
Post date December 19, 2011
Categories In sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on 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 much used to using DateAdd() for all my […]

PASS Board of Directors – Who I’m Voting For

Post author By Jen McCown
Post date December 15, 2011
Categories In Community, News-ish, sql server, SQLPASS, sqlserverpedia-syndication, SSC

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 support the people I’m voting for – I really and truly do. It’s […]