Archives: March 2010
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)
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.
Frequently… Read more
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
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.…
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…
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
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