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

Archives: February 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, 356 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, 374 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, 386 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, 369 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