SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2010

SQL Saturday #29 Presentations & Twittering

Tomorrow, I’m presenting a couple of sessions at SQLSaturday #29 in Birmingham, Alabama. Here are the presentation materials I’ll use.


Read more

0 comments, 558 reads

Posted in Joe Webb on 26 March 2010

Adding a Column to Every Table

I am Script. I will update your database.

Despite the best laid plans, sometimes circumstances or project scope change and the definition of one or more tables in your database must be altered after they have been created. It’s just a fact of life for a DBA.

Change Happens

Frequently… Read more

13 comments, 639 reads

Posted in Joe Webb on 24 March 2010

Licensing SQL Server Reporting Services

I have my license here somewhere, officer.

Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? Active / Passive clustering? It can get very confusing, very quickly.

Recently, I… Read more

0 comments, 1,074 reads

Posted in Joe Webb on 19 March 2010

Speaking at SQLSaturday #29 in Birmingham, AL

On Saturday the 27th of March, I’m going to be presenting two sessions at SQLSaturday #29 in Birmingham, Alabama.

  • 1:30 PM: Tips and Tricks for Writing Better Queries. Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving.…

Read more

0 comments, 465 reads

Posted in Joe Webb on 15 March 2010

My Experience with a Virtual Assistant using TimeSvr

Predicting the future with bold certainty is not for the faint of heart. It’s a hard job. A few get it right; most just get egg on their face.

Want some examples?

  • In 1948, the Chicago Daily Tribune gambled that Dewey would beat Truman in the US Presidential election and…

Read more

0 comments, 943 reads

Posted in Joe Webb on 12 March 2010

SQL Server Locking & Block Scripts

A couple of weeks ago, I gave a presentation to the PASS DBA Virtual Chapter on SQL Server Locking & Blocking Made Simple.  The original post had a link to the presentation materials, but I neglected to attach the demo scripts. So, here they are:

To review… Read more

0 comments, 535 reads

Posted in Joe Webb on 8 March 2010

Mitigating Consulting Risks

In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought and planning, consulting may be even less risky than a traditional full-time job. I know that sounds counter intuitive and I hope to elaborate and clarify that a bit… Read more

3 comments, 1,192 reads

Posted in Joe Webb on 2 March 2010