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

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, 184 reads

Posted in Joe Webb on 7 January 2011

How To Choose A Topic For Speaking

“The human brain starts working the moment you are born and never stops until you stand up to speak in public.” observed Academy Award winning movie producer George Jessel. I think there is some truth to that for many of us.

As a regular speaker at conferences, SQLSaturdays, and other… Read more

1 comments, 142 reads

Posted in Joe Webb on 23 December 2010

2010: The Year In Review

“Quitting smoking is easy; I’ve done it dozens of times.” the great American writer Mark Twain once said.

Although I’ve never been a smoker, I can relate to Twain’s sentiment. Setting a goal for yourself can be easy. If taken lightly, goal setting can be little more than creating a… Read more

0 comments, 170 reads

Posted in Joe Webb on 15 December 2010

When Were The Statistics In SQL Server Last Updated?

When SQL Server receives a new query, the Query Optimizer undertakes the task of identifying a good plan to resolve the query. It considers a number of different factors as it analyzes the query and maps out a way in which to retrieve the information requested. Dr. DeWitt did an… Read more

2 comments, 217 reads

Posted in Joe Webb on 1 December 2010

Dynamic PowerShell

I learned something new while giving my PowerShell session at the PASS Community Summit a couple of weeks ago.

One astute attendee asked if it was possible to create dynamic PowerShell in a script. Or put another way, can you define a PowerShell statement in a variable and then tell… Read more

1 comments, 769 reads

Posted in Joe Webb on 23 November 2010

The World’s Largest

Each year, the Georgia Bulldogs and the Florida Gators meet on the college grid iron in what’s called the world’s largest cocktail party. I’ve never been; in fact I’m probably not welcomed since I’m an alumni of a rival school, the Auburn Tigers. War Eagle!

You Can’t Handle The SQL!

Read more

0 comments, 148 reads

Posted in Joe Webb on 16 November 2010

The PowerShell CookBook

“A script club.” That’s what a friend of mine said when he was telling me how he’d learned the basics of PowerShell. I did a double take. “You had a user group meeting at a strip club?!?!” He laughed and clarified, this time enunciating more clearly.

Last week at the… Read more

0 comments, 196 reads

Posted in Joe Webb on 15 November 2010

Join Me This Week At PASS

This week at the PASS Community Summit in Seattle, I’m delivering two full length sessions, one lightening session, and chairing a committee meeting to discuss the election process. If you’re attending the conference, I hope you’ll join me at one of these sessions.

Using Covering Indexes (Wed 1:30pm)

Covering… Read more

0 comments, 118 reads

Posted in Joe Webb on 9 November 2010

The Future Of PASS Elections

Am I stirring up a hornets nest or beating a dead horse bringing up a the PASS elections the day before over 2,500 SQL Server professional converge on Seattle for the 2010 PASS Community Summit? I’m not sure, but I suspect I’ll find out within 24 hours.

So, why… Read more

0 comments, 128 reads

Posted in Joe Webb on 8 November 2010

Vote For The SQLRally Pre-Con Seminars

Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.

In my consulting practice I’ve met a lot of them. They were once good technical people. So good in fact, they got promoted; it’s the natural progression in business. But… Read more

0 comments, 321 reads

Posted in Joe Webb on 27 October 2010

Where Is The SQL Server ErrorLog File?

I seldom lose things; I just cannot find them as quickly as I’d like. This is true for keys, tools, and yes even ErrorLog files on SQL Server.

On the servers that I configure, I have a standard way of doing things. I set them up using some industry best… Read more

0 comments, 481 reads

Posted in Joe Webb on 19 October 2010

Checking The Event Log With PowerShell

Good administrators work really hard so that they don’t have to work really hard. Well, that’s an oxymoronic statement if I’ve ever written one. So what do I mean?

Smart administrators are willing to spend time automating as much of their routine work as possible. Why go through the hassle… Read more

2 comments, 429 reads

Posted in Joe Webb on 13 October 2010

Lightening Talk Ka-chow! Ka-chow!

“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars. The ever astute Mater replies “You hurt your what?” I love that movie!

I often get a similiar response when I ask people about covering indexes. It’s not that… Read more

0 comments, 334 reads

Posted in Joe Webb on 12 October 2010

Lightening Talk On Covering Indexes Ka-chow! Ka-chow!

“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars. The ever astute Mater replies “You hurt your what?” I love that movie!

I often get a similiar response when I ask people about covering indexes. It’s not that… Read more

0 comments, 117 reads

Posted in Joe Webb on 12 October 2010

So I Got Promoted, Now What? Get To Know Your Peers

[This is part four in a series of posts about how to effectively transition to your new role after being promoted.]

Series Outline

Read more

3 comments, 346 reads

Posted in Joe Webb on 6 October 2010

The Lone Ranger And Data Integrity

Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the Lone Ranger stands to protect the unsuspecting townsfolk from the wayward derelicts that plagued the American frontier. He also ate bacon three meals a day.

Like the Lone Ranger, IT… Read more

9 comments, 899 reads

Posted in Joe Webb on 29 September 2010

Using Excel As A Reporting Services Datasource

It’s been said that Excel is the poor man’s database. I don’t know about that, but I can tell you that an awful lot of data lives in Excel spreadsheets in corporate America and around the world. Whether it’s project timelines or employee lists, many business depend on Excel.

This… Read more

0 comments, 298 reads

Posted in Joe Webb on 15 September 2010

A Community Divided

People have been screaming from rooftops for a month now about the PASS election process, ever since a beloved member of our SQL Server community was shunned in his bid to run for the PASS Board of Directors. The community has reacted vocally. PASS has reacted defensively. And unfortunately much… Read more

0 comments, 400 reads

Posted in Joe Webb on 3 September 2010

A PASSionate Community

Much has voiced about the Professional Association for SQL Server (PASS) Nominating Committee’s decision to not put Steve Jones (blog, twitter) on the ballot for this year’s Board of Directors election. I’ve watched this controversy unfold with great interest, biting my tongue to keep from… Read more

0 comments, 620 reads

Posted in Joe Webb on 31 August 2010

Twitter: The Next Best Thing To Being There

Why do DBAs want to go to PASS, TechEd, or SQLConnections? If asked, I suppose that many would point to the great technical content that’s available there. Others, when out of earshot from their employers, may admit to going solely to visit the city in which the event is held.… Read more

2 comments, 216 reads

Posted in Joe Webb on 24 August 2010

Newer posts

Older posts