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

Balancing Work and Life

Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months when so many companies are streamlining operations and asking their employees to do more with less, the challenge has gotten noticeably more difficult. I recently interviewed someone who had struggled… Read more

3 comments, 460 reads

Posted in Joe Webb on 16 March 2011

SQLPeople: An Interview With Andy Leonard

The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get to meet or see there. That’s why I was intrigued when SQLPeople was announced a few months ago.

Recently I had an opportunity to spend time with Andy Leonard ( Read more

0 comments, 756 reads

Posted in Joe Webb on 14 March 2011

An Outpouring From The Twitter Community

Last week, I was in Redmond, Washington, for the Microsoft MVP Global Summit. This was my fourth time attending the Summit; it’s a great opportunity for networking and providing feedback to Microsoft about their products.

I love catching up with people that I only see once or twice a year. Read more

0 comments, 371 reads

Posted in Joe Webb on 7 March 2011

The Three C’s Of Interviewing

A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I regularly help clients interview and select qualified IT Professionals to join their ranks.

Usually I’m usually given a detailed job description with very specific requirements. The manager frequently believes that… Read more

2 comments, 342 reads

Posted in Joe Webb on 7 March 2011

Writing Better Queries Presentation Materials

I delivered a webcast for the PASS DBA Virtual Chapter yesterday. It was called Tips & Tricks for Writing Better Queries. I really appreciated everyone who made the time to attend. I hope you found it to be time well spent.

As promised, here is a copy of the… Read more

0 comments, 339 reads

Posted in Joe Webb on 24 February 2011

How To Write Better Queries WebCast

One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek and an index scan.

Transact-SQL is easy to learn. But to truly get the best performance from your SQL Server you must have a good understanding beyond the basics… Read more

0 comments, 358 reads

Posted in Joe Webb on 22 February 2011

How Should the PASS Nominating Committee Be Selected?

Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its future leaders in the PASS organization. We started with a clean slate. Nothing in the existing process was considered sacred or off-limits. Nothing was considered out of scope. We want… Read more

0 comments, 323 reads

Posted in Joe Webb on 21 February 2011

The Importance Of Managing Expectations

Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an eye-opening experience!

Don’t misunderstand; I like soda. But when I’m expecting sweet tea, the normally pleasant taste of the carbonated beverage is face-wrenchingly awful.

Thus, the importance of expectations.

What…

Read more

0 comments, 303 reads

Posted in Joe Webb on 18 February 2011

Book Review: The Lazy Project Manager

“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that he’s not the origin of it. Whoever said it had a somewhat elitist or cynical perspective about the general population.

At times, however, the saying has proven itself… Read more

1 comments, 376 reads

Posted in Joe Webb on 15 February 2011

A NULL Is Not Unknown

Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.

Waiter, there's a NULL in my soup.

I’m not arguing whether or not NULLs in a database are good or bad. That discussion ranks up there with religion, politics, and… Read more

13 comments, 393 reads

Posted in Joe Webb on 11 February 2011

My devLINK Abstracts

For the past few years, I’ve spoken at a great event in Nashville called devLINK. I’ve really enjoyed speaking there.

Although it more developer oriented, it’s got a great SQLSaturday kind of feel. It’s heavily community oriented and has an intimate atmosphere about it. At 800 people, it’s also… Read more

0 comments, 388 reads

Posted in Joe Webb on 9 February 2011

A NULL Is Not Unknown

Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.

Waiter, there's a NULL in my soup.

I’m not arguing whether or not NULLs in a database are good or bad. That discussion ranks up there with religion, politics, and… Read more

0 comments, 393 reads

Posted in Joe Webb on 9 February 2011

Opportunity Cost versus Real Cost

One of the hardest lessons to learn and put into practice as a self-employed consultant is that of Real Cost versus Opportunity Cost.

Let’s consider an example.

Real Cost

Real Cost is straightforward. If the water pipes in my house freeze and burst due to the cold weather, I can… Read more

1 comments, 370 reads

Posted in Joe Webb on 8 February 2011

Using PowerShell To Search The Event Log

The “30-minute DBA” was operating in a highly effective mode. He’d automated most everything that could be automated. The first half hour of each day was spent reviewing the automated reports that landed in his inbox over night, taking actions as necessary. That’s why he’s paid the big bucks and… Read more

1 comments, 784 reads

Posted in Joe Webb on 7 February 2011

What SQL Server Service Pack Do I Have Installed?

If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that are automatically populated by SQL Server. Selecting the @@version function in a query window produces the following results on my system.

SELECT @@VERSION;
Microsoft SQL Server 2008 R2 (RTM)…

Read more

2 comments, 375 reads

Posted in Joe Webb on 3 February 2011

Meet Me In Florida!

While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.

I’m not just thinking of an escape from the cold, dreary weather that February brings with it. No, I’m thinking of the warm hospitality of sunny Orlando and SQLConnections.

I’m going… Read more

0 comments, 411 reads

Posted in Joe Webb on 2 February 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, 386 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, 338 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, 428 reads

Posted in Joe Webb on 14 January 2011

Older posts