Subscribe to this blog
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.
- SQL Server Locking & Blocking Made Simple (Presentation | Script 1 | Script 2)
- Tips & Tricks for Writing Better Queries (Presentation | Script)
Reaching…
0 comments, 107 reads
Posted in Joe Webb on 26 March 2010
Adding a Column to Every Table
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, 140 reads
Posted in Joe Webb on 24 March 2010
Licensing SQL Server Reporting Services
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, 166 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.…
0 comments, 85 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…
0 comments, 150 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, 112 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, 265 reads
Posted in Joe Webb on 2 March 2010