Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2011

My Most Popular Posts From 2010

I was recently looking through my blogging statistics and discovered that I can see the most viewed posts during that time period. I didn’t know that I could do that. I should spend a bit more time exploring the other features of WordPress.

Like all statistics, they can be a… Read more

0 comments, 369 reads

Posted in Joe Webb on 27 January 2011

Getting Started With Consulting Webcast Recording Now Available

If you missed my PASS Professional Development Virtual Chapter Webcast “Getting Started With Consulting” last week, it’s now available online.

I haven’t watched it yet just in case Doc in Back to the Future, Part II was right.

I foresee two possibilities. One, coming face to face with herself…

Read more

0 comments, 388 reads

Posted in Joe Webb on 25 January 2011

Keeping Perspective: What Are You Building?

Think about your responsibilities at work for a minute. How many do you have? Can you even name them all?

As technical professionals, we have a myriad of responsibilities This is especially true in today’s economy when so many of us are being asked to do more with less. It’s… Read more

0 comments, 339 reads

Posted in Joe Webb on 24 January 2011

Removing Time From A Datetime Value

How much time would a DateTime have if a DateTime had no time?

Ok, forgive the bad pun. But the point remains is a valid one. How can we efficiently strip off the time portion of a DateTime value in SQL Server?

I’ve seen a several methods proffered on the… Read more

2 comments, 430 reads

Posted in Joe Webb on 14 January 2011

It’s A Major Award!

“It’s a major award!” That’s what Darren McGavin’s signature role, Mr. Parker, proudly proclaimed to friends and family in the 1983 movie A Christmas Story. He was proud of his accomplishment and of the leg lamp that recognized them. What a great movie!

On January 1st, I received a… Read more

0 comments, 182 reads

Posted in Joe Webb on 7 January 2011